Datasets

mike55

Contributor
Joined
Mar 26, 2004
Messages
727
Location
Ireland
Am using webservices to store and execute all my database code. If i have to do a select * on a table i load the data into a dataAdapter first and then use the dataAdapter to fill a dataset which is then used to transport the data to the frontend web form.

Say for example the dataset contains a employee id, name and mobile number. I know that if i want to display any of these three fields in a drop down list that i simple go:
dropdownlist.datasource = dataset
dropdownlist.datatextfield = "employee name"
dropdownlist.databind
Ok, is it possible to display multiple fields in each row of the dropdown list, i.e. have the employees Id, name and mobile number displayed in the one line of the dropdown list?

Appreciate any suggestions.

Mike55.
 
You can concat the columns in your Select statement...

Select (employeeid + name + mobilenumber) as Something From myTable
 
Back
Top