Question about DataTable

  • Thread starter Thread starter angus
  • Start date Start date
A

angus

Hi all,

I have made a Datatable in my vb code. can i insert those DataTable records
into the database directly besides making the sql insert statement? Any
tutorial is available for this?

Thank you for your help.

Regards,
Angus
 
You can use the CommandBuilder object to implicitly create the sql insert
statement for you - thought the commands generated might not work in every
case, and even the ones they do work in, the commands are not efficient or
optimized.

Why the propensity to not write a sql statement? :-)

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
 
Angus,

Did you create the DataTable schema manually, or by filling it with data
using a DataAdapter?
 
Hi Carsten,

the DataTable is created by filing the data using DataAdapter

Regards,
Angus
 
Hi Angus,

No, you'll have to have insert statements in one or the other way.
I suggest you to configure a dataadapter at design time..
 
Back
Top