I’ve two comboboxes which should contain two different informations.

1.cb1: select table\_name from information\_schema.tables (this display multiple tables)  

2.cb2: should populate it with a column name.

Example: I've three tables in cb1 with the same attributes but have different values at the column `EmpName` (tblLondon,tblBerlin,tblRom,...)

Now I wanna display in second comboboxe the column EmpName dynamically whenever I choose a table in first combobox.

```
cb1[tblLondon]                          cb2[John,Mavis,Chris,Mike..]

```

OR

```
cb1[tblBerlin]                          cb2[Günther,Peter, Sophie,Sunny, ..]

```

Can u plz help me out

```
string C = ConfigurationManager.ConnectionStrings[""].ConnectionString;
        SqlConnection con = new SqlConnection(C);
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = ("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES ORDER BY TABLE_NAME ASC");
        try
        {
            // Open connection, Save the results in the DT and execute the spProc & fill it in the DT
            con.Open();
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            dt = new DataTable();
            adapter.Fill(dt);
            cbTbl.DisplayMember = "TABLE_NAME";
            cbTbl.ValueMember = "TABLE_NAME";
            //Fill combobox with data in DT
            cbTbl.DataSource = dt;
            // Empty bzw. clear the combobox
            cbTbl.SelectedIndex = -1;

```

This code is working and populating my cb1 (combobox)

And now i don't really know how to go about with cb2

```
 private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

```