SqlConnection conn
=
new
SqlConnection();
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
foreach ()
{
string sql = "" ;
SqlCommand cmd = new SqlCommand(sql,conn,tran);
SqlParameter[] pars = new SqlParameter[]{
new SqlParameter( "" ,value),
...
}
cmd.Parameters.AddRange(pars);
cmd.ExecuteNonQuery();
}
tran.Commit();
} catch
{
tran.Rollback();
}
finally
{
conn.Close();
}
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
foreach ()
{
string sql = "" ;
SqlCommand cmd = new SqlCommand(sql,conn,tran);
SqlParameter[] pars = new SqlParameter[]{
new SqlParameter( "" ,value),
...
}
cmd.Parameters.AddRange(pars);
cmd.ExecuteNonQuery();
}
tran.Commit();
} catch
{
tran.Rollback();
}
finally
{
conn.Close();
}