AJAX联动下拉框

 AjaxPro.dll 下载地址  http://ajaxpro.schwarz-interactive.de/download/ajaxpro.zip 

Web.Config 
<?xml version="1.0"?>
<configuration>
 <system.web>
      <httpHandlers>
   <add verb="POST,GET" path="ajax/*.ashx" type="Ajax.PageHandlerFactory, Ajax" />
   <add verb="POST,GET" path="ajaxpro/*.ashx" type="AjaxPro.AjaxHandlerFactory,AjaxPro.2"/>
  </httpHandlers>
 </system.web>
</configuration>

AjaxTest.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AjaxTest.aspx.cs" Inherits="AjaxTest" %>

<!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>

</head>

<body>
<script language="javascript" type="text/javascript">
function areaResult() 

var area=document.getElementById("DropDownList1");
//alert(area.value);
AjaxTest.GetCityList(area.value,get_city_Result_CallBack);
}
function get_city_Result_CallBack(response)
{
if (response.value != null)

  document.all("DropDownList2").length=0;     
  var ds = response.value;
  if(ds != null && typeof(ds) == "object" && ds.Tables != null)
  { 
   for(var i=0; i<ds.Tables[0].Rows.length; i++)
  {
   var name=ds.Tables[0].Rows[i].name;
   var id=ds.Tables[0].Rows[i].id;
   document.all("DropDownList2").options.add(new Option(name,id));
  }
  //document.all("TextBox1").value="";  
 }

return
}

</script>
  <form id="form1" runat="server">
      &nbsp;&nbsp; 
 <asp:DropDownList ID="DropDownList1" runat="server">
        </asp:DropDownList>
        <asp:DropDownList ID="DropDownList2" runat="server">
        </asp:DropDownList>&nbsp;
      <br />
    </form>
</body>
</html>

AjaxTest.cs

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 MeetWeb;
public partial class AjaxTest : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxTest));
       if (!Page.IsPostBack)
       {
           BindData();

       }
    }
    private void BindData()
    {
        DataSet ds = new DataSet();
          String sql = "Select id,name from test";
          try
          {
              ds = GetDataSet(sql, "test");
              this.DropDownList1.DataSource = ds.Tables[0];
              this.DropDownList1.DataTextField = "name";
              this.DropDownList1.DataValueField = "id";
              this.DropDownList1.DataBind();
              this.DropDownList1.Attributes.Add("onclick", "areaResult();");
          }
          catch (Exception ex)
          {
              Response.Write(ex.Message);
          }
    }

    public static DataSet GetDataSet(string sql,string aa)
    {
        MeetWeb.SqlDataBase a = new MeetWeb.SqlDataBase("server=localhost\\PMSERVER;uid=sa;pwd=sa;database=test");
        DataSet ds = new DataSet();
        ds=a.CreateSet(sql, aa);
        return ds;
    }

    [AjaxPro.AjaxMethod]
    public DataSet GetCityList(int id)
    {
        string sql = "select name from test where id='" + id + "'";
        return GetDataSet(sql,"test");
    }


}




原文地址http://www.cnblogs.com/meetweb/archive/2007/03/16/677271.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值