ASP.NET

ASP.NET RSS

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

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Dec 2006

Posts: 8

Reputation: artee is an unknown quantity at this point

Solved Threads: 0

artee

Offline

Newbie Poster

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

Feb 10th, 2007

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

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
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
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

•

Join Date: Jan 2007

Posts: 130

Reputation: sedgey is on a distinguished road

Solved Threads: 8

sedgey

Offline

Junior Poster

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

Feb 10th, 2007

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

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

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
 
cboEmpList.Items.Add(New ListItem(myRead.GetValue(myRead.GetOrdinal("EId")), myRead.GetOrdinal("FName")) + " " + myRead.GetValue(myRead.GetOrdinal("Mi")))
 
cboEmpList.Items.Add(New ListItem(myRead.GetValue(myRead.GetOrdinal("EId")), myRead.GetOrdinal("FName")) + " " + myRead.GetValue(myRead.GetOrdinal("Mi")))

Last edited by sedgey; Feb 10th, 2007 at 4:34 pm.

David Ridgway: so little daylight, too much caffeine
MCSD MCAD MCSE
http://web2asp.net

•

Join Date: Dec 2007

Posts: 17

Reputation: bungek84 is an unknown quantity at this point

Solved Threads: 0

bungek84

Offline

Newbie Poster

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

Dec 10th, 2007

•

Originally Posted by sedgey

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

that line is only useful if you are databinding in your case use
Help with Code Tags

ASP.NET Syntax (Toggle Plain Text)
 
cboEmpList.Items.Add(New ListItem(myRead.GetValue(myRead.GetOrdinal("EId")), myRead.GetOrdinal("FName")) + " " + myRead.GetValue(myRead.GetOrdinal("Mi")))
cboEmpList.Items.Add(New ListItem(myRead.GetValue(myRead.GetOrdinal("EId")), myRead.GetOrdinal("FName")) + " " + myRead.GetValue(myRead.GetOrdinal("Mi")))

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

•

Join Date: Sep 2007

Posts: 1,080

Reputation: SheSaidImaPregy is an unknown quantity at this point

Solved Threads: 68

SheSaidImaPregy SheSaidImaPregy is offline

Offline

Veteran Poster

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

Dec 11th, 2007

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.

•

Join Date: Dec 2007

Posts: 17

Reputation: bungek84 is an unknown quantity at this point

Solved Threads: 0

bungek84

Offline

Newbie Poster

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

Dec 12th, 2007

•

Originally Posted by SheSaidImaPregy

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.

thank alot SheSaidImaPregy..i really appreciate ur help!