两种添加数据到dropdownlist控件的方法
方法一：
1 string sql="select * from newsclass order by orderid desc";
2
3 oledbconnection conn=new oledbconnection();
4
5 conn.connectionstring=connectionstring;
6 conn.open();
7
8 oledbcommand cmd = new oledbcommand(sql,conn);
9 oledbdatareader dr= cmd.executereader();
10
11 //将数据添加到 dropdownlist
12 while(dr.read())
13 {
14 ddl.items.add(new listitem(dr["classname"].tostring(),dr["classid"].tostring()));
15 }
16 dr.close();
17
18 cmd.dispose();
19 conn.close;
20 conn.dispose();
21
方法二：
1 string sql="select * from newsclass order by orderid desc";
2
3 oledbconnection conn=new oledbconnection();
4 conn.connectionstring=connectionstring;
5 conn.open();
6
7 dataset ds=new dataset();
8 oledbdataadapter da=new oledbdataadapter(sql,conn);
9 da.fill(ds,"classtable");
10
11 //将数据添加到 dropdownlist
12 ddl.datasource=ds;
13 ddl.datatextfield = "classname";
14 ddl.datavaluefield = "classid";
15 ddl.databind();
16
17 ds.dispose();
18 conn.close;
19 conn.dispose();
20
21
http://www.cnblogs.com/meil/archive/2006/10/19/533812.html
