Click here to Skip to main content
15,886,873 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
Hi All,

I have a combo box in my form. I loaded my combo box with values from the data table as follows:
VB
m_dtDelayedDeliveryDays = GetDelayedDeliveryDays()



       For Each dr As DataRow In m_dtDelayedDeliveryDays.Rows
           Me.cmbDelayedDeliveryDays.Items.Add(dr("DeliveryDelayDays"))
       Next

       cmbDelayedDeliveryDays.DataSource = m_dtDelayedDeliveryDays
       cmbDelayedDeliveryDays.DisplayMember = "DeliveryDelayDays"
       cmbDelayedDeliveryDays.ValueMember = "DeliveryDelayDaysID"
       cmbDelayedDeliveryDays.SelectedIndex = -1


And i load the selected value's ID into the database table as follows:

SQL
If cmbDelayedDeliveryDays.SelectedIndex > 0 Then
           Dim delayId As Integer
           Dim selectedDataRow As DataRow = DirectCast(cmbDelayedDeliveryDays.SelectedItem, DataRowView).Row
           delayId = Convert.ToInt32(selectedDataRow("DeliveryDelayDaysID"))

       End If


Till this it works fine. Now when i try to retrieve the form it should display the selected value in the combo box.

I have my already selected value's ID in the m_objUIMgr.DeliveryDelayDaysID property. How do i assign the value of the ID to the combo box.Please help.

My table looks like this
ID Days
1 0
2 3
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900