how to populate a dropdownlist with multiple table columns

How to populate a dropdownlist with multiple table columns.

I've got a dropdownlist that I populate as follows:

DropDownList1.DataValueField = "id";

DropDownList1.DataTextField = "lname";


But would rather do this; is this possible?

DropDownList1.DataTextField = "lname" + ", " + "fname";
fwstealAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
fwstealAuthor Commented:
did it with sql: lname + , + fname as name; will take a look at those links though
0
All Courses

From novice to tech pro — start learning today.