Millions of record show possible in Grid view

Posted by Rajesh081725 under ASP.NET on 5/25/2017 | Points: 10 | Views : 3201 | Status : [Member] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

How to show millions of records in the Grid view control using ASP.NET?

Can you provide the example of sample code.

Runtime gridview will show only 50 records on the same. But millions records show to only one page is possible?

Thanks,
Rajesh

Time is Gold
Thanks & Regards,
Rajesh Kumar,
9962038582.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Raja on: 5/25/2017 [Member] Starter | Points: 25

0	What is the logic behind showing millions of records into a single page? Theoretically it is possible provided your server, network bandwidth and database is fast and capable enough to provide those data in time. No separate or special coding is required, just use typical coding to populate data into the GridView. For example, you can read this post and know how to populate data into the GridView - http://www.dotnetfunda.com/articles/show/1400/how-to-generate-gridview-columns-dynamically-based-on-user-selection. Thanks Regards, Raja, USA Rajesh081725, if this helps please login to Mark As Answer. \| Alert Moderator

What is the logic behind showing millions of records into a single page?

Theoretically it is possible provided your server, network bandwidth and database is fast and capable enough to provide those data in time.

No separate or special coding is required, just use typical coding to populate data into the GridView.

For example, you can read this post and know how to populate data into the GridView - http://www.dotnetfunda.com/articles/show/1400/how-to-generate-gridview-columns-dynamically-based-on-user-selection.

Thanks

Regards,
Raja, USA

Rajesh081725, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: A2H on: 5/25/2017 [Member] [MVP] Silver | Points: 25

0	When you display millions of records in a single page in gridview then there is a high change that you may face performance issue while doing any operations in gridview. You might consider taking one of the below suggestion Add paging to GridView and display set of records(say 50) in one page and user can got next page to view the other records. You might also add the filtering option to gridview so that they can filter the result and work on small result set instead of millions of records Thanks, A2H My Blog Rajesh081725, if this helps please login to Mark As Answer. \| Alert Moderator

When you display millions of records in a single page in gridview then there is a high change that you may face performance issue while doing any operations in gridview.
You might consider taking one of the below suggestion
Add paging to GridView and display set of records(say 50) in one page and user can got next page to view the other records. You might also add the filtering option to gridview so that they can filter the result and work on small result set instead of millions of records

Thanks,
A2H
My Blog

Rajesh081725, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: A2H on: 5/25/2017 [Member] [MVP] Silver | Points: 25

0	Another option is to implement Load on Demand during scroll. You can take a look at the below article for step by step instructions https://www.aspsnippets.com/Articles/Load-on-demand-data-in-GridView-on-scroll-using-ASPNet-and-jQuery-AJAX.aspx Thanks, A2H My Blog Rajesh081725, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajesh081725 on: 5/26/2017 [Member] Bronze | Points: 25

0	i want to view the millions of records in GRID VIEW at same page.. I cant click next page.. Normally grid view will display 50 records per page. But my requirement is be display the millions of records at the single page. Is it possible? Time is Gold Thanks & Regards, Rajesh Kumar, 9962038582. Rajesh081725, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajesh081725 on: 5/26/2017 [Member] Bronze | Points: 25

0	Hi Jitendra, Thanks for your information. I try to open this above mentioned url but its not working. This site can’t be reached https’s server DNS address could not be found error. Time is Gold Thanks & Regards, Rajesh Kumar, 9962038582. Rajesh081725, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts