您所在位置：主题：UPDATE 语句的语法错误 请教高手！！！！！
zm221
[专家分：50] 发布于 2005-10-27 10:55:00
我用以下代码编写修给数据库可运行时，老提示错误UPDATE 语句的语法错误 ，请问高手，我代码那里有错
Dim update As String
update = " update mima set (学号='" & xuehao.Text & "','姓名=" & xingming.Text & "',密码='" & mima.Text & "',电话='" & dianhua.Text & "'') where 学号='1'"
Dim dbconn As OleDb.OleDbConnection
Dim dbcommand As OleDb.OleDbCommand
dbconn = New OleDb.OleDbConnection("Provider=" & "Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("22.mdb"))
dbcommand = New OleDb.OleDbCommand(update, dbconn)
dbcommand.Connection.Open()
dbcommand.ExecuteNonQuery()
Dim update As String
update = " update mima set (学号='" & xuehao.Text & "','姓名=" & xingming.Text & "',密码='" & mima.Text & "',电话='" & dianhua.Text & "'') where 学号='1'"
Dim dbconn As OleDb.OleDbConnection
Dim dbcommand As OleDb.OleDbCommand
dbconn = New OleDb.OleDbConnection("Provider=" & "Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("22.mdb"))
dbcommand = New OleDb.OleDbCommand(update, dbconn)
dbcommand.Connection.Open()
dbcommand.ExecuteNonQuery()
