省市选择器

最新推荐文章于 2022-05-18 11:45:22 发布

转载最新推荐文章于 2022-05-18 11:45:22 发布 · 376 阅读

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="省市选择器._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:DropDownList ID="ddProvince" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddProvince_SelectedIndexChanged"></asp:DropDownList>
        <asp:DropDownList ID="ddCity" runat="server"></asp:DropDownList>
    </div>
    </form>
</body>
</html>

.CS

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace 省市选择器
{
    public partial class _Default : System.Web.UI.Page
    {
        SqlConnection con = null;
        SqlCommand cmd = null;
        string sqlstr = @"Data Source=.;Initial Catalog=MyDB;Integrated Security=True";

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindDate(sqlstr);
            }
        }

        protected void ddProvince_SelectedIndexChanged(object sender, EventArgs e)
        {
            string index = ddProvince.SelectedValue;
            using (con = new SqlConnection(sqlstr))
            {
                con.Open();
                cmd = con.CreateCommand();
                cmd.CommandText = "select * from city where proid=@Proid";
                cmd.Parameters.Add(new SqlParameter("Proid", index));
                SqlDataReader dr = cmd.ExecuteReader();
                ddCity.Items.Clear();
                ddCity.Items.Add("——市——");
                while (dr.Read())
                {
                    ddCity.Items.Add(new ListItem(dr.GetString(dr.GetOrdinal("cityName")), dr.GetInt32(dr.GetOrdinal("cityID")).ToString()));
                }

            }
        }

        /// <summary>
        /// 省
        /// </summary>
        /// <param name="sqlstr"></param>
        protected void BindDate(string sqlstr)
        {
            using (con = new SqlConnection(sqlstr))
            {
                con.Open();
                cmd = con.CreateCommand();
                cmd.CommandText = "select * from promary";
                SqlDataReader dr = cmd.ExecuteReader();

                ddProvince.Items.Add("——省——");
                while (dr.Read())
                {
                    ddProvince.Items.Add(new ListItem(dr.GetString(dr.GetOrdinal("ProName")), dr.GetInt32(dr.GetOrdinal("ProID")).ToString()));
                }


            }
        }
    }
}