SqlConnection con = new SqlConnection("DataSource=localhost;Integrated Security=SSPI;Initial Catalog=northwind");
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT CategoryID, CategoryName FROM Categories";
con.Open();
SqlDataReader read = catCMD.ExecuteReader();
while(read.Read())
{
Console.WriteLine("\t{0}\t{1}",read.GetInt32(0),read.GetString(1));
}
read.Close();
con.Close();
}