Ajax联动下拉框的实现例子

这是采用ajax技术,刷新是肯定的,是在我们察觉不到的速度完成.XMLHTTP牺牲页面的方法,我们之所以看不见刷新,是因为所有的工作都是在牺牲页面上进行的,里面"翻江倒海"的"折腾",我们看不见,效率上差些!

AjaxPro.dll 下载地址 

 
     
  
  
 
 

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

http://www.w3.org/1999/xhtml" >

   

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

}