Currently using ASP.net 2005
I am havin an errot in update statement my code is:
Dim myConnection As OleDbConnection
Dim myCommand As OleDbCommand
Dim ssql As String = "UPDATE passwrd SET password ='" + TextBox1.Text + "'where username='" + TextBox2.Text + "'"
myConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source=" & Server.MapPath("App_Data\pass.mdb") & ";")
MsgBox(ssql)
myCommand = New OleDb.OleDbCommand(ssql, myConnection)
myConnection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()
Its showing syntax error in UPDATE satement