retrieve selected value from databound dropdownlist in asp.net

Question

5.00/5 (1 vote)

See more:

Hye..

I have a dropdownlist which contains a customer record. I am facing a problem where although user select any item in the dropdownlist, the selectedvalue retrieved is the last item in the dropdown.

Here is my piece of code to view the data in the dropdownlist.

VB

Dim sqlCust As String = "SELECT CUSTCODE_T, CUSTNAME_T FROM CUST_MASTER"
         Dim dt As DataTable = DBLayer.Util.Data.MsSql.DBFunction.BuildDataTable(sqlCust, DBLayer.ClsConnection.getConnString("MP_QFMS"))

         Me.ddlCust.Items.Add("--Select--")
         For Each dr As DataRow In dt.Rows
             Me.ddlCust.Items.Add(dr("CUSTNAME_T"))
             Me.ddlCust.DataValueField = dr("CUSTCODE_T")

         Next
         ddlCust.DataBind()

and this is the code to display the selected value into label

VB

Me.lblCust.Text = Me.ddlCust.DataValueField

Based on the example below, user select SEP, but the selectedvalue retrieved is 03
CUSTCODE_T ; CUSTNAME_T
----------- -----------
01 ; SEP
02 ; OTH
03 ; EPSL

Posted 15-May-12 15:23pm

snamyna

Add a Solution

2 solutions

Solution 1

Hi,

I suggest you to not use foreach loop to bind the dropdown.
While binding data to the dropdown you should use this:

VB

Me.ddlCust.DataSource=dt
Me.ddlCust.DataValueField="CUSTNAME_T"
Me.ddlCust.DataValueField = "CUSTCODE_T"
Me.ddlCust.Items.Insert(0, New ListItem("Select", String.Empty))

This may help you..

-AK

Posted 15-May-12 17:55pm

AmitKumar89

Comments

snamyna 16-May-12 0:40am

Thanks for ur response Amit Kmr Sinha. :)

[no name] 16-May-12 1:47am

Most Welcome.. :)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Steve Echols · Accepted Answer · 2012-05-15T18:03:00

I think you want to do something like this instead (assuming you don't have viewstate turned off):

VB

If Not Page.IsPostBack Then
    Dim sqlCust As String = "SELECT CUSTCODE_T, CUSTNAME_T FROM CUST_MASTER"
     Dim dt As DataTable = DBLayer.Util.Data.MsSql.DBFunction.BuildDataTable(sqlCust, DBLayer.ClsConnection.getConnString("MP_QFMS"))

     Me.ddlCust.Items.Add("--Select--")
     For Each dr As DataRow In dt.Rows
         Me.ddlCust.Items.Add(new ListItem(dr("CUSTNAME_T"), dr("CUSTCODE_T))
     Next

     'No need to DataBind() since you're adding the items manually
     'Also lose the DataValueField, since it's used in DataBind, which you're not using
End If

OR:

VB

If Not Page.IsPostBack Then
    Me.ddlCust.DataTextField = "CUSTNAME_T"
    Me.ddlCust.DataValueField = "CUSTCODE_T"

    Dim sqlCust As String = "SELECT CUSTCODE_T, CUSTNAME_T FROM CUST_MASTER"
     Dim dt As DataTable = DBLayer.Util.Data.MsSql.DBFunction.BuildDataTable(sqlCust, DBLayer.ClsConnection.getConnString("MP_QFMS"))

     Me.ddlCust.Items.Clear()
     Me.ddlCust.Items.Add("--Select--")
     Me.ddlCust.AppendDataBoundItems = True        'This keeps the item added above when you do DataBind below

     Me.ddlCust.DataSource = dt
     Me.ddlCust.DataBind()
End If