combobox find item by value

Question

Hello Guys Is there any way in a combobox to find the value and display the result. in a combobox by the value I have combobox cmbCategory bound to tabledata i.e. cmbCategory.DisplayMember = categoryName; cmbCategory.ValueMember = categoryID; in table Category i store the value as categoryID int categoryName as varchar as this combobox is on employee Entry Form. i want to modify particular employee record for that when i pickup employee record from database through datareader categoryID is in value based like 1 or 2. I want to now load cmbCategory according to value ie 2 and display related categoryName Please help me.

Ranjit Powar · Answer

Use comboBox.SelectedValue

samar jeet · Answer

Sorry but this solution is not seems perfect because it gets fail when the combo display text is duplicate. so the selection should be based on its key or composition of dispay text and value.

Rakesh Kaushik · Answer

wow what a soluion animesh dear i told u that my combobox bound to tabledata. and i want to search integer value which is bound by value member of tabledata. either i am not able to make u understand my situation or you r also just guessing.

Animesh Datta · Answer

Then you can do like this cmbCategory.Text = Textvalue; it will automatically select the index .

Rakesh Kaushik · Answer

Dear Datta Sahib sorry for not informing that its a windows application and FindByValue function is not available here.

Animesh Datta · Answer

If you want to select the category by its text then code is cmbCategory .SelectedIndex = cmbCategory .Items.IndexOf( cmbCategory .Items.FindByText(TextValue)); and ff you want to to select the category by its value then code is cmbCategory .SelectedIndex = cmbCategory .Items.IndexOf( cmbCategory .Items.FindByValue(value)); thank you