asp.net建立事務的方法

1、建立List用於存放多條語句

/// <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("儲存失敗！"); }}

2、調用ExecuteTransaction方法，並返回傳回值true為成功，false為失敗，語句並復原

/// <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;  } }}