SqlConnection conn = new SqlConnection("Data Source=.;Integrated Security=true; Initial Catalog=pubs");
SqlCommand comm = new SqlCommand("select au_id from authors", conn);
conn.Open();
comm.Transaction = conn.BeginTransaction(IsolationLevel.RepeatableRead);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
	MessageBox.Show (dr[0].ToString());
}
comm.Transaction.Commit();
conn.Close();