Dim sql2 As String
sql2 = "UPDATE 权限 SET password ='" & TextBox3.Text & "' WHERE ID ='" & TextBox1.Text & "'"
Dim Cmd2 As OleDb.OleDbCommand
Cmd2 = New OleDb.OleDbCommand(sql2, Conn)
Cmd2.CommandText = sql2
Cmd2.CommandType = CommandType.Text
Cmd2.ExecuteNonQuery() //此处报错
MessageBox.Show("密码修改成功!", "确定", MessageBoxButtons.OKCancel)
Dim f1 As New Form1
f1.Show()
Me.Hide()
这是部分代码,功能是实现修改密码,但老是报错。学生狗急需帮助
password是关键子,要转义
id是字符串么?如果数字不要引号。