Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Suggestion needed for huge DataGrid

Thread Tools

Suggestion needed for huge DataGrid

Hardy Wang
Posts: n/a
Hi all:
Our web site uses 3-tier structure, the middle tier is a web service. We
also use Microsoft Data Access Application Block to access sql server.
Now I have to display a DataGrid with huge amount of data on web page,
of course the DataGrid has pager. But even though, the web service still
will return full DataSet to web server, and let web server to handle pages.
Since Microsoft Data Access Application Block does not support
SqlDataAdapter.Fill(DataSet, startReocrd, maxRecord, tableName) to reduce
the size of DataSet. Do you think there is a better way to improve
Yes, I can always extend Microsoft Data Access Application Block and
build my own pager.

ICQ: 3359839
yours Hardy

Reply With Quote
Posts: n/a
Hi Hardy,

May I suggest two solutions:
-if the full set of lines is going to be requested sooner or later, fill the
DataSet and place it in the Cache for the first time, then read it from the
-if you don't need the full set of lines, you may use the SqlDataReader
combined with a TOP N command in your SQL query.
To reply, remove a "l" before the @ sign.

Arnaud Weil - MCT, MCSD.Net, MCAD.Net

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Memory error due to the huge/huge input file size Python 3 11-20-2008 07:21 PM
MDS File(s) Burning Program Suggestion Needed Scratch Computer Support 4 08-07-2005 03:47 AM
70-229 books suggestion needed fj MCSD 1 05-18-2005 10:36 PM
Huge DB query ideas needed iksrazal Java 0 03-09-2005 03:03 PM
Huge XML data needed Beda Christoph Hammerschmidt XML 15 04-21-2004 01:59 PM