/********************************************************
/   Description: usage of DataSet and DataAdpter (Fill method)    
/********************************************************
/
/1. From the File select New -> Project.
/2. Select template C# -> Console Application.
/3. Name project as DataSetExample
/4. Insert the following code.
/*******************************************************/

using System;
using System.Data;
using System.Data.SqlClient;

namespace DataSetExample
{
    class Start
    {
        static void Main(string[] args)
        {
        //DataAdapter instance:
        SqlDataAdapter dap = new SqlDataAdapter ("SELECT [ID], ProjectName FROM Projects", "Data Source=SERVER_NAME;Initial Catalog=DB_NAME;User Id=sa;Password=");

        //DataSet instance:
        DataSet dst = new DataSet ();
        //DataSet "filling":
        dap.Fill (dst, "Projects");
        //display Projects table rows
        foreach (DataRow row in dst.Tables["Projects"].Rows)
        {
            Console.WriteLine (row["ProjectName"]);
        }

        Console.ReadLine ();
        }
    }
}