How to execute multiple queries with one connection

Question

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

Hemant Srivastava · Answer

From your error Characters found after end of sql statement it looks like you have some syntex error in your SQL query. Put the breakpoint after the query and get the query string at run time and paste it in SQL. In this way you could easily figure it out what is wrong in the query...

Vikash Mahata · Answer

You can execute many SQL Queries in one Connection in VB.NET Try like this: Try conn.Open() cmd1.ExecuteNonQuery() cmd2.ExecuteNonQuery() cmd3.ExecuteNonQuery() cmd4.ExecuteNonQuery() ............................... ................................ cmd15.ExecuteNonQuery() conn.Close() Catch ex As Exception End Try

suchi rana · Answer

Hi Kunal Thanks for your reply. I have already tried that. I am using Access DB. It shows the error as:-Characters found after end of sql statement

Kunal Vaishya · Answer

Hi you can set multiple Query for delete in one command in Command Text Refer this link for More http://www.codeproject.com/Articles/306722/Executing-multiple-SQL-statements-as-one-against-S