AjaxPro.2.dll实现省市的二级无刷新联动

来源：互联网发布：入驻淘宝商城质检报告编辑：程序博客网时间：2024/05/22 03:11

Default.aspx

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;

}