More combo problems

[venerable bede]

I have a combo on my form whos purpose is to allow users to search the form. The combo displays "itemDescription" but holds "itemID" as Valuemember.

I have populated a combobox with the following:

daCombo.FillSchema(dsCombo, SchemaType.Source, "tblItems")
'fiLLDATASET WITH INFO FROM DATAADAPTOR
daCombo.Fill(dsCombo, "tblItems")
'empty combo box
ComboBox2.Items.Clear()
'fill combobox2
ComboBox2.DataSource = dsCombo.Tables("tblitems")
ComboBox2.DisplayMember = "itemDescription"
ComboBox2.ValueMember = "itemID"

I then use the following line of code:

objROw = objdataset.Tables("tblItems").Rows.Find(ComboBox2.SelectedItem.ToString)

Which throws up this error:

"Additional information: Input string was not in a correct format."

[Edneeis]

I think Find only uses the Primary Key index so if the ItemID is the primary key then you'd have to use:

objROw = objdataset.Tables("tblItems").Rows.Find(ComboBox2.SelectedValue)

[venerable bede]

Tried that.

I get an error message.

Incorrect type or something along those lines.


I'm gonna kill myself.


AAAARRGGGGGGGGHHHHHHH