1,217
社区成员
发帖
与我相关
我的任务
分享求教：要将sql查询到的某个字段的值显示到文本框里该怎么做？
比如：select kh_mc from kh where kh_khid='0000001'
将该记录的kh_mc的字段值显示到文本框里该怎么做？
将该记录的kh_mc的字段值显示到文本框里该怎么做？
...全文
请发表友善的回复…
发表回复
online 2004-08-24
- 打赏
- 举报
strsql = "select kh_mc from kh where kh_khid='0000001'"
Set rs = New ADODB.Recordset
rs.Open strsql, conn, 1, 3
Text1.Text =rs.Fields("kh_mc")
Set rs = New ADODB.Recordset
rs.Open strsql, conn, 1, 3
Text1.Text =rs.Fields("kh_mc")
yassee 2004-08-24
- 打赏
- 举报
dim rs as new adodb.Recordset
rs.open "select kh_mc from kh where kh_khid='0000001'",cn
text1.text=rs!kh_mc
rs.close
set rs=nothing
^_~
rs.open "select kh_mc from kh where kh_khid='0000001'",cn
text1.text=rs!kh_mc
rs.close
set rs=nothing
^_~
of123 2004-08-24
- 打赏
- 举报
text1 = rs.fields("kh_mc ")
