Although WebGrid supports large table binding, we often recommend customers to load and retrieve data efficiently by either using predefined filter or asked user to enter some search criteria before requesting data. Best design & pattern in application architecture is always our first priority and suggestion.

There are articles and sample that you can read which discuss about how to improve WebGrid’s performance. Some of the articles are listed down here.

• Faster than “fastest ASP.NET Grid”
• Faster than “fastest ASP.NET Grid” – part II
• Rich features in low client footprint

The sample can be checked at here.

Hope this helps.

Anyway,it can solve my problem.
If I do not install .netframework3.5,I will can not use Linq.
Could you give me the other suggestion for loading large datas?
thank you,Yudi

To load large data into client’s browser may cause performance issue.

In order to get better performance when render large data, we need to split the data into small pieces. Combining paging, grouping, load on demand, and client-binding feature of WebGrid might helps.

Could you please show me a demo about using paging  stored procedure with Webgrid ??

Like:

<script type="text/javascript">

Load()
{
 //init PagingSliderBar
}
getFirstPage()
{
//call C# code  with paging

}
getNextPage()
{

//call C# code  with paging
}
getPreviousPage()
{

//call C# code  with paging
}
getLastPage()
{

//call C# code  with paging
}
    </script>

thank you,Yudi

Please check our reference sample, ClassicPagingUsingCustomDataRetrieval.aspx, in the local WebGridSamples project or check the live sample at the following link, http://live.intersoftpt.com/cs/WebGrid/ClassicPagingUsingCustomDataRetrieval.aspx.

In order to perform custom data retrieval for classic paging, we need to set the value of PagingLoadMode property to Custom. To handle the logic that performs custom data retrieval, we need to have a select method with three parameters signature: startRow, maximumRows, and sortExpression. To learn more about custom data retrieval codes, please take a look at App_Code\dsNorthwind_Extended.cs.

We also provide more articles that discuss about this topic, please kindly check WebGrid 7 documentation and search for the title of the following topic:

• Custom Paging
• Walkthrough: Implementing Custom Paging using ObjectDataSource
• Walkthrough: Implementing Custom Paging using ISDataSource
• How-to: Implement Custom Load-On-Demand Paging

Please let us know whether it helps or not.

Thank you,you are so kind to me!
It is very helpful!