DropDownList 数据绑定

 

 string strconn = System.Configuration.ConfigurationManager.AppSettings["Main.ConnectionString"].Trim() + " ; Provider=SQLOLEDB;";
        OleDbConnection cnn = new OleDbConnection(strconn);
        string sql = "select * from JackDonkey_Tag  order by TagId";
        cnn.Open();
        OleDbCommand cmd = new OleDbCommand(sql, cnn);
        DropDownList_tag1.DataSource = cmd.ExecuteReader();
        DropDownList_tag1.DataTextField = "TagName";
        DropDownList_tag1.DataValueField = "TagId";
        DropDownList_tag1.DataBind();

cnn.Close();