[asp.net实例]全国省市数据库的应用

最新推荐文章于 2014-06-28 05:14:00 发布

置顶 MrCoffee2019

最新推荐文章于 2014-06-28 05:14:00 发布

阅读量1k

点赞数 1

分类专栏： asp.net 全国省市数据库算法代码文章标签：数据库 asp.net string server asp xhtml

本文链接：https://blog.csdn.net/zjk20108023/article/details/7042909

版权

算法代码同时被 3 个专栏收录

11 篇文章 0 订阅

订阅专栏

asp.net

2 篇文章 0 订阅

订阅专栏

全国省市数据库

1 篇文章 0 订阅

订阅专栏

全国省市数据库的引用来自网上查询，故省略建立数据库的过程。参考：http://www.programfan.com/blog/article.asp?id=28128

页面建立：(*.aspx)

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="ShengShi_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="Pddl" runat="server" AutoPostBack="True" Height="35px" 
            onselectedindexchanged="Pddl_SelectedIndexChanged" Width="165px">
            <asp:ListItem>未选择</asp:ListItem>
        </asp:DropDownList>
        <asp:DropDownList ID="Cddl" runat="server" Height="35px" Width="165px">
            <asp:ListItem>未选择</asp:ListItem>
        </asp:DropDownList>
        </div>
    </form>
</body>
</html>

后台代码：（*.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.SqlClient;
using System.Configuration;

public partial class ShengShi_Default : System.Web.UI.Page
{
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)//只是初次加载页面的时候才执行下面代码。
        {
            string sqlcon = ConfigurationManager.ConnectionStrings["ProDBConn"].ConnectionString;//通过配置web.config文件，获得连接字符串：<add name="ProDBConn" connectionString="Data Source=ZJK-PC;Initial Catalog=ProvincesDB;;User ID=sa;Password=123456" providerName="System.Data.SqlClient"/>，引用using System.Configuration;
            using (SqlConnection conn = new SqlConnection(sqlcon))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "select * from promary";
                    using (SqlDataReader datareader = cmd.ExecuteReader())
                    {
                        while (datareader.Read())//读取数据库的proName
                        {
                            string proName = datareader.GetString(datareader.GetOrdinal("proName"));
                            Pddl.Items.Add(proName);

                        }
                    }
                }

            }
        }
    }
    private void Sqlfun(int id)//通过传入的proID，向DropDownList添加项
    {
        string sqlcon = ConfigurationManager.ConnectionStrings["ProDBConn"].ConnectionString;
        using (SqlConnection conn = new SqlConnection(sqlcon))
        {
            conn.Open();
            using (SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = "select * from city where proID=@proId order by cityID";
                cmd.Parameters.Add(new SqlParameter("proId",id));
                using (SqlDataReader datareader = cmd.ExecuteReader())
                {
                    while (datareader.Read())
                    {
                        string proName = datareader.GetString(datareader.GetOrdinal("cityName"));
                        Cddl.Items.Add(proName); 
                    }
                }
            }

        }
 
    }
    protected void Pddl_SelectedIndexChanged(object sender, EventArgs e)
    {
        Cddl.Items.Clear();
        string proName = Pddl.SelectedItem.Text;
        string sqlcon = ConfigurationManager.ConnectionStrings["ProDBConn"].ConnectionString;
        using (SqlConnection conn = new SqlConnection(sqlcon))
        {
            conn.Open();
            using (SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = "select * from promary where proName=@proName";
                cmd.Parameters.Add(new SqlParameter("proName", proName));
                using (SqlDataReader datareader = cmd.ExecuteReader())
                {
                    while (datareader.Read())
                    {
                        int proId = datareader.GetInt32(datareader.GetOrdinal("proID"));
                        Sqlfun(proId);
                    }
                }

            }
        }

    }
}

效果图如下：

MrCoffee2019

关注

1
点赞
踩
3

收藏

觉得还不错? 一键收藏
打赏
0
评论
[asp.net实例]全国省市数据库的应用

全国省市数据库的引用来自网上查询，故省略建立数据库的过程。参考：http://www.programfan.com/blog/article.asp?id=28128页面建立：(*.aspx) 全国省市 <asp:DropDownList ID="Pddl" runat="server" AutoPostBack="Tru
复制链接

扫一扫