花了点时间,根据别人的,自己也总结个
前台JS
function CountryDel(AreaName)
{//清空DropDownList
var countnum=document.getElementById(AreaName).options.length;
for(var i=1;i<countnum;i++)
{//清空DropDownList
document.getElementById(AreaName).remove(countnum-i);
}
}
$(document).ready(function(){
$("#ddlDeskType").change( function() {
$.getJSON(
"ajax.aspx",
{ id:$("#ddlDeskType").val()},
function(json){
CountryDel("ddlDeskNo");//
$.each(json.ds, function(i,n) {
var opt = $("<option></option>").text(n.DeskNo).val(n.ID);
$("#ddlDeskNo").append(opt);
});
}
);
} );
$("#ddlDeskNo").change(function(){
$("#HFDeskNo").val($("#ddlDeskNo").val());
})
});
后台
public void ddlRoomBind()
{
DataSet objDs=new DataSet();
objDs=this.getServiceLocator().GetCodeService().getRoomList("");
ddlDeskType.DataSource =objDs;
ddlDeskType.DataTextField = "RoomName";
ddlDeskType.DataValueField = "ID";
ddlDeskType.DataBind();
ddlDeskType.Items.Insert(0,new ListItem("请选择","0"));
ddlDeskNo.Items.Insert(0, new ListItem("请选择", "0"));
}
ajax.aspx
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 System.Text;
public partial class admin_GoodsOrder_ajax : AdminPageBase
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
DataSet objDs = new DataSet();
string strWhere = " RoomType=" + Convert.ToInt32(Request.QueryString["id"].ToString());
objDs = this.getServiceLocator().GetCodeService().getDeskNumberList(strWhere);
string str = DataTable2Json(objDs.Tables[0]);
Response.Write(str);
Response.End();
}
}
private string DataTable2Json(DataTable dt)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{");
jsonBuilder.Append(dt.TableName);
jsonBuilder.Append(":[");
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append(":'");
jsonBuilder.Append(dt.Rows[i][j].ToString());
jsonBuilder.Append("',");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return jsonBuilder.ToString();
}
}