Weird Syntax Error

[Kerry Drake]

I am trying to write a simple procedure to update a record in a data base using the following:

Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
If m_dtEmployees.Rows.Count <> 0 Then
m_dtEmployees.Rows(m_rowPosition)("Employee") = txtEmployeeName.Text
m_dtEmployees.Rows(m_rowPosition)("Password") = txtPassword.Text
m_daDataAdapter.Update(m_dtEmployees)
End If
End Sub
End Class

If I make a change to the txtEmployeeName textbox and hit save it works fine. If I make a change in the txtPassword text box I get a Syntax error in UPDATE statement error. I used the m_dtEmployees.Columns.Contains method to check to make sure it saw "Password" as a column and it does... Any thoughts?

My goal in life is to be the kind of person my dog thinks I am.

[ctwalker]

By what you've posted I cant see anything that would be causing a problem. When I get errors like this I always look at the SQL command that is being executed. (Either by examining the Update command in the Adapter or by doing a trace on SQL and seeing what exactly is being executed. Try looking at that, and if you don't see anything wrong with the SQL, post it here and I'll check it out. Good luck.

[AlexeiXX3]

Have you tried EndEdit for the datarow just before the m_daDataAdapter.Update(m_dtEmployees)?

Alexei Rodriguez