HELP!!! VB.net BATCH INSERT

[neilphan]

Hi All,


I was wondering if there was a way to do a "batch insert", insert more
than 1 row at a time. I have an application that currently reads from
a file and insert each record 1 row at a time into the database....this

takes alot of time due to the number of records.


My basic question is there a way to do several inserts as "batch
inserts" at a time with one command, one connection, and one database
call?


In Java, I have performed these type's of "batch inserts/updates"
before, but not sure if MS dotNet has this feature in their ADO.net
framework


Your help would greatly be appreciated,


Thanks,
Neil

 

[Marina]

Define 'batch'.

You can string multiple sql insert statements together separated by a
semicolon and execute that in one round trip to the database.

If you are using the adapter objects, then there is no way in 1.1, however
2.0 has improvements in this area. I believe it allows batch statements and
bulk inserts.