[RESOLVED] Syntax Error in UPDATE statement

[RichardKnox]

HI, I am unable to figure out why I am getting this error. Its probably simple, but I haven't found out how to fix it yet.


Here's the piece of code thats giving me the error.

Public Class DrugList
Private m_cnADONetConnection As New OleDb.OleDbConnection() 
Private m_daDataAdapter as OleDb.OleDbDataAdapter
Private m_cbCommandBuilder as OleDb.OleDbCommandBuilder
Private m_dtDrugs as New DataTable
Private m_rowPosition as Integer = 0

----------------------------------------------------------------------------------------------------------
Private Sub btnSave ()

If m_dtDrugs.Rows.Count <> 0 then
m_dtDrugs.Rows(m_rowPosition) ("YesNo") = txtYorN.Text
m_daDataAdapter.Update(m_dtDrugs)  <----------------------This is the line that throws the error.
End if
End Sub
End Class

I am able to access the database, work my way through the data, add data, but when I attempt to update the data, I get the error.

So, I know I am accessing the database, but Im not sure why it keeps giving me the error in the Subject line.

Any help would be greatfully received.

Thanks,
Richard