Hi all![]()
I make a function for execute multile query I am using transaction commit and rollback in it!
but the problem is how to commit the transaction it showing me error that use of unsigned variable transaction!
C# Code:
public bool ExecuteMultipleQuery(string[] queryString) { SqlConnection myConnection; System.Data.SqlClient.SqlTransaction transaction; DbCommand dbCommand; myConnection = OpenNewConnection();//OPEN THE CONNECTION dbCommand = myConnection.CreateCommand(); try { transaction = myConnection.BeginTransaction(); dbCommand.CommandType = CommandType.Text; dbCommand.Transaction = transaction; dbCommand.Connection = myConnection; foreach (string query in queryString) { dbCommand.CommandText = query; dbCommand.ExecuteNonQuery(); } transaction.Rollback(); return true; } catch (Exception ex) { transaction.Commit();//HERE GIVING ME ERROR USE OF UNSIGNED //VARIABLE transaction return false; } finally { myConnection.Close(); dbCommand.Dispose(); } }




Reply With Quote