Json+jquery+asp.net 返回数据库数据
来源:互联网 发布:手游服务端源码 编辑:程序博客网 时间:2024/05/01 05:24
<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; } }}