今天看了事务的一个小小的总结

   程序如下&＃xff1a;让它记录下我对它的理解吧&＃xff01;

class Program
    {
        static void Main(string[] args)
        {
            string conStr&＃61;&＃64;"Data Source&＃61;MICROSOF-E258B5\SQLSERVER2008;Initial Catalog&＃61;PB_BookShopDemo;Integrated Security&＃61;True";
            string[] paraTran &＃61; new string[] { "d","fd","dfas","fafdf"};
            using (SqlConnection con &＃61; new SqlConnection(conStr))
            {
               
                using (SqlCommand cmd &＃61; con.CreateCommand())
                {
                    con.Open();
                    SqlTransaction tran &＃61; con.BeginTransaction();
                    cmd.Transaction &＃61; tran;
                    try
                    {
                        for (int i &＃61; 0; i                         {
                            string sql &＃61; "insert into T_Student(Name) values (&＃39;"&＃43;paraTran[i]&＃43;"&＃39;)";//这里注意拼接sql语句&＃xff01;
                            cmd.CommandText &＃61; sql;
                            cmd.ExecuteNonQuery();
                        }
                        tran.Commit();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                        tran.Rollback();
                    }
                    finally
                    {
                        con.Close();
                        Console.WriteLine("插入成功&＃xff01;");
                        Console.ReadKey();
                    }

                }
            }
        }
    }