302班

第一種方法：
        string ConnString = ConfigurationSettings.AppSettings["ConnectionString"];

         //創(chuàng)建一個SqlConnection
         SqlConnection Conn = new SqlConnection( ConnString );        

         string SQL_Select = "select id, ItemName from DDLItem order by id desc";

         //構(gòu)造一個SqlDataAdapter

         SqlDataAdapter myAdapter = new SqlDataAdapter( SQL_Select, Conn);

         //開始讀取數(shù)據(jù)

         Conn.Open();

         DataSet dataSet = new DataSet();

         myAdapter.Fill( dataSet,"Table1" );

         Conn.Close(); 

         //開始綁定DropDownList 

         //指定DropDownList使用的數(shù)據(jù)源

         DropDownList1.DataSource = dataSet.Tables["Table1"].DefaultView;

         //指定DropDownList使用的表里的那些字段

         DropDownList1.DataTextField = "ItemName"; //dropdownlist的Text的字段

         DropDownList1.DataValueField = "id";//dropdownlist的Value的字段

         DropDownList1.DataBind();

第二種方法：
        con.Open();
        SqlCommand cmd = new SqlCommand(strSql,con);
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {      
            DropDownList1.Items.Add(new ListItem(dr["status"].ToString(), dr["status_Id"].ToString()));
        }