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

   程序如下：让它记录下我对它的理解吧！

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

                }
            }
        }
    }