如何显示来自SQL Server的数据 [英] How to display data from sql server

问题描述

大家好，

如果假设的话，我的数据库中有50,000条记录.我正尝试在gridview中显示.
但是我的要求是，它必须一次显示100条记录，当我单击下一步"按钮时，应该发生回发，并且应该显示从101到200的下一条100条记录，依此类推..

所以你能给我解决我的要求吗?

谢谢
Gowtham

Hi All,

If suppose ,i have 50,000 of records in my database.I am trying to displaying in gridview.
But my requirement is, It has to display 100 records at a time and when i click on "Next" button the postback should occur and should display next 100 records from 101 to 200 like so on..

So can u please give me solution for my requirement.

Thanking you,
Gowtham

推荐答案

检查此处 [ ^ ]

您可以在ASP网格视图控件中设置分页功能.您可以将页面大小设置为100.

然后，您可以使用网格底部的分页按钮导航到差异页面.您还可以自定义分页按钮的类型，即
数字或箭头等.

使用此链接
http://msdn.microsoft.com/en-us/library/aa479347.aspx [ ^ ]

You can set the paging facility in the ASP grid view control. you can set the paging size to 100.

Then you can use the paging buttons in the bottom of the grid to navigate to the diff pages. You can also customize the type of paging buttons, ie,
numbers, or arrows etc.

Use this link
http://msdn.microsoft.com/en-us/library/aa479347.aspx[^]

您好，Gowtham:rose:

:thumbsdown:
使用分页概念，另请参阅下面的链接...

http://programming.top54u.com/post/ASP-Net-2-0-Gridview-Paging-using-C-sharp.aspx [

Hi, Gowtham :rose:

:thumbsdown:
Use the Paging Concepts, also refer the below Link...

http://programming.top54u.com/post/ASP-Net-2-0-Gridview-Paging-using-C-sharp.aspx[^]

这篇关于如何显示来自SQL Server的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！