一个关无DropDownList无刷新二级联动的例子.

最新推荐文章于 2026-03-30 02:36:04 发布

原创最新推荐文章于 2026-03-30 02:36:04 发布 · 1.7k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#string #server #xhtml #javascript #asp

Ajax、JavaScript 专栏收录该内容

7 篇文章

订阅专栏

本文介绍了一个使用ASP.NET实现的DropDownList示例，演示了如何通过客户端JavaScript和服务器端C#代码来动态填充两个级联下拉列表。首先，从数据库中获取客户列表并填充第一个下拉列表；当用户选择一个客户时，通过AJAX调用从服务器获取该客户的联系人列表，并填充第二个下拉列表。

DropDownList.aspx 文档的代码:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DropDownList.aspx.cs" Inherits="Execute_DropDownList" %> <!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> <mce:script language="javascript" type="text/javascript"></mce:script> </head> <body> <form id="form1" runat="server"> <div> Customer:<asp:DropDownList ID="ddl_Customer" runat="server"></asp:DropDownList><br /> Contact:<asp:DropDownList ID="ddl_Contact" runat="server"></asp:DropDownList> </div> </form> </body> </html>

DropDownList.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; using System.Data.SqlClient; public partial class Execute_DropDownList : System.Web.UI.Page { /// <summary> /// 数据库连接字符串 /// </summary> private string connectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; private void xmlBind(string customer_Id) { string cmdText = "SELECT [Id], SG1 FROM Customer_Contact WHERE Customer_Id = @Customer_Id ORDER BY SG1"; DataTable dt_Customer_Contact = new DataTable("Customer_Contact"); DataHelper.SqlHelper.Fill(dt_Customer_Contact, connectionString, CommandType.Text, cmdText, new SqlParameter("@Customer_Id", customer_Id)); // 将取得的值开成"ID|名称,ID|名称,..."这样的形式 string str = ""; if (dt_Customer_Contact.Rows.Count > 0) { for (int i = 0; i < dt_Customer_Contact.Rows.Count; i++) { str += string.Format(",{0}|{1}", dt_Customer_Contact.Rows[i]["Id"].ToString().Trim(), dt_Customer_Contact.Rows[i]["SG1"].ToString().Trim()); } str = str.Substring(1); } // 输出页面 Response.Write(str); Response.End(); } private void bind_Customer() { // 显示所有主类 string cmdText = "SELECT [Id], [Name] FROM Customer ORDER BY [Name]"; DataTable dt_Customer = new DataTable("Customer"); DataHelper.SqlHelper.Fill(dt_Customer, connectionString, CommandType.Text, cmdText); ddl_Customer.DataSource = dt_Customer; ddl_Customer.DataValueField = "Id"; ddl_Customer.DataTextField = "Name"; ddl_Customer.DataBind(); ddl_Customer.Items.Insert(0, new ListItem("---请选择---", "-1")); ListItem item = ddl_Customer.Items.FindByValue("1"); if (item != null) { item.Selected = true; } ddl_Customer.Attributes.Add("onchange","XmlPost(this,'" + ddl_Contact.ClientID + "');"); } private void bind_Contact() { string cmdText = "SELECT [Id], SG1 FROM Customer_Contact WHERE Customer_Id = '1' ORDER BY SG1"; DataTable dt_Customer_Contact = new DataTable("Custome_Contact"); DataHelper.SqlHelper.Fill(dt_Customer_Contact, connectionString, CommandType.Text, cmdText); ddl_Contact.DataSource = dt_Customer_Contact; ddl_Contact.DataValueField = "Id"; ddl_Contact.DataTextField = "SG1"; ddl_Contact.DataBind(); ddl_Contact.Items.Insert(0, new ListItem("---请选择---", "-1")); } protected void Page_Load(object sender, EventArgs e) { string customer_Id = Request.QueryString["Customer_Id"]; if (customer_Id + "a" != "a") { xmlBind(customer_Id); } if (!IsPostBack) { bind_Customer(); bind_Contact(); } } }