datagrid分页从后端获取数据也很简单-白红宇

datagrid分页从后端获取数据也很简单

阅读量：6292 次

发布时间：2019-06-22

本文共 3290 字，大约阅读时间需要 10 分钟。

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Datagrid.aspx.cs" Inherits="EasyUI.Datagrid" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%-- <link href="Styles/jQuery/EasyUI/easyui.css" rel="stylesheet" type="text/css" />

$(function () {

$dg = $("#dg");

$dg.datagrid({

url: "Data.ashx",

title: "DataGrid",

collapsible: true,

pageList: [4, 10, 15, 20],

pageSize: 4,

width: 500,

rownumber:true,

columns: [[

{ checkbox:true },

{ field: "mId", title: "MenuID", width: 100, align:"center" },

{ field: "mName", title: "MenuName", width: 100, align: "center" },

{ field: "mIsDel", title: "MenuIsDel", width: 100, align: "center" },

{ field: "mAddtime", title: "MenuAddtime", width: 100, align:"center" }

]],

pagination:true

});

</script>

</head>

<body>

</body>

</html>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

//using System.ServiceModel.Web;

using System.Data;

using System.Data.SqlClient;

namespace EasyUI

{

/// <summary>

/// Data1 的摘要说明

/// </summary>

public class Data1 : IHttpHandler

{

public void ProcessRequest(HttpContext context)

{

context.Response.ContentType = "application/json";

// context.Response.ContentType = "text/plain";

string page = context.Request.Form["page"];

string rows = context.Request.Form["rows"];

int pageNum = int.Parse(page);

int pageSize = int.Parse(rows);

int total = 0;

string rs;

using (SqlConnection conn = new SqlConnection())

{

conn.ConnectionString = "Data Source=.;Initial Catalog=CompanyGZ;Integrated Security=True";

using (SqlCommand cmd = new SqlCommand())

{

string sql = "SELECT COUNT(*) FROM Menu;";

cmd.Connection = conn;

cmd.CommandText = sql;

conn.Open();

total = (int)cmd.ExecuteScalar();

sql = string.Format("SELECT TOP {0} mId, mName, mIsDel, mAddtime " +

"FROM Menu " +

"WHERE mId NOT IN (SELECT TOP {1} mId FROM Menu);",

pageSize, (pageNum - 1) * pageSize);

cmd.CommandText = sql;

using (SqlDataReader reader = cmd.ExecuteReader())

{

string rsRows = "";

while (reader.Read())

{

string tmpRs = string.Format("\"mId\":\"{0}\"," +

"\"mName\":\"{1}\"," +

"\"mIsDel\":\"{2}\"," +

"\"mAddtime\":\"{3}\"",

reader["mId"],

reader["mName"],

reader["mIsDel"],

reader["mAddtime"]);

rsRows += "{" + tmpRs + "},";

}

rsRows = rsRows.Substring(0, rsRows.Length - 1);

rsRows = "[" + rsRows + "]";

rs = string.Format("\"total\":\"{0}\"", total);

rs += ",\"rows\":" + rsRows;

rs = "{" + rs + "}";

context.Response.Write(rs);

}

// context.Response.Write(rs);

}

public bool IsReusable

{

get

{

return false;

}

转载于:https://www.cnblogs.com/kexb/p/3683051.html

你可能感兴趣的文章

虚拟机 liunx系统以 root 身份登录权限

查看>>

《当程序员的那些狗日日子》（五十一）太不给力的年终奖

查看>>

LeetCode(203): Remove Linked List Elements

python库的学习系列之 15. Generic Operating System Services

查看>>

使用excel进行数据挖掘（5）---- 应用场景分析

查看>>

【CSS】隐藏多行文本框Textarea在IE中的垂直滚动栏

查看>>

2017-2018-1 《信息安全系统设计基础》实验一报告

查看>>

2017-2018-1 20155303 《信息安全系统设计基础》第五周学习总结