Simple Query Dataset : DataSet « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. DataSet

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" ] );
    }
  }
}