Combobox Selected Values...

[chinni1]

I Have 2 comboboxes in my form.The first combobox1 shoud be fill with the mainproduts which is cmng from database.By selecting The mainproduct the related sub product shoud dispaly in second combobox2.
In form load written this code.....

 da = new SqlDataAdapter("select * from main_products", con);
            da.Fill(ds, "main");
            da = new SqlDataAdapter("select * from sub_master", con);
            da.Fill(ds, "sub");


          
            comboBox1.DataSource = ds.Tables["main"];
            comboBox1.DisplayMember = "prod_name";
            comboBox1.ValueMember = "prod_id";


///In combobox selected index changed

			DataView dv = new DataView(ds.Tables["sub"]);
                dv.RowFilter = "prod_id=" + comboBox1.SelectedValue;
                comboBox2.DataSource = dv;
                
              
                comboBox1.ValueMember = "prod_id";

IM getting In first combobox the Main products values,but In second Combobox System.Data.Dat aRowView is displying insted of related subproducts.

Thanks

[Christian Binder]

I think you've to set DisplayMember and ValueMember for comboBox2 too.

[chinni1]

I think you've to set DisplayMember and ValueMember for comboBox2 too.

Hii...

Thanks ChBinder,its worked.But i want to display in first combobox1 mainproductname insted of id.In second combobox im getting name..

Thanks

[Christian Binder]

DId you change your code?

comboBox1.DataSource = ds.Tables["main"];
comboBox1.DisplayMember = "prod_name";
comboBox1.ValueMember = "prod_id";

This would mean, that the combo-box displays the field prod_name. You say, the combo-box doesn't disply the prod_name but prod_id instead?

[chinni1]

DId you change your code?

comboBox1.DataSource = ds.Tables["main"];
comboBox1.DisplayMember = "prod_name";
comboBox1.ValueMember = "prod_id";

This would mean, that the combo-box displays the field prod_name. You say, the combo-box doesn't disply the prod_name but prod_id instead?

No,I did not changed anything in code,but its dispaying prod_id only