我在VB的表单中安装上Adodc1控件,与一个mdb数据库连接。然后又安装一个列表框Lise1,
对其DataSource属性和DataField属性进行设置,与Adodc1控件进行绑定,运行时列表框中
什么数据也没有显示,请教:这是什么原因,应如何设置?
(在表单中安装TextBox和ComboBox,进行上述设置时都能正常运行。)
对其DataSource属性和DataField属性进行设置,与Adodc1控件进行绑定,运行时列表框中
什么数据也没有显示,请教:这是什么原因,应如何设置?
(在表单中安装TextBox和ComboBox,进行上述设置时都能正常运行。)
现在问题是如何把列表框List1和控件Adodc1进行数据绑定。请各位高手指教。
绑定不好
给你个例子Dim rs As ADODB.Recordset
Dim msgtext As StringPrivate Sub Form_Load()
strsql = "select * from dw_table "
Set rs = ExecuteSQL(strsql, msgtext)
Do While Not rs.EOF
List1.AddItem rs.Fields("dw_mc")
rs.MoveNext
Loop
End Sub'下面的代码是连接数据库及读sql语句的类模块
Dim msgtext As String
Dim mrc As ADODB.RecordsetPublic Function ExecuteSQL(ByVal sql As String, MsgString As String) As ADODB.Recordset
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim sTokens() As String
'Dim SQL As String
On Error GoTo ExecuteSQL_Error
sTokens = Split(sql)
Set cnn = New ADODB.Connection
cnn.Open ConnectString
If InStr("INSERT,DELETE,UPDATE", UCase$(sTokens(0))) Then
cnn.Execute sql
MsgString = sTokens(0) & "query successful"
Else
Set rst = New ADODB.Recordset
rst.Open Trim$(sql), cnn, adOpenKeyset, adLockOptimistic
Set ExecuteSQL = rst
MsgString = "查询到" & rst.RecordCount & "条纪录"
End If
ExecuteSQL_Exit:
Set rst = Nothing
Exit Function
Set cnn = Nothing
ExecuteSQL_Error:
MsgString = "查询错误:" & Err.Description
Resume ExecuteSQL_Exit
End FunctionPublic Function ConnectString() As String
ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\计划管理系统.mdb;Persist Security Info=False"
End Function
你自己试试吧,
提取记录集以后
with rs
While Not rs.EOF
List1.AddItem rs.Fields("dw_mc")
rs.MoveNext
wend
end with