小例子test1:
先上ashx代码:
<%@ WebHandler Language="C#" Class="indexInit" %>
using System;
using System.Web;
using System.Data.SqlClient;
using System.Drawing;
using System.Configuration;
using System.Collections.Generic;
using System.Data;
using System.Text;
using Blog.Data;
public class indexInit : IHttpHandler {
public void ProcessRequest (HttpContext context) {
context.Response.ContentType = "text/plain";
StringBuilder tb = new StringBuilder();
try
{
int count = int.Parse(context.Request.QueryString["count"].ToString()); //获取从页面传递过来的参数
int start = int.Parse(context.Request.QueryString["start"].ToString()); //获取从页面传递过来的参数
DataTable dt = WineNewsQueryFromMToN(count, start);
tb.Append(DataTableToJSON(dt));
context.Response.Write(tb.ToString());
}
catch (Exception e) { context.Response.Write(e.ToString()); }
}
public bool IsReusable {
get {
return false;
}
}
public DataTable WineNewsQueryFromMToN(int count, int start)
{
string sql = "SELECT * FROM tb_BlogEssay WHERE ID>" + start + "and ID<"+start+(count)+"";
DataTable dt = GetDataTable(sql);
return dt;
}
/// <summary>
/// 传入SQL语句返回DataTable
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns>数据表</returns>
public DataTable GetDataTable(string sql)
{
String sqlstr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlConnection conn = new SqlConnection(sqlstr);
SqlDataAdapter sda = new SqlDat