Json+jquery+asp.net 返回数据库数据
前台：
代码
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title></title>
<%--<script src="js/jquery-1.3.2.js" type="text/javascript"></script>--%>
<script src="js/jquery.js" type="text/javascript"></script>
<script type="text/javascript" language="javascript">
$(document).ready(function() {
$("#btn").click(function() {
$.getJSON(
"show.ashx", //产生JSON数据的服务端页面
function(json) {
//循环取json中的数据,并呈现在列表中
$.each(json, function(i) {
$("#list").append("<li>username：" + json[i].FuserName + " userPWD：" + json[i].FpassWord + " Fmail：" + json[i].Fmail + " Fadress：" + json[i].Fadress + "</li>")
})
});
})
});
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<h3 title="选择一个分区"><span>选择</span></h3>
<input id="btn" type="button" value="获取数据" />
<ul id="list"></ul>
</div>
</form>
</body>
</html>
后台：
代码
<%@ WebHandler Language="C#" Class="show" %>
using System;
using System.Web;
using System.Collections.Generic;
using System.Web.Script.Serialization;//添加此引用
using DAL;
using model;
public class show : IHttpHandler {
public void ProcessRequest (HttpContext context) {
JavaScriptSerializer serializer = new JavaScriptSerializer();
IList<Tuser> tuser = UserDB.getList();
string dt = serializer.Serialize(tuser);
context.Response.ContentType = "text/plain";
context.Response.Write(dt);
}
public bool IsReusable {
get {
return false;
}
}
}
