关于dropdownlist的问题

Question

control.DataValueField = "ID";
control.DataTextField = "Name";
control.DataSource = ds;
control.DataBind();

Answer 1

private void get_list1()
{
cn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(ConfigurationSettings.AppSettings["ds"]));
string strSQL="select * from sort_material where sort_name order by sort_num";
cm=new OleDbCommand(strSQL,cn);
cn.Open();
dr=cm.ExecuteReader();
list1.DataSource=dr;
list1.DataTextField="sort_name";
list1.DataValueField="sort_num";
list1.DataBind();
cn.Close();
}