Question

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs)

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim conn As New SqlConnection
conn.ConnectionString = ("Server=M\sqlexpress;DataBase=HRM_sq;Integrated security=SSPI ")
Dim strsql As String
strsql = "delete * from Customer where CustomerId=" & Request.QueryString("CustomerId")
Dim cmd As New SqlCommand(strsql, conn)
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
End Sub一个删除语句 应该是写错了 说我*附近有错误 不明白。。。

Answer 1

conn.Open()
这句写到
Dim strsql As String
前面试试

Answer 2

把*去掉试试！~