Hi all.

I have 2 comboboxes on a form (form1) called combobox1 and combobox2.

Each comboboxes should be filled with data stored in 2 different tables in Sql server 2005: table1 and table2

I mean: combobox1 --> table1 combobox2 --> table2

I fill data table with proper data and then bind the comboboxes to it separately.

My problem is: after filling 2 combos, both of them have equal data got from table2.

This is my code:

        DataTable tb1 = new DataTable();

        //Filling tb1 with data got from table1
        combobox1.Items.Clear();
        combobox1.DataSource = tb1;
        combobox1.DisplayMember = "Name";
        combobox1.ValueMember = "ID";
        combobox1.SelectedIndex = -1;

        //filling tb1 with data got from table2
        combobox2.Items.Clear();
        combobox2.DataSource = tb1;
        combobox2.DisplayMember = "Name";
        combobox2.ValueMember = "ID";
        combobox2.SelectedIndex = -1;

What's wrong?

It seems that if I get 2 different data tables (tb1 and tb2) , every thing will be all right.

Any suggestions please.

Thank you