我刚开始学asp.net,现在碰到这么一个问题,以下是代码
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sql As String
sql ="update member set account='"&account.text&"',pwd='"&pwd.text&"',name='"&name.text&"',tel='"&phone.text&"',address='"&address.text&"',zip='"&zip.text&"' from member where id=" & memberlist.SelectedItem.Value
Dim conn As New SqlConnection("……")
Dim comm As New SqlCommand(sql, conn)
Try
conn.Open()
Dim updated As Integer
updated = comm.ExecuteNonQuery
status.Text = "成功更新"
Catch ex As Exception
status.Text = "发现错误"
End Try
conn.Close()
End Sub他提示是sql语句那里错误,&字符与声明的类型不符,可是我以前写程序的时候都是这样写的呀,请问那里错了,在线等
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sql As String
sql ="update member set account='"&account.text&"',pwd='"&pwd.text&"',name='"&name.text&"',tel='"&phone.text&"',address='"&address.text&"',zip='"&zip.text&"' from member where id=" & memberlist.SelectedItem.Value
Dim conn As New SqlConnection("……")
Dim comm As New SqlCommand(sql, conn)
Try
conn.Open()
Dim updated As Integer
updated = comm.ExecuteNonQuery
status.Text = "成功更新"
Catch ex As Exception
status.Text = "发现错误"
End Try
conn.Close()
End Sub他提示是sql语句那里错误,&字符与声明的类型不符,可是我以前写程序的时候都是这样写的呀,请问那里错了,在线等
加到这里
这个SQL还有From Table吗???
笔误!!!
太粗心了