ช่วยดูโค๊ดให้หน่อยคับ มันขึ้น Syntax error in UPDATE statement.
Code (VB.NET)
Dim conn As New System.Data.OleDb.OleDbConnection
Dim comm As New System.Data.OleDb.OleDbCommand
Dim dr As System.Data.OleDb.OleDbDataReader
Dim Upd As New System.Data.OleDb.OleDbCommand
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
conn.Open()
Upd.CommandText = "UPDATE tbLogin SET Password = ' " & (txtNewPassword.Text).ToLower & _
" ' WHERE Username = ' " & txtUsername.Text & " ' "
Upd.Connection = conn
Upd.ExecuteNonQuery()
conn.Close()
End Sub