Dim rst As ADODB.Recordset
Set rst = gCnn.Execute("select field1 from table") 'gCnn--connection对象1.用ListBox
Do Until rst.EOF
listbox1.AddItem rst!field1
rst.MoveNext
Loop2.用DataList
With DataList1
.BoundColumn = "field1" '绑定字段
Set .DataSource = rst '绑定记录集
.ListField = "field2" '显示字段
Set .RowSource = rst '显示记录集
End With
Set rst = gCnn.Execute("select field1 from table") 'gCnn--connection对象1.用ListBox
Do Until rst.EOF
listbox1.AddItem rst!field1
rst.MoveNext
Loop2.用DataList
With DataList1
.BoundColumn = "field1" '绑定字段
Set .DataSource = rst '绑定记录集
.ListField = "field2" '显示字段
Set .RowSource = rst '显示记录集
End With
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货