How to pick ID based on value selected from the combo box.

Question

0.00/5 (No votes)

See more:

Hi All,

I have a DataTable m_dtDelayedDeliveryDays in my.vb application.With this Data table i loaded my combo box .

The Data table has values like this:
ID DelayDays
6 0
8 3
9 7
10 15
11 20
12 30

Now my combo box contains DelayDays. Based on the user selection say 3 i need ID as 8.
How do i do this in vb.net..Please help.

I tried this but it didnt work:

Dim selectedDataRow As Integer = DirectCast(cmbDelayedDeliveryDays.SelectedItem, DataRowView).Row
Dim delayId As Integer = Convert.ToInt32(selectedDataRow(DeliveryDelayDaysID"))

This is throwing an error"Unable to cast object of type 'System.Int32' to type 'System.Data.DataRowView'."

Please help.

Thanks.

Posted 19-Feb-13 3:56am

vidkaat

Updated 19-Feb-13 4:05am

Richard C Bishop

v2

Add a Solution

Comments

Richard C Bishop 19-Feb-13 10:07am

You can't cast an Int32 into a DataRowView. Why not just do this: Dim selectedDataRow As Integer = Convert.ToInt32(cmbDelayedDeliveryDays.SelectedValue)

vidkaat 19-Feb-13 10:09am

Dim row As DataRow
row = DirectCast(cmbDelayedDeliveryDays.SelectedItem, DataRowView).Row
Dim delayId As Integer = Convert.ToInt32(row("DeliveryDelayDaysID"))

Even this does not work ..i get the error "Unable to cast object of type 'System.Int32' to type 'System.Data.DataRowView'."

vidkaat 19-Feb-13 10:12am

I need to get the ID based on the value selected from the Combo box. I dont need the selected value directly.

Richard C Bishop 19-Feb-13 10:33am

I understand now. Try this: DirectCast(cmbDelayedDeliveryDays.SelectedItem, DataRowView).Item("DeliveryDelayDaysID").

2 solutions

Solution 2

Code sample like as follows
Markup
<asp:dropdownlist id="ddlDays" runat="server" xmlns:asp="#unknown">
<asp:button id="btnSave" text="Save" runat="server" onclick="btnSave_Click" xmlns:asp="#unknown">
CodeBehind

Page load event

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!base.IsPostBack)
    {
        ddlDays.DataSource = GetDataTable();
        ddlDays.DataTextField = "DelayDays";
        ddlDays.DataValueField = "ID";
        ddlDays.DataBind();
    }        
}

Save button click event handler

C#

protected void btnSave_Click(object sender, EventArgs e)
{   
    int selectedId = int.Parse(ddlDays.SelectedValue);
}

sample data provider method

C#

private DataTable GetDataTable()
{
    var dt = new DataTable("DataTabl1");
    dt.Columns.Add("ID", typeof(Int32));
    dt.Columns.Add("DelayDays", typeof(Int32));

    DataRow row1 = dt.NewRow();
    row1["ID"] = 6;
    row1["DelayDays"] = 0;
    dt.Rows.Add(row1);

    row1 = dt.NewRow();
    row1["ID"] = 8;
    row1["DelayDays"] = 3;
    dt.Rows.Add(row1);

    row1 = dt.NewRow();
    row1["ID"] = 9;
    row1["DelayDays"] = 7;
    dt.Rows.Add(row1);
    return dt;
}

Posted 19-Feb-13 5:15am

S. M. Ahasan Habib

Add a Solution

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

CHill60 · Accepted Answer · 2013-02-19T05:10:00

When you load the datatable into your combobox define the DisplayMember and ValueMember

VB

ComboBox1.DataSource = myDataTable
ComboBox1.DisplayMember = "DelayDays"
ComboBox1.ValueMember = "ID"

Then on the appropriate comboBox event you can use (e.g.)

VB

Debug.Print(ComboBox1.SelectedValue.ToString()

How to pick ID based on value selected from the combo box.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to pick ID based on value selected from the combo box.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us