DataTextField是文本显示字段,也就是text
DataValueField是对应的值字段,也就是value
例子:
SqlDataAdapter temp_sda = new SqlDataAdapter("select TemplateName,Points from DataPackage group by TemplateName,Points",sqlConnection1);
sqlConnection1.Open();
temp_sda.Fill(ds,"template_result");
sqlConnection1.Close();
ddl1.DataSource = ds.Tables["template_result"].DefaultView;
ddl1.DataTextField="TemplateName";
ddl1.DataValueField="Points";
ddl1.DataBind();
DataValueField是对应的值字段,也就是value
例子:
SqlDataAdapter temp_sda = new SqlDataAdapter("select TemplateName,Points from DataPackage group by TemplateName,Points",sqlConnection1);
sqlConnection1.Open();
temp_sda.Fill(ds,"template_result");
sqlConnection1.Close();
ddl1.DataSource = ds.Tables["template_result"].DefaultView;
ddl1.DataTextField="TemplateName";
ddl1.DataValueField="Points";
ddl1.DataBind();
while (dr.Read())
{
ddl1.DataSource=dr[0];
ddl1.DataMember="trade";
// ddl1.DataTextField="trade";
//ddl1.DataValueField="trade";
ddl1.DataBind();
}
Dim ds As New DataSet()
……
ddl.DataSource = ds.Tables(0)
ddl.DataBind()
……
客户端:
……
<asp:DropDownList ID="ddl" Runat="server" DataValueField="UserID" DataTextField="UserName"/>
……
UserID和UserName是ds.Tables(0)里面的两个字段。
SqlDataReader dr=mc.getTrade();
ddl1.DataSource=dr;
//ddl1.DataMember="trade";
ddl1.DataTextField="trade";
ddl1.DataValueField="trade";
ddl1.DataBind();