如何从ms访问中检索数据到dropdownlist控件中 [英] how to retrieve data from ms access into dropdownlist control

问题描述

如何从ms访问中检索数据到dropdownlist

how to retrieve data from ms access into dropdownlist

推荐答案

使用以下几行完成任务.
昏暗的cnnOLEDB作为新的OleDbConnection
昏暗的cmdOLEDB作为新的OleDbCommand
将结果集昏暗为新数据集
将Dim oData作为新的OleDbDataAdapter

Dim strConnectionString ="Provider = Microsoft.Jet.OLEDB.4.0;数据源= D:\ Documents and Settings \ Rs008 \ My Documents \ TestDB.Mdb;"

cnnOLEDB.Open()
oData =新的OleDbDataAdapter("SELECT * FROM TableName"，cnnOLEDB)
oData.Fill(resultSet，"TableName")

dropdownlist1.DisplayMember = resultSet.Tables(0).Column("ColumnName1")
dropdownlist1.ValueMember = resultSet.Tables(0).Column("ColumnName2")

Raja.S

Use the Following Lines TO Finish ur task.
Dim cnnOLEDB As New OleDbConnection
Dim cmdOLEDB As New OleDbCommand
Dim resultSet As New DataSet
Dim oData As New OleDbDataAdapter

Dim strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Documents and Settings\Rs008\My Documents\TestDB.Mdb;"

cnnOLEDB.Open()
oData = New OleDbDataAdapter("SELECT * FROM TableName", cnnOLEDB)
oData.Fill(resultSet, "TableName")

dropdownlist1.DisplayMember=resultSet.Tables(0).Column("ColumnName1")
dropdownlist1.ValueMember=resultSet.Tables(0).Column("ColumnName2")

Raja.S

这篇关于如何从ms访问中检索数据到dropdownlist控件中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！