public bool ExecuteSqlTransaction(string[] strSQL)
{
SqlCommand sc = new SqlCommand(strSQL[0], con);
sc.CommandType = CommandType.Text;
try
{
sc.Connection.Open();
}
catch
{
//MessageBox.Show("与数据库通讯异常!系统将非正常退出!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
using (SqlTransaction trans = con.BeginTransaction())
{
sc.Transaction = trans;
try
{
for (int i = 0; i < strSQL.Length; i++)
{
sc.CommandText = strSQL[i];
sc.ExecuteNonQuery();
}
trans.Commit();
}
catch
{
trans.Rollback();
return false;
throw;
}
finally
{
con.Close();
}
}
return true;
}
{
SqlCommand sc = new SqlCommand(strSQL[0], con);
sc.CommandType = CommandType.Text;
try
{
sc.Connection.Open();
}
catch
{
//MessageBox.Show("与数据库通讯异常!系统将非正常退出!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
using (SqlTransaction trans = con.BeginTransaction())
{
sc.Transaction = trans;
try
{
for (int i = 0; i < strSQL.Length; i++)
{
sc.CommandText = strSQL[i];
sc.ExecuteNonQuery();
}
trans.Commit();
}
catch
{
trans.Rollback();
return false;
throw;
}
finally
{
con.Close();
}
}
return true;
}