DropDownList 下拉列表

前端：

<asp:DropDownList ID="ddlDepartment" runat="server"></asp:DropDownList>

后端：

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Department();
            }
        }

public void Department() 
        {
       	    UserBLL userbll = new UserBLL();
            ddlDepartment.DataSource= userbll.getDepartment();
            ddlDepartment.DataTextField="DepartName";	//前端显示的Name
            ddlDepartment.DataValueField="DepartId";	//隐式ID
            ddlDepartment.DataBind();
        }

BLL:

using MyOfficeDAL;
using MyOfficeModel;
using System.Data.SqlClient;

public List<DepartmentModel> getDepartment() 
        {
            SqlDataReader reader=userdal.getDepartment();
            List<DepartmentModel> list=new List<DepartmentModel> ();
            while(reader.Read())
            {
                DepartmentModel b=new DepartmentModel ();
                b.DepartId=Convert.ToInt32(reader["DepartId"]);
                b.DepartName=reader["DepartName"].ToString();
                list.Add(b);
            }
            reader.Close();
            return list;
        }

DAL:

using System.Data.SqlClient;

public SqlDataReader getDepartment() 
        {
            string sql = "select * from DepartInfo";
            SqlDataReader reader=db.ExecuteReader(sql);
            return reader;
        }

Model:

private int departId;
public int DepartId
        {
            get { return departId; }
            set { departId = value; }
        }
private string departName;
public string DepartName
       {
           get { return departName; }
           set { departName = value; }
       }