SqlTransaction tran = null;
            try
            {
                string connectionString = ConfigurationManager.ConnectionStrings["connctionString"].ConnectionString;
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();
                     tran = conn.BeginTransaction();
                    using (SqlCommand cmd = conn.CreateCommand())
                    {
                        cmd.Transaction = tran;
                        cmd.CommandText = "insert into A values(@AName);select @@Identity";
                        cmd.Parameters.Add("@AName", "testName");
                        int id = Convert.ToInt32(cmd.ExecuteScalar());
                        cmd.CommandText = "insert into B values(@BName,@AID)";
                        cmd.Parameters.Add("@BName", "testName");
                        cmd.Parameters.Add("@AID", id);
                        cmd.ExecuteNonQuery();
                        MessageBox.Show("插入成功");
                    }
                    tran.Commit();
                }
            }
            catch (Exception ex)
            {
                tran.Rollback();
                throw;
            }