就命: VB 问题

来源:百度知道 编辑:UC知道 时间:2024/05/20 01:00:42
name2 = Text1.Text
name3 = Text2.Text
Adodc1.RecordSource = "select *form user_table where ID link='" & nane2 & "' and where password link='" & name3 & "'"
Adodc1.Refresh
If Adodc1.Recordset.EOF Then MsgBox "对不起,工号或密码不正确,请重新输入!"
看看哪出错了

"select *form user_table where ID link='" & nane2 & "' and where password link='" & name3 & "'"
把后面的where去掉就可以了

郁闷....
Adodc1.RecordSource = "select *form user_table where ID link='" & ****nane2**** & "' and where password link='" & name3 & "'"

***nane2***应该是 name2 吧