01.public static int ExecuteNonQuery(string procedureName, SqlParameter[] parameters)
02.{
03. SqlConnection oConnection = new SqlConnection(AccessConfig.GetConnectionString());
04. SqlCommand oCommand = new SqlCommand(procedureName, oConnection);
05. oCommand.CommandType = CommandType.StoredProcedure;
06. int iReturnValue;
07. oConnection.Open();
08. using (SqlTransaction oTransaction = oConnection.BeginTransaction())
09. {
10. try
11. {
12. if (parameters != null)
13. oCommand.Parameters.AddRange(parameters);
14. oCommand.Transaction = oTransaction;
15. iReturnValue = oCommand.ExecuteNonQuery();
16. oTransaction.Commit();
17. }
18. catch
19. {
20. oTransaction.Rollback();
21. throw;
22. }
23. finally
24. {
25. if (oConnection.State == ConnectionState.Open)
26. oConnection.Close();
27. oConnection.Dispose();
28. oCommand.Dispose();
29. }
30. }
31. return iReturnValue;
32.}
