data binding multiple combo boxes

EDN Admin · Mar 18, 2006

I am using the following coee to bind a combo box on a form and i want to bind more boxes (I have 7 combos on one form).

each combo reads from a different table but in the same database.

how can i modify the code to add combo2 wihout slowing the performance of form loading?

//Connect to the Sales database 
//Read in all of the Customers from the Customer table 
// into a Dataset (an in-memory relational 
//database. 
//Run through this dataset, adding their names to the combobox. 
//We can blow away the dataset at that point. 
//declare these outside the try so we can close them off in the finally clause. 
SqlConnection oConnection = null;
DataSet oCustomersDataSet = new DataSet();
try 
{
//ensure the box is cleared 
cboCombo.Items.Clear();
//set up the connection 
oConnection = new SqlConnection("Server=KOBNA\SQLEXPRESS;Database=shefa;User ID=sa;Password=111111;Trusted_Connection=False");
//set up the data adapter to get us our data... 
//Adapters xfer data to/from Database and Dataset. 
SqlDataAdapter oDataAdapter = new SqlDataAdapter();
string sCommand = "SELECT * FROM marital_status";

oDataAdapter.SelectCommand = new
SqlCommand(sCommand,oConnection);
//use the data adapter to fill the dataset with the result 
// of that SQL statement 
//Note we have changed the table name so that in memory we run 
// off the BoxCustomers 
//table...just to make the point that we are working off a 
// construct of our own devising. 
oDataAdapter.Fill(oCustomersDataSet, "marital_status");
//can now close the database connection, well work off the dataset 
// which is in memory. 
oConnection.Close();
//we are now disconnected. 
//put the data from the dataset into the combobox 
DataTable oDataTable = oCustomersDataSet.Tables["marital_status"];
if (oDataTable == null)
throw new Exception("BoxCustomers table not found in oCustomersDataSet.");

cboCombo.DataSource = oDataTable;
cboCombo.DisplayMember = "marital_status";
//the finally clause will tidy up for us. 
cboCombo.SelectedIndex = 0;
}
catch (Exception oE)
{
MessageBox.Show("Problem Populating Dataset Box: [" + oE.ToString() + "]");
}
finally 
{
//clear the inmemory data in the dataset, and close the database 
// connection, if its open. 
if (oConnection!= null)
{
if (oConnection.State == ConnectionState.Open) oConnection.Close();
}
} 

View the full article

data binding multiple combo boxes

EDN Admin

Well-known member

Similar threads