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";
Who is Participating?

Improve company productivity with a Business Account.Sign Up

fwstealAuthor Commented:
did it with sql: lname + , + fname as name; will take a look at those links though
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.