在DropDownList中显示来自数据库的更多列
|
如何在asp.net的DropDownList中显示两列？
SqlDataSourceNamePeop.SelectCommand = \"select name,forename from people\";
DropDownListCaptain.DataTextField = \"name\";
<asp:DropDownList ID=\"DropDownListPeople\"
runat=\"server\"
DataSourceID=\"SqlDataSourceNamePeop\">
</asp:DropDownList>
<asp:SqlDataSource ID=\"SqlDataSourceNamePeop\"
ConnectionString=\"xxxxx\"
runat=\"server\">
</asp:SqlDataSource>
没有找到相关结果
已邀请:
5 个回复
甲车劲
然后将此自定义属性绑定到您的下拉列表，如下所示：让我知道是否解决了您的问题，谢谢。骨酚柯
结乳
<asp:DropDownList ID=\"DropDownList9\" runat=\"server\" DataSourceID=\"SqlDataSource3\" DataTextField=\"**CALL_NAMESURNAME**\" DataValueField=\"CALL_NAME\"> </asp:DropDownList> <asp:SqlDataSource ID=\"SqlDataSource3\" runat=\"server\" ConnectionString=\"<%$ ConnectionStrings:McCarthyConnectionString %>\" SelectCommand=\"SELECT [CALL_NAME], [SURNAME],**CALL_NAME + SURNAME AS [CALL_NAMESURNAME]** FROM [Sheet1$] where COY_NAME LIKE \'%abc%\'\"> </asp:SqlDataSource>恋裂
IList<PM_ClientInformation> objPM_ClientInformation = new List<PM_ClientInformation>(); //get information in objPM_ClientInformation foreach (PM_ClientInformation f in objPM_ClientInformation) { string text = string.Format(\"{0}{1}\", f.PM_cliFirstName.PadRight(10,\'\\u00A0\'), f.PM_cliLastName.PadRight(10,\'\\u00A0\')); ddlClientName.Items.Add(new ListItem (text ,f.PM_cliId.ToString())); }目浆搽