To populate ComboBox we have to add the values of DataRows to it.
Example
//connecting to database and copying record to DataAdapter
string strConnection = "Server=abc\\SQLEXPRESs;Database=Employee;Trusted_Connection=True";
SqlConnection con = new SqlConnection(strConnection);
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from employee", con);
DataSet ds = new DataSet();
da.Fill(ds, "Employee");
DataTable dt = ds.Tables["Employee"];
DataRow row;
//populating combobox.
for (int i = 0; i < dt.Rows.Count; i++)
{
//this will run for all rows present in table.
row = dt.Rows[i];
//adding items to combobox one by one.
cbID.Items.Add(row[0].ToString());
}
Anonymous User
20-Mar-2019Thank You for sharing.
Sushant Mishra
16-Jul-2017It was really helpful to read this post.