none
Gridview sorting Problem RRS feed

  • Question

  • Hi,

    I am using gridview and i am loading more than 20,000 (twenty thousand records) records at a time.

    when i click the sorting for the parrticular column, i am getting page cannot be displayes.

    if i load less than 10,000 records then the sorting working fine.

    what is the problem in the gridview..?

    • Moved by CoolDadTx Wednesday, January 10, 2018 3:04 PM ASP.NET related
    Wednesday, January 10, 2018 11:32 AM

Answers

  • Thanks for your update.

    I forgot to mention languages.. it is in ASP.NET.

    I need sorting with paging of datagridview examples.

    • Marked as answer by Gani tpt Thursday, January 11, 2018 10:39 AM
    Wednesday, January 10, 2018 12:02 PM
  • Please post questions related to ASP.NET in the ASP.NET forums.

    Michael Taylor http://www.michaeltaylorp3.net

    • Marked as answer by Gani tpt Thursday, January 11, 2018 10:39 AM
    Wednesday, January 10, 2018 3:04 PM

All replies

  • Hello,

    Is this a GridView in ASP.NET or a DataGridView in Windows forms? How are you loading data e.g. via the DataSource or adding rows manually?

    No matter which one you should seriously consider using paging and provide a filter so that the user can display only the data needed for a specific operation.

    Nobody in general will need to see 20,000 rows of data.

    Resources

    https://www.aspsnippets.com/Articles/Paging-in-ASPNet-GridView-Example.aspx

    https://support.microsoft.com/en-us/help/307710/how-to-perform-paging-with-the-datagrid-windows-control-by-using-visua

    https://stackoverflow.com/questions/2825771/how-can-we-do-pagination-in-datagridview-in-winform


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    Wednesday, January 10, 2018 11:56 AM
  • Thanks for your update.

    I forgot to mention languages.. it is in ASP.NET.

    I need sorting with paging of datagridview examples.

    • Marked as answer by Gani tpt Thursday, January 11, 2018 10:39 AM
    Wednesday, January 10, 2018 12:02 PM
  • Please post questions related to ASP.NET in the ASP.NET forums.

    Michael Taylor http://www.michaeltaylorp3.net

    • Marked as answer by Gani tpt Thursday, January 11, 2018 10:39 AM
    Wednesday, January 10, 2018 3:04 PM
  • Thank You..
    Thursday, January 11, 2018 10:39 AM