UC知道高手帮我忙啊! VB.NET编的登入代码出现问题
来源：百度知道 编辑：UC知道 时间：2024/07/07 23:24:29
sql的连接:
'SqlConnection1
'
Me.SqlConnection1.ConnectionString = "data source=(local);initial catalog=oneearth;integrated security=SSPI;persist sec" & _
"urity info=False;workstation id=ADMIN-33583C872;packet size=4096"
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
user_id = TextBox1.Text
password = TextBox2.Text
Dim id As String
Dim pw As String
If RadioButton1.Checked = True Then
id = "select * from user_infor where 用户名='" & user_id & "'"
pw = "select * from user_infor where 密码='" & password & "'"
ElseIf RadioButton2.Checked = True Then
id = "select * from admin where 用户名='" & user_id & "'"
pw = "select *
'SqlConnection1
'
Me.SqlConnection1.ConnectionString = "data source=(local);initial catalog=oneearth;integrated security=SSPI;persist sec" & _
"urity info=False;workstation id=ADMIN-33583C872;packet size=4096"
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
user_id = TextBox1.Text
password = TextBox2.Text
Dim id As String
Dim pw As String
If RadioButton1.Checked = True Then
id = "select * from user_infor where 用户名='" & user_id & "'"
pw = "select * from user_infor where 密码='" & password & "'"
ElseIf RadioButton2.Checked = True Then
id = "select * from admin where 用户名='" & user_id & "'"
pw = "select *
把针对数据库的地方做的声明都new了试试
而且你的SQL文好像有问题。'用户名'列看看是不是不存在或是查询时出现了多个。
列名 '用户名' 无效。
说明数据库中不存在'用户名'这列