Question

c# dropdownlist数据字段绑定问题

SelectCommand="SELECT distinct dm,dh FROM [daa01]">
为什么？
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:mfy %>"
ProviderName="<%$ ConnectionStrings:mfy.ProviderName %>"
SelectCommand="SELECT dm,dh FROM [daa01]">
</asp:SqlDataSource>

Answer 1

这不是DropDownList 而是数据源。。。。

DropDownList 是这样写的
前台a.aspx：
<asp:DropDownList ID="DropDownList1" runat="server" Width="250px" ></asp:DropDownList>
后台a.aspx.cs:
DropDownList1.DataSource = ZWL.DBUtility.DbHelperSQL.GetDataTable("select ID,JuanKuName from ERPJuanKu");
DropDownList1.DataTextField = "JuanKuName";
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, new ListItem("", ""));
DropDownList1.SelectedIndex = 0;
//模仿这个