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 + "&nbsp; userPWD:" + json[i].FpassWord + "&nbsp; Fmail:" + json[i].Fmail + "&nbsp; 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;        }    }}