mike55 Posted August 24, 2004 Posted August 24, 2004 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. Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
mike55 Posted August 24, 2004 Author Posted August 24, 2004 listbox would be more appropriate Explain please... Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
Moderators Robby Posted August 24, 2004 Moderators Posted August 24, 2004 You can concat the columns in your Select statement... Select (employeeid + name + mobilenumber) as Something From myTable Quote Visit...Bassic Software
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.