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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear a datatable before inserting new records 7
How to insert row in typed dataset 4
Inserting Multi Table Dataset into Dataset 1
DataTable to SQL server table 2
Datatable as bindingsource datasource 1
Save System.Data.DataTable to new SQL Table 6
Creating datatables 4
How can we insert a DataTable into database? 3

Back
Top