诛仙叁鲮鱼:abc = "select * from 医生信息 where 编号="&Text1.Text&" "

来源：百度文库编辑：高校问答时间：2024/04/28 16:49:37

注:想从列表中选取TEXT1输入的编号对应的用户,不知道怎么写才对,我是初学者,谢谢
谢谢,不过,我想就是用户在TEXT1.TEXT输入工号,就能直接对应验证密码是否正确,如果指定一条的话,只能让一个用户登陆了,

另外用您刚才的方法,怎么弹出一个缺少语句结束,呵呵,不知道怎么处理了,我是菜鸟没办法,谢谢了

abc = "select * from 医生信息 where 编号=" Text1.Text""

在表里建个ID列，每个ID编号对应一个用户。
abc = "select * from 医生信息 where 编号="&这里是用户的ID编号&" "

abc = "select * from 医生信息 where 编号="&Text1.Text&" " sql="select * from……" sql = "Select top 5 * from news" sql1 ="select * from news where feilei="& request("feilei") sql1 ="select * from news where feilei="& request("feilei") sql1 ="select * from news where feilei="& request("feilei") sql = "Select * From [userinfo] Where userid = '"&userid&"'" ； sql="select top 10 * from jjh_news where news_fenlei="&Request("news_fenlei") SqlDataAdapter temp_ada = new SqlDataAdapter("select TOP 17 * from "+Lei+"",temp_con); rs_s.open "select * from shjia where username='"&request.cookies("godbook")("shjianame")&"