选中下拉菜单的一项后,下面的下拉菜单项随之改变

    技术2022-05-11  9

    .CS文件

     

     


     

     

     

    using System;using System.Data;using System.Data.OleDb;using System.Collections;using System.Configuration;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;

    namespace joke{    public partial class _Default : System.Web.UI.Page    {        DataSet myDS;        protected void Page_Load(object sender, EventArgs e)        {

                string strCon = @"Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = 'D:/Projects/joke/joke/mydb.mdb';";            OleDbConnection myConn = new OleDbConnection(strCon);            string strCom = " SELECT * FROM mytab";            //创建一个 DataSet对象              myConn.Open();            myDS = new DataSet();            OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);            myCommand.Fill(myDS, "mytab");            myConn.Close();            if (!IsPostBack)            {

                    this.DropDownList1.SelectedIndex = 0;                this.DropDownList2.SelectedValue = myDS.Tables["mytab"].Rows[0].ItemArray[1].ToString();

                }        }

            protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)        {

                switch (this.DropDownList1.SelectedValue)            {                case "xiaoa":                    this.DropDownList2.SelectedValue = myDS.Tables["mytab"].Rows[0].ItemArray[1].ToString();                    break;                case "xiaob":                    this.DropDownList2.SelectedValue = myDS.Tables["mytab"].Rows[1].ItemArray[1].ToString();                    break;                case "xiaoc":                    this.DropDownList2.SelectedValue = myDS.Tables["mytab"].Rows[2].ItemArray[1].ToString();                    break;            }        }

        }}

     

     

     

     


     

     

    .aspx 文件

     

     

     

     

     


     

     

    <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="joke._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>Untitled Page</title></head><body>    <form id="form1" runat="server">    <div>            <asp:DropDownList ID="DropDownList1" runat="server"             DataSourceID="AccessDataSource1" DataTextField="name" DataValueField="name"             onselectedindexchanged="DropDownList1_SelectedIndexChanged" Width="145px"             AutoPostBack="True">        </asp:DropDownList>        <asp:AccessDataSource ID="AccessDataSource1" runat="server"             DataFile="~/mydb.mdb" SelectCommand="SELECT * FROM [mytab]">        </asp:AccessDataSource>        <br />        <br />        <asp:DropDownList ID="DropDownList2" runat="server"             Height="19px" Width="145px" DataSourceID="AccessDataSource1" DataTextField="sex"             DataValueField="sex" EnableTheming="True">        </asp:DropDownList>        </div>    </form></body></html>

     

     

     


     


    最新回复(0)