public bool transactionExce(string []sqls)
{
try
{
openCon();
SqlTransaction tran = con.BeginTransaction();
SqlCommand com = con.CreateCommand();
try
{
com.Transaction = tran;
com.CommandType = CommandType.Text;
for (int i = 0; i < sqls.Length; i++)
{
com.CommandText = sqls.ToString();
com.ExecuteNonQuery();
}
tran.Commit();
return true;
}
catch
{
try
{
tran.Rollback();
return false;
}
catch
{
return false;
}
}
}
catch
{
return false;
}
finally {
closeCon();
}
}
{
try
{
openCon();
SqlTransaction tran = con.BeginTransaction();
SqlCommand com = con.CreateCommand();
try
{
com.Transaction = tran;
com.CommandType = CommandType.Text;
for (int i = 0; i < sqls.Length; i++)
{
com.CommandText = sqls.ToString();
com.ExecuteNonQuery();
}
tran.Commit();
return true;
}
catch
{
try
{
tran.Rollback();
return false;
}
catch
{
return false;
}
}
}
catch
{
return false;
}
finally {
closeCon();
}
}