Hi all,

in my program I initialize a lot of datatable (member of the same dataset)
with the .FillSchema method of the adapter at the startup. After when a user
trough the guy requests a such data, I populate the datatable with the .Fill
method.
If I have a such datatable (I'me sure it have been schemafilled) can I know
if that table is have been filles with .Fill method? If the table has 0 rows
is it because the sql table has 0 rows or because it hasn't been filled?

Perhaps you can add a row that has known place-holder values post
SchemaFill. Before Fill, clear the table and test for the place-holder to
see if "real" data was loaded. Why pre-populate with schema?

Show quoteHide quote

William (Bill) Vaughn wrote:
I load the database's schema into my dataset this task requires few time,
after that I can create (I automatically do this with a class of my own) all
the foreign key relationship, customize the datatables and pass them to the
controls of my application.
When I really know that some data have to be shown to the end user, I
populate the datatables involved with the fill command.
But before invoke the .Fill method it is useful to konw if the datatable has
ever been filled:

datatable with 0 record -> is it an empty one or it has never been filled?

datatable with more than 1 records -> sure, it has just been filled, no
other .Fill is required


Show quoteHide quote

Andrea,

The fill does filling the schema as well. Not complete but for that is as
well an command.

"missing schema etc).

Cor
Show quoteHide quote

Inserting from one db into another
leave connections open for how long?
Help on displaying combobox items
Bizarre slow query problem (again)
Newbie Missing Something with Access DB Update Using VB .NET