Dropdown list question

dcct84 · October 2nd, 2007, 11:55 AM

Hi everyone,
I have a question. I am filling a dropdownlist with the first and lastname of my table employees. The problem is that I want to get the employee's id but I don't want it to be displayed in my dropdownlist. I don't know if there is any chance to put set the employee_id as the value of each <asp:ListItem></asp:ListItem> and then get it by using the SelectedValue property?

Thanks!

pd. I am using a DataSource to fill my dropdownlist and a stored procedure that selects only first and lastname from my tableEmployee.

joefawcett · October 2nd, 2007, 12:14 PM

Can't you change the store procedure to bring back the extra column, then you can bind the DataValueField to the id and DataTextField to the full name?

--

Joe (Microsoft MVP - XML)

dcct84 · October 2nd, 2007, 12:17 PM

Yes, and thank you but I don't exactly know how to bind a DataValueField with my column employee id

joefawcett · October 2nd, 2007, 12:34 PM

Code:

ddlMyList.DataValueField = "EmployeeId";

or in markup as an attribute:

Code:

DataValueField="EmployeeId";[/

--

Joe (Microsoft MVP - XML)

dcct84 · October 2nd, 2007, 02:48 PM

Thank you and one last question. Can 2 columns be displayed in a single DataTextField? It only accepts me one column value...