asp.net创建事务的方法

/// <summary>
/// 保存表单
/// </summary>
/// <param name="context"></param>
protected void save()
{
 List<string> list = new List<string>();
 list.Add(string.Format("insert into picsone(model,idser,idflg,lmuser,lmdate,lmtime) values('{0}','{1}','{2}','{3}',{4},{5})", "T1002", "Y", "N", "U001", 20161103, 140025));
 list.Add(string.Format("insert into picstwo(model,idser,idflg,lmuser,lmdate,lmtime) values('{0}','{1}','{2}','{3}',{4},{5})", "T1002", "Y", "N", "U001", 20161103, 140025));
 bool bol = ExecuteTransaction(list);
 if (bol)
 {
 MessageBox.Show("保存成功！");
 }
 else
 {
 MessageBox.Show("保存失败！");
 }
}

/// <summary>
/// 执行语句
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
private bool ExecuteTransaction(List<string> list)
{
 using (SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["LocalConnectionString"].ToString()))
 {
 SqlCommand command = new SqlCommand();
 SqlTransaction transaction = null;
 try
 {
 connection.Open();
 transaction = connection.BeginTransaction();
 command.Connection = connection;
 command.Transaction = transaction;
 
 for (int i = 0; i < list.Count; i++)
 {
 command.CommandText = list[i];
 command.ExecuteNonQuery();
 }
 
 transaction.Commit();
 connection.Close();
 return true;
 }
 catch
 {
 transaction.Rollback();
 connection.Close();
 return false;
 }
 }
}