operation database in the transaction object

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace dbtest
{
    class Program
    {
        static void Main(string[] args)
        {
            string ConnectionString = "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI;";
            SqlConnection sc = new SqlConnection(ConnectionString);
            sc.Open();
            SqlTransaction transaction = sc.BeginTransaction();
            SqlCommand commmand = new SqlCommand();
            commmand.Connection = sc;
            commmand.Transaction = transaction;
          
                commmand.CommandText = "update customers  set CompanyName='Alfreds Futterkist' where"+ "CustomerID='alfki'";
                commmand.ExecuteNonQuery();
                commmand.CommandText = "select * from customers where CustomerID='alfki'";
                SqlDataReader reader = commmand.ExecuteReader();

                 while(reader.Read())
                {
                    for (int i = 0; i < reader.FieldCount; i++)
                    {
                    
                        Console.WriteLine(reader[i]);
                 
                    }
                  
                }
           
        
                //transaction.Commit();
            
        
           
       

 

        }
    }
}