oledbcommand

  1. G

    Question INSERT INTO exception

    Hi, everybody, i've dev a program that access to an mdb database and insert a new record with the command INSERT INTO but when i execute the db command with ExecuteNonQuery the program catch an exception that i did not understand. I post the oledbcommand line and the fields of the access mdb...
    • gwbasic
    • Thread
    • access exception insert new record oledbcommand
    • Replies: 2
    • Forum: MS Access
  2. J

    Question using OleDbCommand

    hi, i am trying to insert some data from a dataset into a database. i have used the following code that works absolutly fine. For Each dr In myDataSet.Tables(0).Rows strSQL = "INSERT INTO [~AgeBandsEmpty] (a,b,c) VALUES ('" & dr ("a") & "','" & dr ("b") & "','" & dr ("c") & "')"...
Back
Top