Question

I have a gridview with a sql datasource. I have almost 35000 records which are being populated into the table. That usually hangs the system while loading from the server.

在从电网或数据来源取得结果时,是否有办法。

Something like it loads the first 1000 results first .. once the user is done going through those results, then it loads the next 1000 results automatically. I tried to use caching ...

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString=""           SelectCommand="SELECT * FROM [Table1]" EnableCaching="true" CacheDuration="3000" >

I assume this caches the data and all the other sql queries remain local to the cache instead of going to the database. But when I refresh the page, it loads all the records again and takes the same amount of time(a minute). So thats why I need something like loading the first 1000 records or something first.

Answer 1

You could design your query according to GridView page size. Let suppose You are at page 1 of Gridview and page size is set to 100. Then just select first 100 records from the database.

Answer 2

您的网格能够绘制和确定页数财产

AllowPaging="true" 
PageSize="100"

你的格格言应该像在 as页上那样。

<asp:GridView runat="server" AllowPaging="true" PageSize="100"

友情链接