网站首页 > 网络编程教程 > ASP.NET教程 > ASP.NET实现下拉框二级联动组件

ASP.NET实现下拉框二级联动组件

作者：互联网
时间：2009-07-01 15:47:24

namespace WebApplicationDlh
{
using System;
using Sy***m.Data;
using Sy***m.Drawing;
using Sy***m.Web;
using Sy***m.Web.UI.WebControls;
using Sy***m.Web.UI.HtmlControls;
using Sy***m.Data.SqlClient;
using Db;
///

/// Area 的摘要说明。
///

public class Area : Sy***m.Web.UI.UserControl
{
protected Sy***m.Web.UI.WebControls.DropDownList ddlProvince;
protected Sy***m.Web.UI.WebControls.DropDownList ddlCity;
public string strProvince
{
get
{
return dd***ovince.SelectedItem.Value;
}
set
{
dd***ovince.SelectedItem.Value = value;
}
}
public string strCity
{
get
{
return dd***ty.SelectedItem.Value;
}
set
{
dd***ty.SelectedItem.Value = value;
}
}
private void Page_Load(object sender, Sy***m.EventArgs e)
{
if(!IsPostBack)
{
ddlProvinceBind();
dd***ty.Items.Insert(0,"-请选择城市-");
}
}
private void ddlProvinceBind()
{
Db.Area myArea = new Db.Area();
SqlDataReader dr = my***a.GetAllProvince();
if(dr.Read())
{
dd***ovince.DataSource = dr;
dd***ovince.DataTextField = "Province";
dd***ovince.DataValueField = "Province";
dd***ovince.DataBind();
dd***ovince.Items.Insert(0,"-请选择省份-");
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
ba***OnInit(e);
}

///

/// 设计器支持所需的方法 - 不要使用代码编辑器
/// 修改此方法的内容。
///

private void InitializeComponent()
{
th***dd***ovince.SelectedIndexChanged += new Sy***m.EventHandler(th***ddlProvince_SelectedIndexChanged);
th***Load += new Sy***m.EventHandler(th***Page_Load);
}
#endregion
private void ddlProvince_SelectedIndexChanged(object sender, Sy***m.EventArgs e)
{
if(dd***ovince.SelectedItem.Value == "-请选择省份-")
{
dd***ty.Items.Clear();
dd***ty.Items.Insert(dd***ovince.SelectedIndex,"-请选择城市-");
}
else
{
Db.Area myArea = new Db.Area();
SqlDataReader dr = my***a.GetAllCityWhereProvince(dd***ovince.SelectedItem.Value);
if(dr.Read())
{
dd***ty.DataSource = dr;
dd***ty.DataTextField = "City";
dd***ty.DataValueField = "ID";
dd***ty.DataBind();
}
}
}
}
}

=============================================================〉
using System;
using Sy***m.Data;
using Sy***m.Data.SqlClient;
using Sy***m.Configuration;
namespace Db
{
///

/// Area 的摘要说明。
///

public class Area:Base
{
public Area()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public SqlDataReader GetAllProvince()
{
strSp = "Sp_Area_SelectAll";
drSelectAll(strSp);
return dr;
}
public SqlDataReader GetAllCityWhereProvince(string a)
{
conn = new SqlConnection(Co***gurationSettings.AppSettings["dsn"]);
cmd = new SqlCommand("Sp_Area_SelectAllWhereProvince",conn);
cm***ommandType = Co***ndType.StoredProcedure;
cm***arameters.Add("@Province",Sq***Type.VarChar,50).Value = a.***tring();
co***Open();
dr = cm***xecuteReader(Co***ndBehavior.CloseConnection);
return dr;
}
}
}

=====================================================〉
if exists (select * from db***ysobjects where id = object_id(N’[dbo].[Sp_Area_SelectAll]’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1)
drop procedure [dbo].[Sp_Area_SelectAll]
GO
if exists (select * from db***ysobjects where id = object_id(N’[dbo].[Sp_Area_SelectAllWhereProvince]’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1)
drop procedure [dbo].[Sp_Area_SelectAllWhereProvince]
GO
if exists (select * from db***ysobjects where id = object_id(N’[dbo].[Area]’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1)
drop table [dbo].[Area]
GO
CREATE TABLE [dbo].[Area] (
[ID] [int] NOT NULL ,
[Province] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[City] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[其它] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE Sp_Area_SelectAll
AS
SELECT DISTINCT Province
FROM Area
ORDER BY Province
RETURN
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE Sp_Area_SelectAllWhereProvince
@Province varchar(50)
AS
SELECT Area.*
FROM Area
WHERE (Province = @Province)
RETURN
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
================================================〉
using System;
using Sy***m.Data;
using Sy***m.Data.SqlClient;
using Sy***m.Configuration; namespace Db
{
///

/// Base 的摘要说明。
///

public class Base
{
public Base()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
protected string con = Co***gurationSettings.AppSettings["dsn"];
protected SqlConnection conn;
protected SqlCommand cmd;
protected SqlDataReader dr;
protected string strSp;
protected SqlDataReader drSelectAll(string strSp)
{
conn = new SqlConnection(con);
cmd = new SqlCommand(strSp,conn);
cm***ommandType = Co***ndType.StoredProcedure; co***Open();
dr = cm***xecuteReader(Co***ndBehavior.CloseConnection);
return dr;
}//返回一个SqlDataReader }
}

http://www.cnblogs.com/fubeidong/archive/2006/08/17/479412.html

上一篇： ASP.NET 2.0 WebService中传递DataTable参考

下一篇：如何解决Remoting无法传输存储过程参数的问题

ASP.NET实现下拉框二级联动组件

相关阅读

最新文章

人气下载推荐

相关应用

热门文章

推荐游戏