ajaxmethod.cs

ajax下拉列表框做的无刷新省市联动

using System;
using System.Data;
using System.Drawing;
using System.Configuration;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using AjaxPro;

namespace dropdown
{
	/// <summary>
	/// AjaxMethod 的摘要说明。
	/// </summary>
	public class AjaxMethod
	{
		public AjaxMethod()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
//			AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxMethod));
		}
		public static DataSet getdataset(string sql)
		{
			string strConn = "Server=.;database=china;uid=sa;pwd=";
			SqlDataAdapter sda = new SqlDataAdapter(sql,strConn);
			DataSet ds = new DataSet();
			sda.Fill(ds);
			return ds;
		}
		public static DataSet getlist()
		{
			string sql = "select * from province";
			return getdataset(sql);
		}
		[AjaxPro.AjaxMethod]//(AjaxPro.HttpSessionStateRequirement.Read)
		public static DataSet GetCityList(int DropDownList_Brand_id)
		{
			string sql = "select * from city where provinceid=" + DropDownList_Brand_id;
			return getdataset(sql);
		}
	}
}