Simple Query : SqlCommand Select : 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)
    {
        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();
        }
    }
}