C#写的多级关联菜单

来源：互联网发布：软件质量特性编辑：程序博客网时间：2024/05/22 09:37

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();
        }
    }
}