Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ObjectDataSource, SqlDataSource, DataSet

Thread Tools

ObjectDataSource, SqlDataSource, DataSet

Posts: n/a

I am working on a solution that needs to perform a search (search
criteria can be as little as 1 and as high as 20 fields) through an
average of 25,000 records and return results in a GridView. I only want
to return 150 results total, and page through them 10 results at a time
- but I also need to grab a count from the MSSQL server as to how many
TOTAL records were found. So maybe 4,500 records were found that met
the users' search criteria, but I only want to show the first 150, but
let the user know there were 4,500.

The GridView will need to page through these records, 10 at a time.
>From what I understand with this scenario and the DataSet, is that each

time the user clicks to go to a different page, the MSSQL server will
be re-queried and the DataSet re-filled each time, even though I'm only
retrieving 10 records for display. Caching 25,000+ records is not an
option due to the strain that this memory would take on the web server.
I've looked at the ObjectDataSource and custom pagination, but how do I
pass all the search parameters into this ObjectDataSource? Is the
ObjectDataSource even the most efficient way to do this? Since I have
to refer to a file in the App_Code folder with this method, I am
confused as to how I write the code in the .CS page in the App_Code
folder. Is there any type of comprehensive resource out there that
explains how to write custom classes and how to pass parameters into

Any help anyone can give would be greatly appreciated. Thanks for your

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
DataSet and dataSet JimO ASP .Net 2 03-08-2006 02:39 PM
copying a datatable content from an untyped dataset into a table which is inside a typed dataset Nedu N ASP .Net 2 10-31-2003 01:05 PM
Ccopying a datatable content from an untyped dataset into a table which is inside a typed dataset Nedu N ASP .Net 1 10-31-2003 02:39 AM
DataSet to DataSet Joseph D. DeJohn ASP .Net 1 08-04-2003 03:25 AM