如何将DropDownList绑定到数据源?
很简单的例子,代码如下:
<%@Page Language="C#"%>
<script runat="server">
public class DropDownList: System.Web.UI.Page
{
protected System.Web.UI.WebControls.DropDownList dropdownlist1;
protected System.Web.UI.WebControls.Button button1;
protected System.Web.UI.WebControls.Label Label1;
void Page_load(Object Sender,EventArgs E)
{
if(!Page.IsPostBack)
{
ArrayList myArray = new ArrayList();
myArray.Add(new ListItem("a","a"));
myArray.Add(new ListItem("b","b"));
dropdownlist1.DataSource = myArray;
dropdownlist1.DataBind();
}
}
}
public void Button_Click(object sender,EventArgs e)
{
label1.Text="你选择了"+ dropdownlist1.SelectedItem.Text +".";
}
</script>
<form id="form1" runat="server">
<asp:DropDownList id="dropdownlist1" runat="server">
</asp:DropDownList>
<br/><br/>
<asp:Button id="button1" Text="Submit" OnClick="Button_Click" runat="server"/>
<br/><br/>
<asp:Label id="label1" Text="" runat="server"/>
</form>
问题点数:20、回复次数:7Top
1 楼yb2008(中科商务网--ZKE360.COM)回复于 2005-05-09 16:47:41 得分 5
给你个例子:
public void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack)
{
string MyConnString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(".")+ConfigurationSettings.AppSettings["DataBase"];
OleDbConnection MyConn=new OleDbConnection(MyConnString);
MyConn.Open();
string sqlstr="select * from PrintType";
OleDbCommand MyComm=new OleDbCommand(sqlstr,MyConn);
//DateSet ds=new DataSet();
DataSet ds=new DataSet();
OleDbDataAdapter MyAdapter=new OleDbDataAdapter(sqlstr,MyConn);
MyAdapter.Fill(ds,"Score");
this.Brand.DataSource=ds.Tables["Score"];
this.Brand.DataTextField="small_class_data";
this.Brand.DataValueField="small_class_data";
this.Brand.DataBind();
this.Brand.Items.Insert(0,new ListItem("请选择","0"));
MyConn.Close();
}
}Top
2 楼aspdotnet2005(天中之子、为中原喝采![我想找兼职MSN:Red-Maple@hotmail.com])回复于 2005-05-09 17:03:23 得分 5
DataView dv;
dv赋值后
.......
if(dv.count>0)
{
for(int i=0;i<dv.Count;i++)
{
dropdownlist1.Items .Add(new ListItem(dv[i]["字段"].tostring()));
}
}Top
3 楼Compass_(指南针)回复于 2005-05-09 19:12:47 得分 5
this.DropDownList1.DataSource = dataSet.Tables[0];
this.DropDownList1.DataTextField = dataSet.Tables[0].Columns[1].ColumnName;
this.DropDownList1.DataValueField = dataSet.Tables[0].Columns[0].ColumnName;
this.DropDownList1.DataBind();Top
4 楼Jinglecat(晓风残月)回复于 2005-05-09 19:30:36 得分 0
基础的东东MSDN里都有例子的Top
5 楼xhbmj(《升龙道》)回复于 2005-05-10 17:59:19 得分 0
按照我给的代码如何改Top
6 楼zhanmincode(killer)回复于 2005-05-10 18:27:02 得分 0
到MSDN中找演练去Top
7 楼Compass_(指南针)回复于 2005-05-10 20:19:49 得分 5
//指定数据源
dropdownlist1.DataSource = myArray;
//指定绑定的字段
this.DropDownList1.DataTextField = "字段0";//myArray中的字段
this.DropDownList1.DataValueField = "字段1";//myArray中的字段
dropdownlist1.DataBind();
Top




