HTML代码:
<asp:DropDownList ID="ddlDept" runat="server"></asp:DropDownList>
.cs 代码:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataBindDept();
}
}
/// <summary>
/// 绑定部门名称
/// </summary>
public void DataBindDept()
{
UserProfileDB db = new UserProfileDB();
ddlDept.DataSource = db.GetAllDeptName();
ddlDept.DataTextField = "Name";
ddlDept.DataValueField = "Id";
ddlDept.DataBind();
ddlDept.Items.Insert(0, new ListItem("--请选择部门--", "0"));
}
Dal层 类中方法:
/// <summary>
/// 获取所有的部门信息
/// </summary>
/// <returns></returns>
public List<DepartmentInfo> GetAllDeptName()
{
List<DepartmentInfo> list = new List<DepartmentInfo>();
DepartmentInfo deptinfo = null;
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand cmd = new SqlCommand("select Id,[Name] from Department",conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
deptinfo = new DepartmentInfo();
deptinfo.Id = Convert.ToInt32(dr["Id"].ToString());
deptinfo.Name = dr["Name"].ToString();
list.Add(deptinfo);
}
dr.Close();
conn.Close();
return list;
}
web.config文件
<appSettings>
<add key="ConnectionString" value="server=.\SQLEXPRESS;database=数据库名;uid=sa;pwd=sa"></add>
</appSettings>