using System;
using System.Collections.Generic;
using System.Data; // Use ADO.NET namespace
using System.Data.SqlClient; // Use SQL Server data provider namespace 
using System.Linq;
using System.Text;

namespace DataSet_Demo
{
    class Program
    {
        static void Main(string[] args)
        {
            //1: Specify SQL Server connection string
          SqlConnection con = new SqlConnection(@"Data  Source =.\SQLEXPRESS;"+@"AttachDbFilename=’C:\SQL Server 2000 Sample   Databases\NORTHWIND.MDF’;" +@"Integrated Security=True;Connect Timeout=30;User Instance=true" );
          //2: Create DataAdapter object
          SqlDataAdapter da = new SqlDataAdapter("SELECT CustomerID, ContactName FROM  Customers", con);
          //3: Create DataSet object to contain  data tables, rows, and columns
          DataSet ds = new DataSet();
         //4: Fill DataSet using query defined for DataAdapter
         da.Fill(ds, "Customers Details");
         //5:Access data row wise using foreach loop
         foreach (DataRow dr in ds.Tables["Customers"].Rows)
         {
          Console.WriteLine(dr["CustomerID"] + "\t" +dr["ContactName"]);
         }
         //Closing the connection
         con.Close();
         Console.Write("Program finished, press Enter/Return to continue:");
         Console.ReadLine();
        }
    }
}