Dropdown list in ASP.NET - How to get value selected
 

I am sure this must be very simple, but unforunately I can't figure it out.
I have the following code which populates the dropdown lists from the database. This works fine. Now, when the user selects a particular employee name from the list, I want to get the Employee Id of the selected employee. i.e. I need to get the "Eid" value. I can do this if the EId is loaded in the dropdown list, but in this case only the employee name is displayed. Please let me know howI can get the Eid value even though it is not loaded in the dropdown list.
I would really appreciate your help
Thanks
- Artee

Please see code below

Dim strConn As String

  strConn = ConfigurationSettings.AppSettings("connectionString")

  Dim myConn As New SqlConnection(strConn)

  Try

   Dim strSQL As String

   cboEmpList.Items.Clear()

   strSQL = "select distinct EId, LName, FName, Mi " & _

            " from EmpQualMain " & _

            " where BrCode = '" & gBranchCode & "'" & _

            " order by Lname, FName"

   Dim myCommand As New SqlCommand(strSQL, myConn)

   myConn.Open()

   Dim myRead As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.Default)

   While myRead.Read

       cboEmpList.Items.Add(myRead.GetValue(myRead.GetOrdinal("LName")) + ", " + myRead.GetValue(myRead.GetOrdinal("FName")) + " " + myRead.GetValue(myRead.GetOrdinal("Mi")))

       cboEmpList.DataValueField = myRead.GetValue(myRead.GetOrdinal("EId"))

   End While

   myRead.Close()

   Catch exc1 As Exception

       Response.Write(exc1.Message)

   Finally

       If Not (myConn Is Nothing) Then

           If myConn.State = System.Data.ConnectionState.Open Then myConn.Close()

       End If

   End Try

Re: Dropdown list in ASP.NET - How to get value selected
 

cboEmpList.DataValueField = myRead.GetValue(myRead.GetOrdinal("EId"))

that line is only useful if you are databinding in your case use

 

cboEmpList.Items.Add(New ListItem(myRead.GetValue(myRead.GetOrdinal("EId")), myRead.GetOrdinal("FName")) + " " + myRead.GetValue(myRead.GetOrdinal("Mi")))

Re: Dropdown list in ASP.NET - How to get value selected
 

how this code look like if in dropdown list don't have listitem?
cboEmpList.DataValueField = myRead.GetValue(myRead.GetOrdinal("EId"));

Re: Dropdown list in ASP.NET - How to get value selected
 

Isn't it just easier to bind your employee id as the Value of the Dropdownlist item, and their name as the Text of the Dropdownlist item.

You can receive the name of the dropdownlist by:
dropdownlistname.SelectedItem.Text

And the value of the dropdownlist selected item by:
dropdownlistname.SelectedItem.Value

So a simple:
Dim strEid As String = dropdownlistname.SelectedItem.Value
should do the trick as long as the item's value is the Eid.

Re: Dropdown list in ASP.NET - How to get value selected
 

thank alot SheSaidImaPregy..i really appreciate ur help!
:P