兩種添加資料到WEB DropDownList 控件的方法

作者：海雅(http://blog.csdn.net/hiyavip)

方法一：

   string sql="SELECT * FROM NewsClass ORDER BY ORDERID DESC";

   OleDbConnection conn=new OleDbConnection();

   conn.ConnectionString=ConnectionString;

   conn.Open();

   OleDbCommand cmd = new OleDbCommand(Sql,Conn);

   OleDbDataReader dr= cmd.ExecuteReader();

     //将資料添加到 DropDownList

   while(dr.Read())

   {

    this.ddlClass.Items.Add(new ListItem(dr["ClassName"].ToString(),dr["ClassId"].ToString()));

   }

   dr.Close();

   cmd.Dispose();

   conn.Close;

   conn.Dispose();

方法二：

  string sql="SELECT * FROM NewsClass ORDER BY ORDERID DESC";

   OleDbConnection conn=new OleDbConnection();

   conn.ConnectionString=ConnectionString;

   conn.Open();

   DataSet ds=new DataSet();

   OleDbDataAdapter da=new OleDbDataAdapter(sql,conn); 

   da.Fill(ds,"ClassTable");

   //将資料添加到 DropDownList

   this.ddlClass.DataSource=ds;

   this.ddlClass.DataTextField = "ClassName";

   this.ddlClass.DataValueField = "ClassID";

   this.ddlClass.DataBind();

   ds.Dispose();

   conn.Close;

   conn.Dispose();