绑定数据到下拉框中

    //下拉框
    protected System.Web.UI.WebControls.DropDownList  codeClass;

    string sql = "select name,codeclassid from codeclass";    
    DataSet ds = ...;//根据sql生成DataSet
    if(ds != null && ds.Tables[0] != null)//如果有记录的话
    {
     codeClass.DataSource = ds.Tables[0];
     codeClass.DataTextField = "name";
     codeClass.DataValueField = "codeclassid";
     codeClass.DataBind();     
    }