利用ashx操作OleDb数据库返回json数据

因为是套用JQ插件dataTables,所以这里的json格式会有点区别

<%@ WebHandler Language="C#" Class="data" %>

using System;
using System.Web;
using System.Data;
using System.Data.OleDb;

public class data : IHttpHandler{
	
	public void ProcessRequest(HttpContext context){
		context.Response.ContentType = "text/plain";
		OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=E:\\study\\jq_ashx\\db1.mdb");
	
		string sql_search = "select information from table1";
		string sql_count = "select count(*) from table1";		//统计个数

		try{
			connection.Open();
			//读取数据库内容并输出
			OleDbCommand cmd_test = new OleDbCommand(sql_search,connection);
			OleDbDataReader reader = cmd_test.ExecuteReader();
			OleDbCommand cmd_co