两种添加数据到WEB DropDownList 控件的方法-ASP教程,数据库相关

方法一：
   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();