三层三级联动

最新推荐文章于 2022-03-30 21:48:11 发布

最新推荐文章于 2022-03-30 21:48:11 发布 · 381 阅读

文章标签：

aspx页

cs页

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

namespace WebApplication1
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadProvince();
}
}

private void LoadProvince()
{
BLL.province bpro = new BLL.province();
DataTable dt= bpro.GetList("").Tables[0];

ddlprovince.DataSource = dt;
ddlprovince.DataTextField = "provincename";
ddlprovince.DataValueField = "provinceID";
ddlprovince.DataBind();

}

protected void ddlprovince_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.ddlarear.Items.Count>0)
{
this.ddlarear.Items.Clear();
}
BLL.city bcity = new BLL.city();
string proid = this.ddlprovince.SelectedItem.Value;

DataTable dt = bcity.GetList("father='"+proid+"'").Tables[0];

ddlcity.DataSource = dt;
ddlcity.DataTextField = "cityname";
ddlcity.DataValueField = "cityID";
ddlcity.DataBind();

//绑定默认显示的市级区划下面所有的县
string cityid= dt.Rows[0]["cityID"].ToString();
BLL.area baraer = new BLL.area();

DataTable dtarea = baraer.GetList("father='" + cityid + "'").Tables[0];

ddlarear.DataSource = dtarea;
ddlarear.DataTextField = "areaname";
ddlarear.DataValueField = "areaID";
ddlarear.DataBind();

}

protected void ddlcity_SelectedIndexChanged(object sender, EventArgs e)
{
BLL.area baraer = new BLL.area();
string cityid = this.ddlcity.SelectedItem.Value;

DataTable dt = baraer.GetList("father='" + cityid + "'").Tables[0];

ddlarear.DataSource = dt;
ddlarear.DataTextField = "areaname";
ddlarear.DataValueField = "areaID";
ddlarear.DataBind();
}
}
}

Getlist方法

public DataSet GetList(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select id,provinceID,provincename ");
strSql.Append(" FROM province ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
return DbHelperSQL.Query(strSql.ToString());
}

Query方法：

public static DataSet Query(string SQLString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
SqlDataAdapter command = new SqlDataAdapter(SQLString, connection);
command.Fill(ds, "ds");
}
catch (System.Data.SqlClient.SqlException ex)
{
throw new Exception(ex.Message);
}
return ds;
}
}