SQL datareader

gistfile1.cs

using(var conn = new SqlConnection("server=.;initial catalog=minDatabase;integrated security=sspi"))
{
    conn.Open();

    using(var cmd = conn.CreateCommand())
    {
        cmd.CommandText = "select something from whatever";

        using(var reader = cmd.ExecuteReader())
        {
            while(reader.Read())
            {
                var myInt = (int)reader["something"];
                // do the funky shit ;)
            }
        }
    }
}