Default.aspx
<head runat="server">
<title>Ajax1</title>
<script language="javascript" type="text/javascript">
function showCity(id)//绑定地市
{
var result=_Default.getCityList(id).value;
var ddlcity=document.getElementById("ddlCity");
ddlcity.length=0;
for(var i=0;i<result.Rows.length;i++)
{
ddlcity.options.add(new Option(result.Rows[i].name,result.Rows[i].ID));
}
}
</script>
</head>
Default.aspx.cs
using System;
using System.Data;
using System.Configuration;
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 System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
AjaxPro.Utility.RegisterTypeForAjax(typeof(_Default));//注册Ajax可调用的类的名称
SqlConnection con = new SqlConnection("server=.;database=Ajax;uid=sa;pwd=;");
con.Open();
SqlCommand cmdProvince = new SqlCommand("select * from province",con);
SqlDataAdapter sda = new SqlDataAdapter();
DataTable dt=new DataTable();
sda.SelectCommand = cmdProvince;
sda.Fill(dt);
this.ddlProvince.DataSource = dt;
this.ddlProvince.DataTextField = "name";
this.ddlProvince.DataValueField = "ID";
this.ddlProvince.DataBind();
this.ddlProvince.Attributes["onchange"] = "showCity(this.options[selectedIndex].value)";
//地市的绑定
SqlCommand cmdCity = new SqlCommand("select * from city where provinceID="+this.ddlProvince.SelectedValue,con);
SqlDataReader sdr = cmdCity.ExecuteReader();
this.ddlCity.DataSource = sdr;
this.ddlCity.DataTextField = "name";
this.ddlCity.DataValueField = "ID";
this.ddlCity.DataBind();
sdr.Close();
con.Close();
}
[AjaxPro.AjaxMethod]
public DataTable getCityList(int id)
{
//绑定地市
SqlConnection con = new SqlConnection("server=.;database=Ajax;uid=sa;pwd=;");
con.Open();
SqlCommand cmd = new SqlCommand("select * from city where provinceID="+id,con);
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataTable dt = new DataTable();
sda.Fill(dt);
return dt;
}
}