Lazy filling a large dataset

sutphinwb_at_nospam.nospam
Date: 02/02/05 

Date: Tue, 1 Feb 2005 20:00:23 -0500

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: ADPrep /forestprep failed 2000 to 2003 r2
    ... Additional post the output from "schupgr" from the command prompt on the 2000 DC. ... Disclaimer: This posting is provided "AS IS" with no warranties, ... So which adprep version from the R2 disk do you run, ... Click Active Directory Schema, ...
    (microsoft.public.windows.server.active_directory)
  • Re: ADPrep /forestprep failed 2000 to 2003 r2
    ... Here is the output of the "schupgr" command. ... Upgrading schema to version 31 ... So which adprep version from the R2 disk do you run, ... "Active Directory Schema" is displayed in the Add/Remove ...
    (microsoft.public.windows.server.active_directory)
  • Re: Execute stored procedure via web method.
    ... The only thing I might add is that you can generate a class named Command ... from this schema that lets you bypass any need to directly manipulate XML ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Need help importing / exporting a schema
    ... command to dump the ... entire schema to a text file. ... You should NOT extrapolate previous experience on other DBs to Oracle. ... provide text SQL schemas is to make it maximally difficult to change ...
    (comp.databases.oracle.misc)
  • Re: ADPrep /forestprep failed 2000 to 2003 r2
    ... So which adprep version from the R2 disk do you run, ... Click Active Directory Schema, ... Click Active Directory Schema so that the Classes and Attributes ... Make sure you run the adprep command with an account that is ...
    (microsoft.public.windows.server.active_directory)