DropDownList控件实现省市联动

最新推荐文章于 2022-04-30 08:57:32 发布

wangboxian

最新推荐文章于 2022-04-30 08:57:32 发布

阅读量2.8k

点赞数 6

文章标签： dataset string object 数据库 server class

本文链接：https://blog.csdn.net/wangboxian/article/details/7512393

版权

在网站注册的页面上经常要选择注册地点，如果改变省的名称就能出现对应的市级的名称，将为用户带来很大的方便，下面就将我的实现过程给大家看一下

首先，建立数据库“Place”，表里面的内容如下图所示：

窗体布局如下图所示：

下面是实现代码：

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

namespace 省市联动
{
    public partial class 省市联动 : System.Web.UI.Page
    {
        string strCon = "server=.;database=Place;uid=sa;pwd=123456";
        protected void Page_Load(object sender, EventArgs e)
        {
            //DropDownList1.Text = "北京市";
            if (!IsPostBack)
            {
               
                SqlConnection sqlcon = new SqlConnection(strCon);
                string sqlstr = "select * from Province";
                string strCity = "select * from City where Province = '北京市'";
                SqlDataAdapter myda = new SqlDataAdapter(sqlstr, strCon);
                SqlDataAdapter mydaCity = new SqlDataAdapter(strCity, sqlcon);
                DataSet myds = new DataSet();
                DataSet mydsCity = new DataSet();
                sqlcon.Open();
                myda.Fill(myds);
                mydaCity.Fill(mydsCity);
                DropDownList1.DataSource = myds;
                DropDownList1.DataValueField = "ProvinceName";
                DropDownList1.DataBind();
                DropDownList2.DataSource = mydsCity;
                DropDownList2.DataValueField = "CityName";
                DropDownList2.DataBind();
                sqlcon.Close();
            }
        }

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            SqlConnection sqlcon = new SqlConnection(strCon);
            string sqlstr = "select * from City where Province = '" + DropDownList1.SelectedValue.Trim() + "'";
            SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
            DataSet myds = new DataSet();
            sqlcon.Open();
            myda.Fill(myds);
            DropDownList2.DataSource = myds;
            DropDownList2.DataValueField = "CityName";
            DropDownList2.DataBind();
            sqlcon.Close();
        }
    }
}

接下来运行就可以了