昨天晚上在公司搞了半天,忘了JS对dataset数据集的操作, 今天想到 从网上找到的 后台代码: using System; using System.Collections; using System.Configuration; using System.Data; 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.Data.OleDb; namespace InsertDB { public partial class AjaxSelect : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxSelect)); if (!IsPostBack) { ListItem li = new ListItem("=请选择=", "0"); city.Items.Insert(0,li); area.Items.Insert(0,li); ProvinceBind(); } } /// <summary> /// 绑定省份 /// </summary> private void ProvinceBind() { string strSql="select name,code from province"; DataSet ds = new DataSet(); OleDbDataAdapter oda = new OleDbDataAdapter(strSql,OleDbHelper.Conn); oda.Fill(ds); prvince.DataSource = ds; prvince.DataTextField = "name"; prvince.DataValueField = "code"; prvince.DataBind(); ListItem li = new ListItem("=请选择=", "0"); prvince.Items.Insert(0, li); } /// <summary> /// 绑定城市 /// </summary> /// <param name="code"></param> [AjaxPro.AjaxMethod] public DataSet CityBind(string code) { string strSql = "select name,code from City where ProvinceId='" + code + "'"; DataSet ds = new DataSet(); ds = OleDbHelper.Dataset(strSql); return ds; } /// <summary> /// 绑定县 /// </summary> /// <param name="code"></param> /// <returns></returns> [AjaxPro.AjaxMethod] public DataSet AreaBind(string code) { string strSql = "select name,code from area where CityId='" + code + "'"; DataSet ds = new DataSet(); ds = OleDbHelper.Dataset(strSql); return ds; } } } 前台页面 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="AjaxSelect.aspx.cs" Inherits="InsertDB.AjaxSelect" %> <!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"><!-- // <!CDATA[ function prvince_onclick() { var ddlpro=document.getElementById("prvince"); document.getElementById("city").options.length=1; document.getElementById("area").options.length=1; // alert(ddlpro.options[ddlpro.selectedIndex].value); InsertDB.AjaxSelect.CityBind(ddlpro.options[ddlpro.selectedIndex].value,Call_back); } function Call_back(res){ if (typeof(res.value) == 'object'){ document.getElementById("area").options.length=1; var ds = res.value; var msTab = ds.Tables[0]; for(var i=0;i<msTab.Rows.length;i++){ var op=new Option(msTab.Rows[i].name,msTab.Rows[i].code); document.getElementById("city").options.add(op); } } } function city_onclick() { document.getElementById("area").options.length=1; var area=document.getElementById("city"); InsertDB.AjaxSelect.AreaBind(area.options[area.selectedIndex].value,Call_back1); } function Call_back1(res){ if(typeof(res.value)=='object'){ var ds=res.value; var msTab = ds.Tables[0]; for(var i=0;i<msTab.Rows.length;i++){ var op=new Option(msTab.Rows[i].name,msTab.Rows[i].code); document.getElementById("area").options.add(op); } } } // --></mce:script> </head> <body> <form id="form1" runat="server"> <div> <select id="prvince" runat="server" οnchange="return prvince_onclick()"></select> <select id="city" runat="server" οnchange="return city_onclick()"></select> <select id="area" runat="server"></select> </div> </form> </body> </html> 下载地址 http://download.csdn.net/source/1914175