如何从拆分记录中的数据库中获取数据 [英] how to fetching data from database in split records

问题描述

亲爱的朋友们，



我在impliments项目时遇到了一些问题。我有很多记录，假设1缺乏，我想从数据库中获取所有完整数据但是分割数据意味着我第一次获得大约2万个记录，然后第二次获得2万个这样的类型，并且它们在网格视图上显示数据。如何在asp.net中获得这种类型的实现





感谢先进!!

解决方案

保持可配置的记录数（20000或10000）。然后激活你的查询，从........中选择顶部（没有记录）

在MSSQL的更高版本中，您可以使用OFFSET和FETCH NEXT选项



例如第一次恍惚



SELECT *来自[TableName]

ORDER BY [专栏]

OFFSET 0

FETCH NEXT 10000 ROWS



和下一次付款



SELECT *来自[TableName]

ORDER BY [专栏]

OFFSET 10000

FETCH NEXT 10000 ROWS ONLY

Dear Friends,

I have some problem when impliments projects.I have lots of records suppose 1 lack and i want to get all full data from database but in split data means first time i get records near about 20 thousand then second time 20 thousand such type and they show data on grid view.how to get such type of implimentation in asp.net


thanks in advanced !!

解决方案

Keep the number of records configurable (20000 or 10000). Then fire your query as, "select top (no. of records) from........"

In later versions of MSSQL you can use the OFFSET and FETCH NEXT options

e.g. For the first trance

SELECT * from [TableName]
ORDER BY [Column]
OFFSET 0
FETCH NEXT 10000 ROWS ONLY

and for the next tranche

SELECT * from [TableName]
ORDER BY [Column]
OFFSET 10000
FETCH NEXT 10000 ROWS ONLY

这篇关于如何从拆分记录中的数据库中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！