How to use GridView for efficient page turning?

skylee1983

For example, turning over a large amount of data. Relying on the page turning function that comes with GridView itself seems to be very inefficient, it can't be used. thank you very much! !! !! !!

iceice930

You can use this paging control: http://www.iceice930.com

呆呆的牛

My usual approach is to return the required records and the total number of eligible records in the data layer.
Then customize a page navigation control to display the corresponding page number!
The following is a code snippet of my data layer when paginating. Based on SQL 2005

            StringBuilder strSQL = new StringBuilder ();
            strSQL.Append ("SELECT * FROM (");
            strSQL.Append ("SELECT ProductID, ProductNO, CategoryID, CategoryTitle, ProductName, MarketPrice, MemberPrice, ProductParams, Description, ImagesCount, CreateDate, ROW_NUMBER () OVER (Order By ProductID Desc) AS RowNum from Product");
            strSQL.Append (") AS T WHERE RowNum BETWEEN @StartRow AND @EndRow");
            IList <ProductInfo> tList = new List <ProductInfo> ();
            SqlParameter [] parameters = {
        new SqlParameter ("@ StartRow", SqlDbType.Int),
        new SqlParameter ("@ EndRow", SqlDbType.Int)
            };
            parameters [0] .Value = (index-1) * pagesize;
            parameters [1] .Value = index * pagesize;

skylee1983

ROW_NUMBER () OVER (Order By ProductID Desc) AS RowNum from Product

How can I not understand this sentence. .

What does ROW_NUMBER () mean?
And what does the OVER function mean?

dydcool

I heard that stored procedure paging is more popular, and even large volumes can handle it.

Is GridView pagination slow? No ~~~ I tested hundreds of thousands of data and it was very fast.

skylee1983

The paging principle of GridView is to read all the data into the DataSet, and then paging. Isn't this a huge waste? If the stored procedure turns pages in ACCESS, will it not work? Should be written to the program, then How to write?

thewangyue

LZ is in Haixi?

白鸽天使

I suggest you all take a look at http://www.cnblogs.com/白猪天使/MyPosts.html here to introduce the NicPetShop article

Paging performance is better here, using row_number()
And with a lot of extension methods

Aoablue

Stored procedure or paging control

情书猎手

The paging function of GridView is very slow
Bind the data source yourself