GridView中实现DropdownList联动功能的技术求助

步骤1：完善后台ddlProgram_SelectedIndexChanged事件逻辑 #

通过触发事件的DropdownList定位所在GridView行，获取选中课程ID后加载对应地点数据，绑定到该行的第二个DropdownList：

protected void ddlProgram_SelectedIndexChanged(object sender, EventArgs e)
{
    // 获取触发事件的ddlProgram控件
    DropDownList ddlProgram = sender as DropDownList;
    if (ddlProgram == null || ddlProgram.SelectedValue == "0")
        return;

    // 定位当前控件所在的GridView行
    GridViewRow row = ddlProgram.NamingContainer as GridViewRow;
    if (row == null)
        return;

    // 获取选中的课程ID
    string courseId = ddlProgram.SelectedValue;

    // 找到该行对应的ddl_Location控件
    DropDownList ddlLocation = row.FindControl("ddl_Location") as DropDownList;
    if (ddlLocation == null)
        return;

    // 根据课程ID获取关联地点数据（替换为你的实际业务逻辑）
    DataSet ds = new DataSet();
    Btech.Mode = "GetLocationsByCourse"; // 新增Mode用于按课程筛选地点
    Btech.CourseID = courseId; // 传递选中的课程ID
    ds = objDal.Adm(Btech);

    // 绑定地点数据到ddl_Location
    ddlLocation.Items.Clear();
    if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
    {
        ddlLocation.DataSource = ds.Tables[0];
        ddlLocation.DataTextField = "CenterName";
        ddlLocation.DataValueField = "CentreCode";
        ddlLocation.DataBind();
    }
    // 添加默认选项
    ddlLocation.Items.Insert(0, new ListItem("Select Location", "0"));
}

步骤2：优化gvProgram_RowDataBound初始绑定逻辑 #

初始加载时仅给ddl_Location设置默认选项，避免显示所有地点造成混淆：

protected void gvProgram_RowDataBound(object sender, GridViewRowEventArgs e)
{
    DataSet ds = new DataSet();
    Btech.Mode = "BindData";
    ds = objDal.Adm(Btech);

    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        if (ds.Tables[0].Rows.Count > 0 && ds.Tables[1].Rows.Count > 0)
        {
            DropDownList ddlProgram = (DropDownList)e.Row.FindControl("ddlProgram");
            ddlProgram.Items.Clear();
            ddlProgram.DataSource = ds.Tables[13];
            ddlProgram.DataTextField = "Description";
            ddlProgram.DataValueField = "CourseID";
            ddlProgram.DataBind();
            ddlProgram.Items.Insert(0, new ListItem("Select course", "0"));

            DropDownList ddl_Location = (DropDownList)e.Row.FindControl("ddl_Location");
            ddl_Location.Items.Clear();
            // 初始仅显示默认选项
            ddl_Location.Items.Insert(0, new ListItem("Select Location", "0"));
        }
    }
}

步骤3：业务层数据逻辑调整 #

在数据访问层objDal.Adm方法中新增Mode = "GetLocationsByCourse"的处理逻辑，根据传入的CourseID筛选对应地点数据返回。

关键注意事项 #

• 确保ddlProgram的AutoPostBack="true"已正确设置（你的ASPX代码中已配置），保证选项变化时触发服务器事件。
• 使用NamingContainer定位GridView行是跨控件联动的核心，确保能精准找到同一行的目标控件。
• 绑定数据前清空Items集合，避免重复添加选项。

内容的提问来源于stack exchange，提问作者sumit sankpal