html代码:触发按钮
<input type="button" id="search" value="查询" />
ashx代码:获取全部信息
List<bll> list = new List<bll>();
DataSet ds = bll.getSearchAll();
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
bl = new bll();
bl.id= int.Parse(dr["id"].ToString());
bl.name= dr["name"].ToString();
bl.sex= dr["sex"].ToString();
bl.deviceName = dr["deviceName"].ToString();
bl.age= int.Parse(dr["deviceName"].ToString());
bl.notes= dr["notes"].ToString();
list.Add(bl);
}
JavaScriptSerializer jss = new JavaScriptSerializer();
string jsonArr = jss.Serialize(list);
context.Response.Write(jsonArr);
}
else
{
HttpContext.Current.Response.Write("noresult");
}
js代码:按钮click事件去后台获取返回的json,并显示在页面
$("#search").click(function () {
window.location.href = "#searchall";
$.ajax({
type: "post",
url: "Handler1.ashx",
data: "type=search",
dataType: "JSON",
success: function (data) {
var m = "";
for (var i = 0; i < data.length; i++) {
m += data[i].id + "<br/>";
m += data[i].name + "<br/>";
m += data[i].sex + "<br/>";
m += data[i].age + "<br/>";
m += data[i].notes + "<br/>";
}
alert(m);
},
error: function (data) {
if (data.toString() == "noresult") {
alert("无结果");
}
}
});
});