新手问题,各位帮忙,在线等 试一试把student_ID改为字符型,然后txtSQL="Select * from student_Info Where student_ID=1"看看你上边那个最后有个空格。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 加两个方括号试试txtSql="Select * From Student_Info Where [Student_ID] = 1 改正是:student_Info where student_ID='1'" data1=txtSQL?如果Data1是DAO控件的话,应该是Data1.recordsource=txtsql 谢谢各位,我还是把源码贴上吧...txtSQL = "select * from student_Info where student_ID = '" & (CInt(txtSID.Text)) & "'"Data1.RecordSource = txtSQLData1.Refresh...方括号我加过,不管事还请指点!谢 student_ID 字段是数据型用txtSQL ="select * from student_Info where student_ID = " & (CInt(txtSID.Text)) student_ID 字段是字符型才用txtSQL = "select * from student_Info where student_ID = '" & (CInt(txtSID.Text)) & "'" txtSQL = "select * from student_Info where student_ID = '" & (CInt(txtSID.Text)) & "'"改为txtSQL = "select * from student_Info where student_ID = " & txtSID.Text即可 txtSQL = "select * from student_Info where student_ID = " & (CInt(txtSID.Text)) & "" 问题出在哪一行上?是txtSQL = "select * from student_Info where student_ID = '" & (CInt(txtSID.Text)) & "'"还是Data1.Refresh?是否Cint(txtSID.text)的错误? txtSQL = "select * from student_Info where student_ID = '" & txtSID.TextCint后是个INT型数值,他不能和一个字符串连接啊。 txtSQL = "select * from student_Info where student_ID = '" & txtSID.TextCint后是个INT型数值,他不能和一个字符串连接啊。 txtSQL = "select * from student_Info where student_ID = " & Val(txtSID.Text) & "" 问题出在那?是txtSQL=…………还是DATA1.refresh是否txtSID.text的数据类型不正确,不能转换为INT型改成CINT(val(txtSID.Text))试试 vb来修改ie代理服务器里的设置 求助如何在EXE程序安装过程中自动注册mswinsck.ocx控件! 如何编写卡拉OK程序? 怎么刷新mshflexgrid呀 有谁知道怎么用vb让做出来的软件的外观(图标、边框)换得更好看一点? 请问一下高手 grid的问题! *************2000分求救!!!SOS!!!************** DBGrid显示表遇到的问题 过程的形参是数组,调用时参数应该如何写 请问如何把recordset的内容写道txt文件里(字段间空格,记录间回车还行) 请问如何将excel文件转换成txt文件 ,急急急....... 求救!这段代码有什么错?
txtSql="Select * From Student_Info Where [Student_ID] = 1
student_Info where student_ID='1'"
...
txtSQL = "select * from student_Info where student_ID = '" & (CInt(txtSID.Text)) & "'"
Data1.RecordSource = txtSQL
Data1.Refresh
...
方括号我加过,不管事
还请指点!谢
txtSQL ="select * from student_Info where student_ID = " & (CInt(txtSID.Text))
student_ID 字段是字符型才用
txtSQL = "select * from student_Info where student_ID = '" & (CInt(txtSID.Text)) & "'"
改为
txtSQL = "select * from student_Info where student_ID = " & txtSID.Text
即可
是txtSQL = "select * from student_Info where student_ID = '" & (CInt(txtSID.Text)) & "'"
还是
Data1.Refresh?是否Cint(txtSID.text)的错误?
是txtSQL=…………
还是DATA1.refresh是否txtSID.text的数据类型不正确,不能转换为INT型
改成CINT(val(txtSID.Text))试试