How to run multiple SQL commands in a single SQL connection?

by

Just change the SqlCommand.CommandText instead of creating a new SqlCommand every time. There is no need to close and reopen the connection.

// Create the first command and execute
var command = new SqlCommand("<SQL Command>", myConnection);
var reader = command.ExecuteReader();

// Change the SQL Command and execute
command.CommandText = "<New SQL Command>";
command.ExecuteNonQuery();

More Related Contents:

  1. Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
  2. Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?
  3. An unhandled exception of type ‘System.InvalidOperationException’ occurred in System.Data.dll?
  4. Call a stored procedure with parameter in c#
  5. Insert 2 million rows into SQL Server quickly
  6. Calling stored procedure with return value
  7. When should “SqlDbType” and “size” be used when adding SqlCommand Parameters?
  8. SQL command INSERT is working but the data not appear in table
  9. Return value from SQL Server Insert command using c#
  10. How to pass sqlparameter to IN()? [duplicate]
  11. How do I return multiple result sets with SqlCommand?
  12. Connection timeout for SQL server
  13. MultipleActiveResultSets=True or multiple connections?
  14. WHERE IN (array of IDs)
  15. Creating a SQL Server table from a C# datatable
  16. SQL: Update a row and returning a column value with 1 query
  17. How to keep single SQL Server connection instance open for multiple request in C#?
  18. Do I have to Close() a SQLConnection before it gets disposed?
  19. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  20. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  21. What size do you use for varchar(MAX) in your parameter declaration?
  22. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  23. Is it better to execute many sql commands with one connection, or reconnect every time?
  24. Fastest method for SQL Server inserts, updates, selects
  25. Why does the SqlParameter name/value constructor treat 0 as null?
  26. How do I connect to a SQL database from C#?
  27. How to get efficient Sql Server deadlock handling in C# with ADO?
  28. Passing array to a SQL Server Stored Procedure
  29. How can I Pass a Table Name to SqlCommand?
  30. ‘Must Declare the Scalar Variable’ Error When Passing a Table-Valued Parameter to a Parameterized SQL Statement

Leave a Comment