syntax error in update statement
Using visual studio 2003 and access data base, Column password datavalue is set as text. when I run command I get "syntax error in update statement"
[Code}
Dim CMD As OleDb.OleDbCommand = New OleDb.OleDbCommand
Try
conSamson.Open()
With CMD
.Connection = conSamson
.CommandType = CommandType.Text
.CommandText = "update tblusers set Password = ' " & txtPassword.Text & " ' WHERE FirstName = ' " & txtFirstName.Text & " ';"
.ExecuteNonQuery()
EndWith
Catch ex As Exception
MessageBox.Show(ex.Message, ex.GetType.ToString)
EndTry
[/code]
__________________
yvk
|