DropDownList控件,DataTextField需要绑定两行数据
我有一个DropDownList控件,要绑定一组数据.
数据表的字段有3个,firstName,LastName,ID,首先DataValueField="ID",
1.DataTextField上我想显示firstName+“ ”+LastName。
解决,在SQL里面查询时候
select (firstname+lastname) as name from table
或者LINQ里面
var query = from p in X.Employees select p.FirstName + " " + p.LastName; return query.ToList();
DataTextField = name