Cascade Province and cities

最新推荐文章于 2024-04-24 11:53:19 发布

blackboy_my

最新推荐文章于 2024-04-24 11:53:19 发布

阅读量357

点赞数

文章标签： server xhtml object asp.net string asp

本文链接：https://blog.csdn.net/blackboy_my/article/details/2492826

版权

================================

under ASP.NET App_Code

SqlHelper

Authour:Fanji Kong

================================

using System;
using System.Data;
using System.Configuration;
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;
using System.Data;

/// <summary>
/// SqlHelper 的摘要说明
/// </summary>
public class SqlHelper
{
public SqlHelper()
{

}

    public SqlConnection getConnection()
    {
        SqlConnection con = new SqlConnection("Data Source=.;User ID=sa;Password=;Initial catalog=pubs");
        con.Open();
        return con;
    }

    public DataTable getAuthor()
    {
        SqlConnection con = this.getConnection();
        SqlDataAdapter sda = new SqlDataAdapter("select * from author",con);
        DataTable dt = new DataTable("au_name");
        sda.Fill(dt);
        sda.Dispose();
        con.Close();
        return dt;
    }

    public DataTable getprovince()
    {
        SqlConnection con = this.getConnection();
        SqlDataAdapter sda = new SqlDataAdapter("select * from province", con);
        DataTable dt = new DataTable("province");
        sda.Fill(dt);
        sda.Dispose();
        con.Close();
        return dt;
    }

    public DataTable getCity(String pid)
    {
        SqlConnection con = this.getConnection();
        SqlDataAdapter sda = new SqlDataAdapter("select * from city where provinceid = "+pid+"", con);
        DataTable dt = new DataTable("city");
        sda.Fill(dt);
        sda.Dispose();
        con.Close();
        return dt;
    }

}
==========================================

Default2.aspx.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;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SqlHelper sql = new SqlHelper();
            DataTable pro = sql.getprovince();
            this.DropDownList1.DataSource = pro;
            this.DropDownList1.DataTextField = "province";
            this.DropDownList1.DataValueField = "pid";
            this.DropDownList1.DataBind();
            this.DropDownList2.DataSource = sql.getCity(this.DropDownList1.SelectedItem.Value);
            this.DropDownList2.DataTextField = "city";
            this.DropDownList2.DataValueField = "cid";
            this.DropDownList2.DataBind();
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        String pid = this.DropDownList1.SelectedItem.Value;
        SqlHelper sql = new SqlHelper();
        DataTable city = sql.getCity(pid);
        this.DropDownList2.DataSource = city;
        this.DropDownList2.DataTextField = "city";
        this.DropDownList2.DataValueField = "cid";
        this.DropDownList2.DataBind();
    }
}
=================================================

Default2.aspx

=================================================

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

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

blackboy_my

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Cascade Province and cities

================================under ASP.NET App_Code SqlHelperAuthour:Fanji Kong================================using System;using System.Data;using System.Configuration;using System.We
复制链接

扫一扫