gridview数据点播 [英] gridview data on demand

问题描述

你好..



我有一个1000行数据的网格视图，我做了分页，pagesize是5但是当我绑定gridview的1000个数据时马上绑定。



但是当我改变页面的时候，我希望绑定（使用简单的方法）5乘5记录。

Hello..

I have one grid view with 1000 row data and i do paging on that and pagesize is 5 but when i bind gridview at that 1000 data bind at once .

but i want to bind(using simple way) 5 by 5 record when i change page.

推荐答案

Hello Archit，



这意味着您必须编写分页查询。不同的数据库提供了不同的方法来实现它



对于MySQL，PostgresSQL，您可以使用 LIMIT offset，pagesize 子句与您的查询返回特定页面数据库。对于Oracle，您可以使用如下所示的查询

Hello Archit,

What it means that you will have to write a pagination query. Different databases provide different methods to achieve this.

For MySQL, PostgresSQL you can use LIMIT offset, pagesize clause with your query to return a particular page from the database. For Oracle you can use a query something like shown below

SELECT *
FROM (
    SELECT ename, sal,
        row_number()
        OVER (ORDER BY sal DESC) rn
    FROM emp)
WHERE rn <= 3
ORDER BY sal DESC

对于SQL Server 2012，您可以使用以下语法

For SQL Server 2012 you can use following syntax

SELECT * FROM TableName ORDER BY id OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;

问候，

Regards,

这篇关于gridview数据点播的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！