To populate ComboBox we have to add the values of DataRows to it.

//connecting to database and copying record to DataAdapter
string strConnection = "Server=abc\\SQLEXPRESs;Database=Employee;Trusted_Connection=True";
            SqlConnection con = new SqlConnection(strConnection);
            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.

  Modified On Nov-29-2017 03:23:30 PM

Leave Comment