假设有表table包含列 col1,col2,col3,改表有5条纪录,怎么样把这5条记录的col1填充到combobox?
解决方案 »
- 关于瑞星的问题
- 送分,能解决文件打开关联的立即送100分。网上等!
- 高分请教一小问题,来着有分
- 数据库备份:问题如果是ACCESS数据库,直接备份MDB文件和用ADO备份有什么区别啊?
- 加 desc 排序后,为什么不能取前五条记录
- 在win98下安装的问题
- 各位大虾多多帮忙!
- 在vb中怎么将相对于1980年1月1日0分0秒的秒计数换算成日期?
- 10平方米大的空间能干什么
- 关于web browser的问题,期待大虾指点
- 显示器优化怪问题!!!!!!!!!!!!!!!
- 显示在LISTBOX控件上的只是表的字段,如现在只显示“课程名称”,而不显示语文、英语。。。。我是想取表的内容啊---应该怎么解决呀?
dim cnn as new adodb.connection
cnn.open "provider=msdasql.1;.................."
rst.open "select col1 from table",cnn,adopendynamic,adlockpessimistic
rst.movefirst
while not rst.eof
combobox.additem "" & rst.fields(0).value & ""
rst.movenext
wend
rst.close
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;"
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from employees", CN, adOpenDynamic, adLockBatchOptimistic
Do Until Rs.EOF
Combo1.AddItem Rs.Fields("FirstName")
Rs.MoveNext
Loop
CN.Close
dim conn as ADODB.Connection
dim rs as ADODB.Recordset Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
strSQL = App.Path & "\A.mdb"
strSQL = Replace(strSQL, "\\", "\")
With conn
If .State = adStateOpen Then
.Close
End If
.CursorLocation = adUseClient
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & strSQL
.Open
End With
With rs
.Open "SELECT Coll FROM Table;", conn, adOpenStatic, adLockOptimistic
If .BOF And .EOF Then
Exit Sub
End If
.MoveFirst
End With
Do Until rs.EOF
With Combo1
.AddItem rs.Fields("Coll")
rs.MoveNext
End With
Loop
'退出时
rs.close
conn.close
set rs=nothing
set conn=nothing