asp.net操作SQL数据库update的问题
最近在学asp.net，使用的是vb.net来创建asp.net项目
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connstr As String
connstr = "server=(local);uid=login;pwd=login;database=integration "
Dim conn As SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connstr)
Try
conn.Open()
Label1.Text = "ok "
Catch ex As Exception
Label1.Text = "False "
End Try


Try
Dim comdstr As String
'comdstr = "insert into login_table values ( 'nilei ', '444 ', '1 ') "
comdstr = "update login_table set user= 'xiaoli ' where pwd= '444 ' "
Dim comd As SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(comdstr, conn)
comd.ExecuteNonQuery()
Label2.Text = "insert ok "
Catch ex As Exception
Label2.Text = ex.message ' "insert false "
Finally
conn.Close()
End Try


运行的时候提示错误：在关键字 'user ' 附近有语法错误。


请问我的代码有什么问题吗？

[解决办法]
User 是关键字

try ->

comdstr = "update login_table set [user]= 'xiaoli ' where [pwd]= '444 ' "
[解决办法]



哼哼，星星来抢裤衩的分


^_^