假设从数据库提取数据,在html页面中显示:
1,建立服务器后端处理程序
添加“一般处理程序”,如下图
2.编写“Handler2.ashx”代码,如下:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
using
System;
using
System.Collections.Generic;
using
System.Linq;
using
System.Web;
using
System.Web.Script.Serialization;
namespace
WebApplication5
{
/// <summary>
/// Handler1 的摘要说明
/// </summary>
public
class
Handler1 : IHttpHandler
{
public
void
ProcessRequest(HttpContext context)
{
//采用EF从数据库中提取数据
WeatherDBEntities weatherDbcontext =
new
WeatherDBEntities();
var
dataset =
from
data
in
weatherDbcontext.T_Station
select
new
{ data.StationName, data.StationPosition, data.Lat, data.Lon };
JavaScriptSerializer tool =
new
JavaScriptSerializer();
context.Response.ContentType =
"text/plain"
;
//字符串形式
context.Response.Write(tool.Serialize(dataset));
//将字符串编码为JSON类型
//
//备注,要从javascript中传参数的话,如下代码,data就是传递的参数。而在本文件中,通过context.request("zipcode")来获取
//如context.Response.Write(context.Request.Params["zipcode"]);
// $.ajax({
// url: "/api/getWeather",
//data: {
// zipcode: 97201
//},
// success: function( data ) {
// $( "#weather-temp" ).html( "<strong>" + data + "</strong> degrees" );
// }
//});
}
public
bool
IsReusable
{
get
{
return
false
;
}
}
}
}
|
3.添加Html页面:HtmlPage1.html
4.结果如下
附件:http://down.51cto.com/data/2363693
本文转自 huohe2009 51CTO博客,原文链接:http://blog.51cto.com/zhaojie/1317940