Insert all rows from datatable to database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ypul - 04 Apr 2006 11:35 GMT

How can Ido this ?

I have a datatable/ dataset, which has rows with data in it.
I want to bulk insert all rows from the dataset to database table (having
same table structure).
what is the best way, with out looping through everyrow and inserting into
database.

Thanks

Reply to this Message

Otis Mukinfus - 04 Apr 2006 12:39 GMT

>How can Ido this ?
>
[quoted text clipped - 5 lines]
>
>Thanks

INSERT INTO destination (col1, col2)
SELECT col1, col2
FROM source

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com

Reply to this Message

ypul - 06 Apr 2006 15:31 GMT

w.r.t what you have written , my source is dataset and my destination is a
database.
How can I write a query ?
if u can please give a sample code,

Thanks

> >How can Ido this ?
> >
[quoted text clipped - 15 lines]
> http://www.arltex.com
> http://www.tomchilders.com

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...