List boxes based on same dataset.

chumzzz

I have two list boxes both based on the same dataset (have the same datasource, displaymember and valuemember). Changing the value in one of them (listBox1_SelectedIndexChanged), changes the value in the second list box (listBox2_SelectedIndexChanged), to the same value. I don't understand why the two different controls are behaving as one entity. Does this have something to do with my basing both of them off the same dataset? I don't see why I should be creating a different dataset when both the listboxes are required to display the same set of values from the database table. Thanks for any help.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

chumzzz22y ago
I had to workaround the problem by creating different datasets (both working off the exact same table in the database) and associating each list box with its own dataset. This resolves the issue although it is an inefficient way to implement this.
Tanvir Huda22y ago
Yeah i have the same problem when i bind it to combobox Dataset is an offline representation of the database query. and it had a datatable underliying to it. When we bind that dataset to a control and when change the index it scroll through the table, may be it called rowindex changed event internally. As a result, the selected index of the other control which is binding with the same dataset changes. That may associate the problem. That is my opinion. May be i am wrong. If i am pls correct me. That will be helpful Thanks