Insert Only With a Dataset

[Guest]

Is there a way to do an insert with datasets without first querying the data
source? For efficiency reasons I'd like to avoid filling the dataset from
the data source because in this case it's not necessary.

 

[Sahil Malik]

Yes it is. However, what would you insert, if the dataset wasn't already
filled? i.e. where did you get the data in the dataset from?

There could be other sources, and as long as the dataset is properly
populated and edited, you can most certainly call "Update" without having
done a "Fill" earlier.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[Italo Silveira]

Yes. In SQL Server you can use SET FMTONLY to return only the schema, you
can also use TOP 0 to return only the schema, or manually create the table
schema.

Good luck,
Italo