i get this error when i click on my update button:
Syntax error in UPDATE statement.
my primary key is in column(0) but i hide this column from the user
am i setting up my update command correctly?
vb.net Code:
Private cnxnString As String = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\SaturationTags.mdb") Private cnxn As New System.Data.OleDb.OleDbConnection(cnxnString) Private sql As New System.Data.OleDb.OleDbCommand Private myDataAdapter As New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [tblFields]", cnxn) Private cmdBuilder As New System.Data.OleDb.OleDbCommandBuilder(myDataAdapter) Private dbTable As New DataTable Public Sub frmDisplayFields_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load myDataAdapter.Fill(dbTable) With DataGridView1 .DataSource = dbTable .AllowUserToAddRows = False .AllowUserToDeleteRows = False .AllowUserToOrderColumns = False .AllowUserToResizeColumns = False .AllowUserToResizeRows = False .Columns(0).Visible = False .Columns(1).ReadOnly = True .Columns(2).Width = 200 End With End Sub Private Sub cmdDone_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdDone.Click myDataAdapter.UpdateCommand = cmdBuilder.GetUpdateCommand myDataAdapter.Update(dbTable) End Sub




Reply With Quote