系，专业，班级三级连动方法

最新推荐文章于 2021-08-04 19:23:09 发布

原创最新推荐文章于 2021-08-04 19:23:09 发布 · 988 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #object #string

.net技术专栏收录该内容

31 篇文章

订阅专栏

本文介绍了一个使用ASP.NET实现的部门、专业及班级下拉菜单联动的示例。通过后台逻辑处理，实现了根据所选部门动态加载专业，并进一步根据所选专业加载对应的班级。示例中运用了DataSet进行数据传递。

PFCMIS.BLL.Common.CommonUse bll = new PFCMIS.BLL.Common.CommonUse();

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
        {
            DataSet ds = bll.GetAllList("vwDept");
            this.ddlDeptName.DataSource = ds;
            this.ddlDeptName.DataTextField = "DeptName";

            this.ddlGrade.DataSource = PFCMIS.BLL.Common.CommonUse.GetGradeList();
     DataBind();
        }
}

protected void ddlDeptName_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet ds = bll.GetList("MajorName,MajorNo", "vwMajor", " DeptName='" + this.ddlDeptName.SelectedItem.Text.Trim() +

"'");
        this.ddlMajorName.Items.Clear();
        this.ddlMajorName.Items.Add(new ListItem("-请选择-"));
        this.ddlMajorName.DataSource = ds;
        this.ddlMajorName.DataTextField = "MajorName";
        DataBind();
        this.ddlClassName.Items.Clear();
        this.ddlClassName.Items.Add(new ListItem("-请选择-"));
    }

    protected void ddlMajorName_SelectedIndexChanged(object sender, EventArgs e)
    {
        string strWhere = " DeptName='" + this.ddlDeptName.SelectedItem.Text.Trim() + "' and MajorName='" +

this.ddlMajorName.SelectedItem.Text.Trim() + "'";
        DataSet ds = bll.GetList("ClassNo,ClassName", "vwClassInfo", strWhere);
        this.ddlClassName.Items.Clear();
        this.ddlClassName.Items.Add(new ListItem("-请选择-"));
        this.ddlClassName.DataSource = ds;
        this.ddlClassName.DataTextField = "ClassName";
        DataBind();
    }

注意把AppendDataBoundItem设置为true