Problem populating multiple Combobox from Access Database..................pls help...........!!!

[Verghese]

Multiple combo-boxes are being populated using a single Access database.........but everytime I select any of the combo-box, the values in all other combo boxes also changes accordingly........since I want to generate a report using multiple selections of combo-box I want all combo-boxes to have different values of my choice.......how can i do that.........pls help me out.......!!! - Thanks

[Lost User]

You asked the same question[^] two days ago and did not respond to my answer

[Verghese]

Thanks for the reply.........but I'm not getting any clue as how can I use multiple datasources when I'm using only one Access database............"empDB" is the access table and "EmpdID" is the field and likewise other fields in the same way.... pls see the used code below and guide ........ *********************************************************************************** comboID.DataSource = myDS.Tables["empDB"]; comboID.DisplayMember = "EmpID"; comboName.DataSource = myDS.Tables["empDB"]; comboName.DisplayMember = "EmpName"; comboProfession.DataSource = myDS.Tables["empDB"]; comboProfession.DisplayMember = "EmpProfession"; comboCountry.DataSource = myDS.Tables["empDB"]; comboCountry.DisplayMember = "EmpCountry"; ***********************************************************************************

[darkelv]

Verghese wrote:

comboID.DataSource = myDS.Tables["empDB"]; comboID.DisplayMember = "EmpID"; comboName.DataSource = myDS.Tables["empDB"]; comboName.DisplayMember = "EmpName"; comboProfession.DataSource = myDS.Tables["empDB"]; comboProfession.DisplayMember = "EmpProfession"; comboCountry.DataSource = myDS.Tables["empDB"]; comboCountry.DisplayMember = "EmpCountry";

You are using the same data source (see bold). To have each combobox be selected seperately, have 4 different DataSet to be assigned to the 4 combo boxes.

[Verghese]

Anyway, Thanx for the reply...........but I got it the other way round........see code below...... ******************************************************************************************* OleDbConnection con = new OleDbConnection(connectionString); OleDbCommand cmd = new OleDbCommand("select emp_name,emp_desig from emp", con); con.Open(); OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { comboBox1.Items.Add(dr[0]); comboBox2.Items.Add(dr[1]); //add as many comboboxes you want to } dr.Close(); *******************************************************************************************