C#写的多级关联菜单

最新推荐文章于 2018-11-25 20:25:03 发布

原创最新推荐文章于 2018-11-25 20:25:03 发布 · 2.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#c# #dataset #server #exception #asp #object

WEB开发同时被 2 个专栏收录

29 篇文章

订阅专栏

NET下编程

10 篇文章

订阅专栏

这是一个使用C#编写的多级关联菜单示例，通过ASP.NET控件实现动态加载。当用户从省份下拉菜单中选择一项时，会自动加载对应城市的下拉菜单；同样，从城市下拉菜单中选择后，会加载相应的区/县下拉菜单。代码中使用了SqlConnection和SqlDataAdapter来连接和查询SQL Server数据库。

C#写的多级关联菜单

<%@ 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">

</div>
</form>
</body>
</html>

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

public partial class Default2 : System.Web.UI.Page
{
    public string connstr = ConfigurationManager.ConnectionStrings[0].ToString();

    SqlConnection conn = new SqlConnection("server=AYKJ-CLCHUN;user id=sa;pwd=anyuan;database=changsha");
    protected void Page_Load(object sender, EventArgs e)
    {
        Response.Write(connstr);
        if (!Page.IsPostBack)
        {
            try
            {
                conn.Open();
                SqlDataAdapter sda = new SqlDataAdapter("select dqbh,dqmc from T_diqu where dqdj=1", conn);
                DataSet ds = new DataSet();
                sda.Fill(ds, "T_diqu");
                ddProv.DataSource = ds.Tables[0].DefaultView;
                ddProv.DataBind();
            }
            catch (Exception se)
            {
                Response.Write(se.ToString());

            }
            finally { conn.Close(); }
        }

    }
    protected void ddProv_SelectedIndexChanged(object sender, EventArgs e)
    {
        lblCity.Visible = true;
        ddCity.Visible = true;
        try
        {
            conn.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select dqbh,dqmc from T_diqu where sjdqbh='" + ddProv.SelectedItem.Value.ToString() + "'", conn);
            DataSet ds = new DataSet();
            sda.Fill(ds, "T_diqu");
            ddCity.DataSource = ds.Tables[0].DefaultView;
            ddCity.DataBind();
        }
        catch (Exception se)
        {
            Response.Write(se.ToString());

        }
        finally { conn.Close(); }
    }
    protected void ddCity_SelectedIndexChanged(object sender, EventArgs e)
    {

        ddCity.SelectedItem.Selected = true;
        lblQX.Visible = true;
        ddQX.Visible = true;
        try
        {
            conn.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select dqbh,dqmc from T_diqu where sjdqbh='" + ddCity.SelectedItem.Value.ToString() + "'", conn);
            DataSet ds = new DataSet();
            sda.Fill(ds, "T_diqu");
            ddQX.DataSource = ds.Tables[0].DefaultView;
            ddQX.DataBind();
        }
        catch (Exception se)
        {
            Response.Write(se.ToString());

        }
        finally
        {
            conn.Close();
        }
    }
}