How to create collection of dropdownlist, datatextfield ?

[Jevin]

I am attempting to bind data to a dropdownlist and to do that is there a way to make the datatextfield property of a dropdownlist. I know that we can bind the code using the datatextfield. But i have the requirement to bind there First Name as well as last name into that datatextfield, so when the drop down list will be displayed, user should be able to see a Last Name, First Name, rather than just a persons last name,Please suggest some suggestions. Any suggestion would be appreciated.

[Astro121]

I think you should declare a method and put he code inside the method.


DropDownList.DataSource = CreateDataSource();
DropDownList.DataTextField = "ColumTextField";
DropDownList.DataValueField = "ColumValueField";

// Bind the data to the control.
DropDownList.DataBind();

It is possible to concatenate your string in your SQL storedprocedure which is much more easier.. or you can do it in your code behind logic functions.This is very easy and this kind of programming logic is mostly being used.

[PARRISH]

This can be done with the lot of other ways, but the easiest way is to leverage with SQL to do what you want. Essentially you need to create a class that represents binding to a particular UI. So you would map your Model (My Object in your example) to a ViewModel object, and then bind the drop down list that way.

List<MyObject> myList = getObjects();
ddList.DataSource = (from obj1 in myList
                    select new
                    {
                      pro = obj1.pro,
                      Name = string.Format("{0} ({1})", obj1.Name, obj1.Zip)
                    }).ToList();
ddList.DataValueField = "pro";
ddList.DataTextField = "Name";
ddList.DataBind();