Insert Only With a Dataset

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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/
 
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
 
Back
Top