Simple Query : SqlCommand Select « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. SqlCommand Select

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

class MainClass
{
  [STAThread]
  static void Main(string[] args)
  {
    string cstr = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;";
    using ( SqlConnection conn = new SqlConnection( cstr ) )
    {
      conn.Open();

      SqlCommand cmd = new SqlCommand( "select * from Employee", conn );
      SqlDataReader rdr = cmd.ExecuteReader();

      while ( rdr.Read() )
      {
        System.Console.WriteLine( "{0}", rdr.GetString( 1 ) );
      }
      rdr.Close();
    }
  }
}