Connected DataSet?

  • Thread starter Thread starter Brian Scott
  • Start date Start date
B

Brian Scott

I have a customer with over 60,000 records bound to a main accounts form.
Using a dataset as the datasource I have to prefill the accounts table
before binding which can take around a minute to complete.

What is the best practice for binding a large number of records to a single
form? I thought of using a datareader to move sequentially through the
records but the user needs to be able to perform a rowfilter across all the
accounts.

Does any have any advice? Thanks.
 
Hi Brian,

I would use a sql select statement using WHERE clause - IOW I wouldn't
retrieve all data at once.
 
If using an sql statement to query each record, how would I then say allow
the user to select subsets of data without having to rerun a select
statement between ranges?

Also, many of our reports required the entire set and then filtered down via
the dataview rowfilters, how can this be adapted to the query as you require
approach?
 
Brian,

When you filter it down using a dataview rowfilter than you can that as well
using a "Where" as Miha advices (And I agree with him).

Much more pleasant for a user because he has not to wait a minute as you
said.
(And than by instance use a datareader to get the rows row by row, you can
than direct start printing).

However just my thought,

Cor
 
Back
Top