AJAX PRO 实例应用 DropDownList 联动

先贴上，以后写详细注解。

 

后台代码：

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  Microsoft.Practices.EnterpriseLibrary.Data;

public   partial   class  ajaxtest : System.Web.UI.Page
... {
    private static Database db = DatabaseFactory.CreateDatabase("mkstaffConn");
    private string sqlcommand = string.Empty;
    protected void Page_Load(object sender, EventArgs e)
    ...{
        AjaxPro.Utility.RegisterTypeForAjax(typeof(ajaxtest));

        if (!Page.IsPostBack)
        ...{
            SystemName();
            TeamList.DataSource = TeamName(SystemList.SelectedValue.Trim());
            TeamList.DataTextField = "name";
            TeamList.DataValueField = "name";
            TeamList.DataBind();         
            SystemList.Attributes.Add("onchange", "GetTeamList();");
        }
    }
   
    private void SystemName()
    ...{
        try
        ...{
            sqlcommand = "SELECT DISTINCT system FROM MKTeam";
            SystemList.DataSource = db.ExecuteDataSet(CommandType.Text, sqlcommand).Tables[0];
            SystemList.DataTextField = "system";
            SystemList.DataValueField = "system";
            SystemList.DataBind();
        }
        catch
        ...{ 
        }
    }

    [AjaxPro.AjaxMethod]
    /**//// <summary>
    /// ajax调用方法
    /// </summary>
    /// <param name="systemselectname"></param>
    public DataTable TeamName(string systemselectname)
    ...{
        try
        ...{
            sqlcommand = "select name from mkteam where system='" + systemselectname + "'";
            return db.ExecuteDataSet(CommandType.Text, sqlcommand).Tables[0];
        }
        catch
        ...{
            return null;
        }
    }
}  

前台代码：

 

<% @ 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 >
< script language = " javascript "  type = " text/javascript " >
//  <!CDATA[
function GetTeamList()
... {
    var System=document.getElementById("SystemList");
    ajaxtest.TeamName(System.value,TeamCallBack);

}

function TeamCallBack(response)
... {
    if(response.value !=null)
    ...{
        var team=document.getElementById("TeamList");
        var dt=response.value;
        team.length=0;
        for(var i=0;i<dt.Rows.length;i++)
        ...{
            var team_text=dt.Rows[i]["name"];
            var team_value=dt.Rows[i]["name"];
            team.options.add(new Option(team_text,team_value));     
        }
        
    }   
}

//  ]]>
</ script >
</ head >
< body >
     < form id = " form1 "  runat = " server " >
     < div >
         < asp:DropDownList ID = " SystemList "  runat = " server "  Width = " 120px " >
         </ asp:DropDownList >
         < asp:DropDownList ID = " TeamList "  runat = " server "  Width = " 120px " >
         </ asp:DropDownList ></ div >
     </ form >
</ body >
</ html >