ADO.NET级别事务 SqlTransaction

        /// <summary>
        /// 事件 SqlTransaction
        /// </summary>
        /// <returns></returns>
        public static int sqlTran()
        {
            int i=0;
            string conString = "data source=.;database=Codematic;user=sa;password=123";
            SqlConnection myConnection = new SqlConnection(conString);
            string strSql1 = "update P_Product set Name='电脑 1' where id=52";
            string strSql2 = "update5 P_Product set Name='电脑 2' where id=52";
            myConnection.Open();

            SqlTransaction myTrans = myConnection.BeginTransaction();
            SqlCommand myCommand=new SqlCommand(strSql1,myConnection,myTrans);

            try
            {
                int rows = myCommand.ExecuteNonQuery();
                i++;
                myCommand.CommandText = strSql2;
                rows = myCommand.ExecuteNonQuery();
                i++;
                myTrans.Commit();

            }
            catch
            {
                i = 0;
                myTrans.Rollback();
            }
            finally
            {
                myConnection.Close();
            }
            return i;
        }