Hi All,
I have a combo box in my form. I loaded my combo box with values from the data table as follows:
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:
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