showing multiple values from multiple db rows in a DropDownList

  • Thread starter Thread starter Schultz
  • Start date Start date
S

Schultz

Is there anyway to include values from 2 (or more) separate db columns
into a single DropDownList using VB.NET 03?


I would like the visible Data to be in the following format:


lname, fname (id number)


thanks!
 
Shultz:
After you've pulled the data into your datatable, add a new column such as:

dt.Columns.Add(new DataColumn("Display",
System.Type.GetType("System.String"), "[Lname] + ',' + [Fname] + '(' +
[IdNumber] + ')'"));

and you can then set the DataTextField to "Display"

Cheers,
Karl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dropdownlist not showing all from datasource and default is not bl 1
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
DropDownLists and NULL values 5
How code can show value in Web control from Default.aspx? 1
Binding a DropDownList in DetailsView 1
(Long)Showing Multiple DB Columns in a DropDownList 1
ERROR: Cannot have multiple items selected in a DropDownList. 2
Strange problem with SelectedIndex property affecting multiple dropdownlists 3

Back
Top