Using Data Readers - Beginning C# 2008 Databases: From Novice to Professional - page 236

namespace Chapter12
{
class DataLooper
{
static void Main(string[] args)
{
// connection string
string connString = @"
server = .\sqlexpress;
integrated security = true;
database = northwind
";
// query
string sql = @"
select
contactname
from
customers
";
// create connection
SqlConnection conn = new SqlConnection(connString);
try
{
// open connection
conn.Open();
// create command
SqlCommand cmd = new SqlCommand(sql, conn);
// create data reader
SqlDataReader rdr = cmd.ExecuteReader();
// loop through result set
while (rdr.Read())
{
// print one row at a time
Console.WriteLine("{0}", rdr[0]);
}