How to use SqlCommand in a Transaction

In this snippet:
- How to use SqlCommand in a Transaction
- How to use the Parameters.Add method
- How to use the BeginTransaction method
- How to execute an SQL-statement using the ExecuteNonQuery method


C#
public static SqlConnection Connect()
{
SqlConnection con = new SqlConnection("..");
con.Open();
return con;
}

----
using (SqlConnection con = Connect())
foreach (DataRow dsRow in Class1.myDS.MasterAccounts.Rows)
{
using (SqlTransaction tran = con.BeginTransaction() )
{
//Part of the transaction
SqlCommand cmd1 = new SqlCommand( "DELETE FROM MyTable WHERE ID = @ID;",con,tran);
cmd1.Parameters.Add("@ID", SqlDbType.Int, 4).Value =
Convert.ToInt32(dsRow["ID"]);

//Part of the transaction
SqlCommand cmd2 = new SqlCommand( "DELETE FROM tblMain WHERE ID = @ID;",con,tran);
cmd2.Parameters.Add("@ID", SqlDbType.Int, 4).Value =
Convert.ToInt32(dsRow["ID"]);

cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();

//Commit the transaction
tran.Commit();
iCount ++;
}
}