如何将数据源连接到组合框 [英] how to connect data source to combobox

问题描述

朋友们，如何使用程序中的代码将数据库一个coluam数据连接到我的组合框

解决方案

尝试这样的事情： -

 Private Sub FillCombo（）
尝试
 Dim fillcon作为新的OleDbConnection（@Provider = Microsoft.Jet.OLEDB.4.0; Data Source =访问file.mdb的路径; ）
 Dim asql As String =（SELECT * FROM Items ORDER BY ItemName）
 Dim da As New OleDbDataAdapter（asql，fillcon）
 Dim ds As New DataSet 
 da .Fill（ds）
 ItemNameCombo.ValueMember =ItemName
 ItemNameCombo.DataSource = ds.Tables（0）
 ItemNameCombo.SelectedIndex = 0 
 Catch ex As Exception 
 MsgBox（ERROR：& ex.Message.ToString）
结束尝试
结束子

参考： -

http://www.dreamincode.net/forums/topic/207090-using-code-to-bind-combo-box-to-access-database/ [<一个href =http://www.dreamincode.net/forums/topic/207090-using-code-to-bind-combo-box-to-access-database/target =_ blanktitle =New Window> ^ ]

private void Bind_Combo（）

{

DataTable dt = new DataTable（）;

samplecontroller controller = new samplecontroller（）; //来自数据库的逻辑层调用（只是调用）

dt = controller.sample_Select（entity）; //你的数据源在这里输入

if（dt.Rows.Count> 0）

{

this.combobox.DataSource = dt ;

this.combobox.DisplayMember =sample_Name;

this.combobox.ValueMember =sample_ID;

}

this.combobox.Text =请选择;

}

推荐



binding-data-to-a-combo-box-in-访问 [ ^ ]

hi friends how can i connect database one coluam data to my combobox by using codes in program

解决方案

try something like this:-

Private Sub FillCombo()
        Try
            Dim fillcon As New OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path to access file.mdb;")
            Dim asql As String = ("SELECT * FROM Items ORDER BY ItemName")
            Dim da As New OleDbDataAdapter(asql, fillcon)
            Dim ds As New DataSet
            da.Fill(ds)
            ItemNameCombo.ValueMember = "ItemName"
            ItemNameCombo.DataSource = ds.Tables(0)
            ItemNameCombo.SelectedIndex = 0
        Catch ex As Exception
            MsgBox("ERROR : " & ex.Message.ToString)
        End Try
    End Sub

refer:-
http://www.dreamincode.net/forums/topic/207090-using-code-to-bind-combo-box-to-access-database/[^]

private void Bind_Combo()
{
DataTable dt = new DataTable();
samplecontroller controller = new samplecontroller (); //Your Logic layer call from database(just calling)
dt = controller.sample_Select(entity); //Your datasource is input here
if (dt.Rows.Count > 0)
{
this.combobox.DataSource = dt;
this.combobox.DisplayMember = "sample_Name";
this.combobox.ValueMember = "sample_ID";
}
this.combobox.Text = "Please select";
}

Refer

binding-data-to-a-combo-box-in-access[^]

这篇关于如何将数据源连接到组合框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！