Any attempt to render that much data in html will be slow. In fact, it might overwhelm some browsers causing machines to freeze up. Better start looking at paging options.
1. tried with "Repeater" control but autogenerate columns property is not there in that control. I cannot hard code all the columns and columns are dynamic
2. I am using stored procedure not inline queries.
sush_indus
Member
11 Points
168 Posts
Data Control to bind 20000 records in C#.Net 4.0
Nov 05, 2012 11:11 AM|LINK
Hi all
I want to bind huge data to UI with any of Data control and should be faster also.
*** I want autogenerate columns is TRUE. Because i cont predict columns it is a dynamic.
All suggesions are appreciated..
Thanks in Advance
Sush
anil.india
Contributor
2613 Points
453 Posts
Re: Data Control to bind 20000 records in C#.Net 4.0
Nov 05, 2012 11:16 AM|LINK
Do you have paging option?
http://msdn.microsoft.com/en-us/library/5dws599a(v=vs.80).aspx#DataAccess
http://msdn.microsoft.com/en-US/library/ms227679(v=vs.80).aspx
codepattern.net/blog ||@AnilAwadh
sush_indus
Member
11 Points
168 Posts
Re: Data Control to bind 20000 records in C#.Net 4.0
Nov 05, 2012 12:08 PM|LINK
I have 2 options
1. Some grid with paging
2. some grid without paging and with scroll.
I prefer 2nd option
Now i am using GridView its so slow.. I am looking for alternative...
Dan Bracuk
Contributor
3970 Points
1096 Posts
Re: Data Control to bind 20000 records in C#.Net 4.0
Nov 05, 2012 12:20 PM|LINK
Any attempt to render that much data in html will be slow. In fact, it might overwhelm some browsers causing machines to freeze up. Better start looking at paging options.
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Data Control to bind 20000 records in C#.Net 4.0
Nov 06, 2012 12:24 AM|LINK
If you don't wanna paging, I think you can:
1) Please use Repeater instead of GridView, which can be made up of wholly Html-based codes to fasten your speed.
2) Please use Stored procdure instead of embeded SQL select statements.
Reguards!
sush_indus
Member
11 Points
168 Posts
Re: Data Control to bind 20000 records in C#.Net 4.0
Nov 06, 2012 05:34 AM|LINK
I an very much thankful for ur replies
1. tried with "Repeater" control but autogenerate columns property is not there in that control. I cannot hard code all the columns and columns are dynamic
2. I am using stored procedure not inline queries.
I am getting "System.outofmemory" exception
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Data Control to bind 20000 records in C#.Net 4.0
Nov 06, 2012 06:46 AM|LINK
Well……I still suggest you do paging to bind to GridView, otherwises your memory cannot contain such a large amount of records.
RameshRajend...
Star
7983 Points
2099 Posts
Re: Data Control to bind 20000 records in C#.Net 4.0
Nov 06, 2012 07:19 AM|LINK
http://stackoverflow.com/questions/11543538/very-large-amount-of-data-on-gridview-in-asp-net
sush_indus
Member
11 Points
168 Posts
Re: Data Control to bind 20000 records in C#.Net 4.0
Nov 06, 2012 09:14 AM|LINK
I myself convinced with paging.. But if some one have some idea please share.... :-)
me_ritz
Star
9337 Points
1447 Posts
Re: Data Control to bind 20000 records in C#.Net 4.0
Nov 06, 2012 09:21 AM|LINK
If performance is the issue.....i suggest custom paging...fetch only that much data(i.e. pagesize) that you need to show per page...
In-built gridview paging fetches all data at once.... so go for Custom Paging - http://itdeveloperzone.blogspot.in/2011/01/custom-paging-in-grid-view.html