Question

ASP.net+VB.net谁告诉我这段程序里面哪里错了啊?我运行总是说我在关键字 'user' 附近有语法错误。 救命啊~

Dim ds As DataSet = New DataSet
Dim da As SqlDataAdapter = New SqlDataAdapter("select * from user where userid='Txtid.Text 'and userpassword='Txtpassword.Text'+and titles='titlelist.SelectedValue'", conn)
conn.Open()
da.Fill(ds, "user")
If ds.Tables(0).Rows.Count = 0 Then
Response.Write("<script>alert('输入信息错误，请重新输入');</script>")
Else
Response.Write("<script>alert(' 登陆成功!');</script>")
Session("user_id") = Txtid.Text
Response.Redirect("tsmain.aspx")
'将连接导向至教师与学生登陆界面 tsmain.aspx
End If
conn.Close()
ds.Clear()
ds = Nothing
显示错误的时候da.fill(ds."user")显示为红色,但是提示说是关键字user附近有错误~~怎么回事啊~~

Answer 1

这条语句改成:

Dim da As SqlDataAdapter = New SqlDataAdapter("select * from user where userid='"+Txtid.Text+"'and userpassword='"+Txtpassword.Text+"'and titles='"+titlelist.SelectedValue+"'", conn)

如果还不行试试这个:
Dim da As SqlDataAdapter = New SqlDataAdapter("select * from user where userid='"& Txtid.Text &"'and userpassword='"& Txtpassword.Text&"'and titles='"& titlelist.SelectedValue &"'", conn)