Private Sub cmdsearch_Click()
Dim cmd As Command
Dim xs_no As String
Dim err As ADODB.Error
Set cmd = New Command
Set rs = New Recordset
xs_no = String(txtxs_no.Text)
With cmd
.ActiveConnection = cn
.CommandText = "select*from xs where xs_no=?"
.CreateParameter , adChar, adParamInput, 6
End With
cmd.Parameters(0) = xs_no
Set rs = cmd.Execute
Set txtxs_no.DataSource = rs
Set txtxs_name.DataSource = rs
Set txtxs_sex.DataSource = rs
Set txtxs_jg.DataSource = rs
Set txtxs_csny.DataSource = rs
Set txtxs_dh.DataSource = rs
Set txtxs_zy.DataSource = rs
Set txtxs_rxsj.DataSource = rs
Set txtxs_bysj.DataSource = rs
Set txtxs_zsf.DataSource = rs
Set txtxs_bz.DataSource = rs
End Sub
这段代码是一段搜索代码,运行时提示xs_no = String(txtxs_no.Text)这句语法错误啊!
我怎么也想不明白啊!各位大哥帮帮我好了!
Dim cmd As Command
Dim xs_no As String
Dim err As ADODB.Error
Set cmd = New Command
Set rs = New Recordset
xs_no = String(txtxs_no.Text)
With cmd
.ActiveConnection = cn
.CommandText = "select*from xs where xs_no=?"
.CreateParameter , adChar, adParamInput, 6
End With
cmd.Parameters(0) = xs_no
Set rs = cmd.Execute
Set txtxs_no.DataSource = rs
Set txtxs_name.DataSource = rs
Set txtxs_sex.DataSource = rs
Set txtxs_jg.DataSource = rs
Set txtxs_csny.DataSource = rs
Set txtxs_dh.DataSource = rs
Set txtxs_zy.DataSource = rs
Set txtxs_rxsj.DataSource = rs
Set txtxs_bysj.DataSource = rs
Set txtxs_zsf.DataSource = rs
Set txtxs_bz.DataSource = rs
End Sub
这段代码是一段搜索代码,运行时提示xs_no = String(txtxs_no.Text)这句语法错误啊!
我怎么也想不明白啊!各位大哥帮帮我好了!
解决方案 »
- VB的单位问题
- 一个VB程序的性能问题
- 谁可以告诉我datarepeater的使用方法给我啊?
- webbrowser控件怎样修改已打开网页的某个数据?
- 用API把combox的列表自动打开.那关闭列表?的API常数是?CSDN的查找不能用!
- 请问用Random方式打开的文件.....用GET方法读取文件的一行.....怎么将这一行的数据分开
- 一个datareport相关问题
- ListView的大难题?
- boyboy又要高分请教各位高手啦,100分喔,还不快进来看一看!
- how to get the curren coordinates of form position.thanks
- 看看这段代码!!
- Word自动批量生成信封的问题
直接txtxs_no.Text=trim$(rs.fields("字段").value & "")不就行了麼
这句话中的CN有否定义??
感觉应该是:
xs_no = Trim(txtxs_no.Text)
意思是去掉前导与后导空格.