Json+jquery+asp.net 返回資料庫資料

來源:互聯網
上載者:User

前台:

 

代碼

<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;
}
}

}

 

 

 

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.