Very odd Databinding behaviour

[Kevin Hodgson]

I have a ComboBox and a TextBox bound to a Dataset/datatable returned from a
SQL Database. The databinding is set in Design Mode.

Everything works fine on my initial fill, and I get the correct list of
items in the combobox, and the textbox which is bound to a second column in
the same table, changes to the appropriate value when a new item is selected
in the ComboBox. The ComboBox is displaying a list of products, and the
texbox the number remaining in inventory.

However, as the program is used, I need to refill the Dataset to reflect any
changes in product availability, or # of products remaining in inventory. I
Clear the Dataset, set my select command parameters, and refill the dataset.
(The actual code is identical to the code used to fill it in initially).

Now, the ComboBox shows the first item in the list as the selected text,
clicking the dropdown shows me the correct list of products, however I
cannot select a new item from the list. Regardless of what I do, the
SelectedText is reset to the first item in the list. In addition, the
TextBox supposed to show inventory quantity, is now blank (no value).

I hope someone has some idea what might be happening here, I can't seem to
figure out what the problem is.

Thanks,

Code used to fill Dataset.
Try
Me.DsRenewProdu ctList1.Clear()
Me.daProductLis t.SelectCommand .Parameters.Ite m("@Distributor ID").Value =
appSettings.Dis tributorID
Me.daProductLis t.Fill(Me.DsRen ewProductList1, "cw_authproduct select")
Catch ex As Exception
MsgBox(ex.Messa ge, MsgBoxStyle.Cri tical, "SQL Error updating Product
List")
Return False
End Try

The ComboBox databinding:
Tag: DsRenewProductL ist1 - cw_authproducts elect.SKU
Text: DsRenewProductL ist1 - cw_authproducts elect.ProductNa me
DataSource: DsRenewProductL ist1
DisplayMember: cw_authproducts elect.ProductNa me
ValueMember: cw_authproducts elect.ProductNa me

TextBox databinding:
Text: DsRenewProductL ist1 - cw_authproducts elect.authCount