Ado.net: how to assign the column value in a datatable to combobox.?

[ssknov]

hi all
i want to show a column value from datatable.I tried as below . it doesnt shows the values.

pls help.

 
 
                SqlDataAdapter adpt = new SqlDataAdapter(cmd);
                DataTable dtCust1 = new DataTable("CustomerDatTab");
                adpt.Fill(dtCust1);
 
                  dataGridView1.DataSource=dtCust1; //datagrid shows data.
 
 
               DataRow dr = new DataRow();
             foreach (DataRow dr in dtCust1.Rows)
                  comboBox1.Items.Add(dr.ToString());
 
the below code also didnt works. it tried in the below way also
                   //comboBox1.DisplayMember = "CompanyName";
                //for (int i = 0; i < dtCust1.Rows.Count - 1; i++)
                     //comboBox1.Items.Add(dtCust1);
 
 
                comboBox1.DataSource = dtCust1.DefaultView;
 
 
 
 
 

thank u

[nateraaaa]

DataRow dr = new DataRow();
foreach (DataRow dr in dtCust1.Rows)
comboBox1.Items.Add(dr.ToString());

the below code also didnt works. it tried in the below way also
//comboBox1.DisplayMember = "CompanyName";
//for (int i = 0; i < dtCust1.Rows.Count - 1; i++)
//comboBox1.Items.Add(dtCust1);

Actually both ways should work if coded correctly

foreach(DataRow dr in dtCust1.Rows)
{
combobox1.Items.Add(dr["columnname"].ToString());
}
 

or

for(int i=0; i<dtCust1.Rows.Count - 1;i++)
{
combobox1.Items.Add(dtCust1.Rows[i]["columnname"].ToString());
}

No DataBind is necessary if you are adding items to your combobox in this manner. If you are going to use a stored procedure to add these items to your combobox then you will need to assign a datasource to the combobox and set the text and value properties of the combobox.

Nathan

[kunal pawar]

'Bind the DataTable to the ComboBox
ComboBox1.DataSource = dtCust1
ComboBox1.DisplayMember = "FirstName"
ComboBox1.ValueMember = "ID"

u can directly bind combo box to the data table

refer link

http://www.java2s.com/Code/VB/Database-ADO.net/DatabaseDataBindingComboBox.htm