suchi rana

suchi rana

  • NA
  • 18
  • 30.9k

How to execute multiple queries with one connection

Jul 17 2013 7:16 AM
Hi,

How to execute multiple queries with one connection in vb.net.
I am using windows vb.net with Access DB.

In my project i need to delete the records of 15 tables.
Every time i need to open the connection and close the connection for every delete statement.
Same way i need to insert the records for 15 to 20 tables.
It took lot of time to execute.

is it possible to delete the records from multiple tables with one connections?

Need code for this

Sucharitha


Answers (4)