Updating access database using datatable adewale akinnuoye agbaje dating

Add(dt) da = New Ole Db Data Adapter("Select * from table Student Details", con) da.

Close() End Sub Private Sub cmd Update_Click(sender As Object, e As Event Args) Handles cmd Update.

I get an Exception on certain tables that, after searching, I found Microsoft Support - Syntax Error.

updating access database using datatable-27updating access database using datatable-26

So here is what i'm trying to do: Dim s SQL As String = "SELECT * FROM tbl Cars" Dim da As New Ole Db. Add(ds New Row) 'end loop 'update the database with the new rows da.

Try doing a full qualification of the column name i.e.

var microsoft = microsoft

Leave a Reply