Re: Lazy filling a large dataset

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: W.G. Ryan eMVP (WilliamRyan_at_NoSpam.gmail.com)
Date: 02/02/05 

Date: Tue, 1 Feb 2005 22:08:25 -0500

If you're using Sql Server you can append the querys and run them in batch -
or you can just fill the datasets in increments using different commands.
Either way you'll get there. 

-- 
W.G. Ryan MVP (Windows Embedded)
TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
<sutphinwb@nospam.nospam> wrote in message
news:OEw0ZKMCFHA.3696@TK2MSFTNGP14.phx.gbl...
> hi
>
> is it possible to fill a dataset such that it can be done in increments?
> for instance, if I have a large table with a big schema (like 50 columns -
> for whatever reason), could I fill a dataset table with a partial query
like
> (via a dataadapter
>
> SELECT key_value, name, address, phone, zip FROM bigtable
>
> to display in a grid, then when wants details, use a different command on
> the same adapter like so
>
> SELECT * FROM bigtable WHERE (key_value = ?)
>
> and have it fill in the rest of the record.
>
> The first time, the missing fields are null (I've done this and it works).
> If I attach the second select command and do a
> "myDataAdapter.Fill(aDataSet), it goes into a dead run doing something.
> Seems like I should be able to select new records into the dataset by
> tactical select statements without a whole lot of overhead.  If this were
> true, then I could test a record value to see if its been loaded, and kind
> of do a lazy init of the dataset.  However, I'm also curious what would
> happen on an update.  Probably better off have two instances of the same
> type dataset, one with short query and one with the full.
>
> what do you think?
>
> Bill
>
>

Relevant Pages

  • Re: create multiples Stored Procedures usign ADOB command
    ... > "Val Mazur" wrote in message ... >> Since GO is not a valid Transact-SQL statement, but a batch statement, ... >>> Into query analyzer, to run a query batch, GO command is used to run ...
    (microsoft.public.vb.database.ado)
  • Re: sub total screen by screen
    ... field that returns a "group number" value that increments every 20 ... get the value from a hidden textbox on your form. ... One drawback of this approach is that the query is not updateable. ... then have the user press a button ...
    (microsoft.public.access.forms)
  • Re: Do...Loop Help
    ... messed up the query I posted. ... University of Maryland Baltimore County ... Just the time in 15 minute increments ... "John Spencer" wrote: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Do...Loop Help
    ... messed up the query I posted. ... University of Maryland Baltimore County ... Just the time in 15 minute increments ... "John Spencer" wrote: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Summarize dates for like records
    ... do what you describe depends on whether you are storing a true Date/Time ... When doing so the query returns with the ... but the dates are broken down into 5-minute increments. ...
    (microsoft.public.access.queries)