Asp.net无刷新二级联动

最新推荐文章于 2020-02-21 18:12:48 发布

wengman

最新推荐文章于 2020-02-21 18:12:48 发布

阅读量3.2k

点赞数

分类专栏： asp.net 文章标签： asp.net dataset exception server xhtml object

asp.net 专栏收录该内容

45 篇文章 0 订阅

订阅专栏

Asp.net无刷新二级联动

数据库建立

表province

id provinceName
1 陕西
3 山东
8 河南

表city

id cityname provinceid
1 西安 1
2 济南 3
3 郑州 8
4 咸阳 1
5 洛阳 8
6 威海 3
7 青岛 3
aspx:

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

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

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.Configuration;
using System.Data.SqlClient;
public partial class Default7 : System.Web.UI.Page
{
    public string connstr()
    {
return ConfigurationSettings.AppSettings["gipsy"];
        //return ConfigurationManager.AppSettings.Keys["gipsy"];
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        //Response.Write(connstr());
        if (!IsPostBack)
        {
            SqlConnection conn = new SqlConnection(connstr());

            try
            {
                SqlDataAdapter dr = new SqlDataAdapter("select * from province", conn);
                DataSet ds = new DataSet();
                dr.Fill(ds, "temp");
                DropDownList1.DataSource = ds.Tables[0];

                DropDownList1.DataTextField = "provinceName";
                DropDownList1.DataValueField = "id";
                DropDownList1.DataBind();
            }
            catch (Exception ee)
            {
                throw new Exception(ee.Message);
            }
            finally
            {
                conn.Close();
            }
        }

    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(connstr());

        try
        {
            SqlDataAdapter dr = new SqlDataAdapter("select * from city where provinceid='"+int.Parse(DropDownList1.SelectedItem.Value)+"'", conn);
            DataSet ds = new DataSet();
            dr.Fill(ds, "temp");
            DropDownList2.DataSource = ds.Tables[0];

            DropDownList2.DataTextField = "cityname";
            DropDownList2.DataValueField = "id";
            DropDownList2.DataBind();
        }
        catch (Exception ee)
        {
            throw new Exception(ee.Message);
        }
        finally
        {
            conn.Close();
        }
    }

wengman

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
Asp.net无刷新二级联动

Asp.net无刷新二级联动数据库建立表provinceid provinceName1 陕西3 山东8 河南表cityid cityname provinceid1 西安 12 济南 33 郑州 84 咸阳 15 洛阳 86 威海 37 青岛 3aspx:http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd
复制链接

扫一扫