You cannot set the SqlCommand.Transaction property if it is already set to a specific value, and the command is in the process of executing. If you set the transaction property to a System.Data.SqlClient.SqlTransaction object that is not connected to the same System.Data.SqlClient.SqlConnection as the System.Data.SqlClient.SqlCommand object, an exception is thrown the next time that you attempt to execute a statement.