Private Sub Form_Load()
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset
Dim CnStr As String, Sql As String
CnStr = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=pubs;Data Source=192.168.0.1"
conn.Open CnStr
Sql = "select au_id from authors"
Set rs = New ADODB.Recordset
rs.Open Sql, conn, 1, 3End Sub
rs.Open Sql, conn, 1, 3如何把sql杳询的结果放到text1.text中?
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset
Dim CnStr As String, Sql As String
CnStr = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=pubs;Data Source=192.168.0.1"
conn.Open CnStr
Sql = "select au_id from authors"
Set rs = New ADODB.Recordset
rs.Open Sql, conn, 1, 3End Sub
rs.Open Sql, conn, 1, 3如何把sql杳询的结果放到text1.text中?
解决方案 »
- 关于win7下安装软件的错误提示
- 《弱的问题》对象变量或With块变量未设置 这个问题怎么解决~!~~~
- 请问:有谁知道袁飞打印控件3.0在WIN2000下如何使用自定义纸张
- vba控制word,怎样让WORD窗体大小不能改变,即禁止resize事件?
- 使用Internet Transfer控件 如何指定ascii传输方式
- 请问如何调用CHM帮助文件啊!!
- Access数据库的问题
- 请问如何使用vb调用扫描仪的驱动程序
- 请问程序发布的问题?VB程序怎样做安装包?
- Foxmai中为何发不出邮件
- 高分求助:如何封闭本地端口 请进来看看,分不够再加!谢谢
- 为什么我的vb编译的时候提示我trim函数不认识?
dim ii as longdim s as long
dim ss as longdim str as stringrs.movefirsts=rs.recordcount
ss=rs.fields.countfor i=1 to s
for ii=1 to ss
str=str & "," & rs.fields(ii-1) & ""
next
str=mid(str,2,len(str)) & vbcrlf '去掉最左边的逗号,并添加换行
nexttext1.text=str
可以把这两句说清楚一点嘛,我有点不太懂
把各字段连接成一个串.用,分隔
因为这样第一个字符就是,了.因为str初值为空.
str=mid(str,2,len(str)) & vbcrlf '去掉最左边的逗号,并添加换行
这句就是去掉上面,的.-------------解释了一下楼上的楼上.
如下:
Private Sub Form_Load()
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset
Dim CnStr As String, Sql As String
CnStr = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=pubs;Data Source=192.168.0.1"
conn.Open CnStr
Sql = "select au_id from authors"
Set rs = New ADODB.Recordset
rs.Open Sql, conn, 1, 3End Sub'=====================下面对你的记录集进行利用
.................
rs.movefirst
text1.text=rs.fields(0) '<==============第一条记录的au_id,需要后面的,就rs.movenext,只
................. ' 要用这个字段就OK了.