GridView中实现DropDownList联动

最新推荐文章于 2013-02-26 15:44:19 发布

转载最新推荐文章于 2013-02-26 15:44:19 发布 · 102 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/scy251147/archive/2010/12/30/1922320.html

文章标签：

#ui

本文介绍了一个ASP.NET应用程序中如何在GridView控件内实现两个级联的DropDownList。通过监听第一个DropDownList的选择改变事件来动态更新第二个DropDownList的内容。此方法涉及SQL查询及数据绑定。

直接上代码,不做过多解释:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load( object sender, EventArgs e)
{
}
protected void GridView1_RowDataBound( object sender, GridViewRowEventArgs e)
{
// 如果是数据绑定行
if (e.Row.RowType == DataControlRowType.DataRow)
{
DropDownList ddlParent = (DropDownList)e.Row.FindControl( " ddlParent " );
GetParent(ddlParent);
}
}

private void GetParent(DropDownList ddl)
{
string sql = " select * from Models where ParentModuleID=0 " ;
DataTable dt = DB.CreateDT(sql);
ddl.DataTextField = " ModuleName " ;
ddl.DataValueField = " ID " ;
ddl.DataSource = dt;
ddl.DataBind();
}
protected void ddlParent_SelectedIndexChanged( object sender, EventArgs e)
{
GridViewRow row = (GridViewRow)((sender) as Control).NamingContainer;
DropDownList ddlParent = (sender) as DropDownList;

int ddlParentID = Convert.ToInt32(ddlParent.SelectedValue);

DropDownList ddlChildren = row.FindControl( " ddlChildren " ) as DropDownList;
GetChildren(ddlChildren,ddlParentID);

}

private void GetChildren(DropDownList ddl, int parentID)
{
string sql = " select * from Models where ParentModuleID= " + parentID + "" ;
DataTable dt = DB.CreateDT(sql);
ddl.DataTextField = " ModuleName " ;
ddl.DataValueField = " ID " ;
ddl.DataSource = dt;
ddl.DataBind();
}
}

需要注意的是,其中的NamingContaier的使用方式.

转载于:https://www.cnblogs.com/scy251147/archive/2010/12/30/1922320.html