asp.net 有刷新实现三级联动

最新推荐文章于 2018-04-26 19:48:44 发布

转载最新推荐文章于 2018-04-26 19:48:44 发布 · 1k 阅读

·

0

·

标签

#asp.net

asp.net 专栏收录该内容

66 篇文章

订阅专栏

本文介绍了一种使用ASP.NET和SQL Server实现省、市、县三级联动下拉选择框的方法。通过从数据库中获取省市县数据并绑定到下拉框，当用户选择某个省份时，对应的市和县会自动更新。此方案利用了C#编程语言和ADO.NET进行数据访问。

[csharp]view plaincopyprint? 
  

<span style="font-size:18px;">using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class _Default : System.Web.UI.Page
{
string sqlstr=ConfigurationManager.ConnectionStrings["sqlstr"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GetProcince();
DropDownList4.Items.Insert(0, "--请选择省份--");
DropDownList2.Items.Insert(0, "--请选择城市--");
DropDownList3.Items.Insert(0, "--请选择区县--");
}
}
private void GetProcince()
{
using (SqlConnection sqlcnn=new SqlConnection(sqlstr))
{
using (SqlCommand sqlcmm=sqlcnn.CreateCommand())
{
sqlcmm.CommandText = "select * from province";
sqlcnn.Open();
DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(sqlcmm);
adapter.Fill(dt);
this.DropDownList4.DataSource = dt;
this.DropDownList4.DataTextField = "province";
this.DropDownList4.DataValueField = "provinceid";
this.DropDownList4.DataBind();
}
}
}
protected void DropDownList4_SelectedIndexChanged(object sender, EventArgs e)
{
this.DropDownList3.Items.Clear();
using (SqlConnection sqlcnn = new SqlConnection(sqlstr))
{
using (SqlCommand sqlcmm = sqlcnn.CreateCommand())
{
sqlcmm.CommandText = "select * from city where father=@father";
sqlcmm.Parameters.AddWithValue("@father", this.DropDownList4.SelectedValue);
sqlcnn.Open();
DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(sqlcmm);
adapter.Fill(dt);
this.DropDownList2.DataSource = dt;
this.DropDownList2.DataTextField = "city";
this.DropDownList2.DataValueField = "cityID";
this.DropDownList2.DataBind();
DropDownList2.Items.Insert(0, "--请选择城市--");
DropDownList3.Items.Insert(0, "--请选择区县--");
}
}
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
using (SqlConnection sqlcnn = new SqlConnection(sqlstr))
{
using (SqlCommand sqlcmm = sqlcnn.CreateCommand())
{
sqlcmm.CommandText = "select * from area where father=@father";
sqlcmm.Parameters.AddWithValue("@father", this.DropDownList2.SelectedValue);
sqlcnn.Open();
DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(sqlcmm);
adapter.Fill(dt);
this.DropDownList3.DataSource = dt;
this.DropDownList3.DataTextField = "area";
this.DropDownList3.DataValueField = "areaID";
this.DropDownList3.DataBind();
DropDownList3.Items.Insert(0, "--请选择区县--");
}
}
}
}
</span>

评论

被折叠的条评论为什么被折叠?

到【灌水乐园】发言

查看更多评论

添加红包

成就一亿技术人!

hope_wisdom

发出的红包

实付元

使用余额支付

点击重新获取

扫码支付

钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。