Ajax联动下拉框的实现例子

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

}

共2页: 上一页 [1] 2 下一页

评论加载中…