asp.net – 在.net 3.5中使用两个值绑定下拉列表

发布时间：2020-12-16 09:52:54 所属栏目：asp.Net 来源：网络整理

导读：我想在.net 3.5中使用一些分隔符[比如’ – ‘或’/’]将我的下拉列表与两个值绑定. qry = "SELECT CityName,MasterState.StateName FROM MasterCity INNER JOIN "+ "MasterState ON MasterCity.StateID = MasterState.StateID order by CityName";DropCity.

我想在.net 3.5中使用一些分隔符[比如’ – ‘或’/’]将我的下拉列表与两个值绑定.

qry = "SELECT CityName,MasterState.StateName FROM MasterCity INNER JOIN "+
              "MasterState ON MasterCity.StateID = MasterState.StateID order by CityName";

DropCity.DataMember = "DeafultView";
//DropCity.DataTextField = "CityName";
//DropCity.DataValueField = "CityName";
DropCity.DataTextFormatString = "{0} - {1}";
DropCity.DataTextField = "CityName,StateName";
DropCity.DataSource = dt;
DropCity.DataBind();
DropCity.Items.Insert(0,"-Select-");**

我做到了,但它给出了错误

DataBinding：’System.Data.DataRowView’不包含名为’CityName,StateName’的属性.“}

我怎样才能做到这一点？

解决方法

DropCity.DataTextField = "CityName,StateName";

DataTextField将查找CityName,StateName列,但它不存在.

也许你可以像这样更改你的查询

qry = "SELECT CityName,CityName + '-' + MasterState.StateName as CityState
    FROM MasterCity INNER JOIN "+
          "MasterState ON MasterCity.StateID = MasterState.StateID order by CityName";

    DropCity.DataTextField = "CityState";

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!