ado and .net

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

class ADO_basic {
  [STAThread]
  static void Main(string[] args) {

    SqlConnection conn = new SqlConnection("user id=aaa;password=bbb;initial catalog=northwind;data source=laptop");
    conn.Open();
    SqlDataAdapter adapt = new SqlDataAdapter("Select firstname,lastname from employees", conn);

    DataSet dataSet = new DataSet();
    adapt.Fill(dataSet,"MeinResultat");

    conn.Close();

    DataTable tab = dataSet.Tables["MeinResultat"];

    foreach (DataRow row in tab.Rows) {
      Console.WriteLine("{0} {1}",row[0],row[1]);
    }
  }
}