Simple Query Dataset : DataSet : ADO.Net C# Examples

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

class  MainClass
{
    [STAThread]
    static  void  Main(string[]  args)
    {
        DataSet  dset  =  new  DataSet();

        string  cstr  =  "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated  Security=SSPI;";
        using  (  SqlConnection  conn  =  new  SqlConnection(  cstr  )  )
        {
            conn.Open();

            SqlDataAdapter  da  =  new  SqlDataAdapter(  "select  *  from  Employee",  conn  );
            da.Fill(  dset,  "Employee"  );
        }

        foreach(  DataRow  dr  in  dset.Tables[  "Employee"  ].Rows  )
        {
            System.Console.WriteLine(  "{0}",  dr[  "firstName"  ]  );
        }
    }
}