Např. takto:
using (SqlCommand comm = new SqlCommand("select * from tabulka", con))
{
using (SqlDataReader reader = comm.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine(reader.GetValue(0));
}
}
}