SqlCommand : SqlCommand : ADO.Net C# Examples

SqlCommand

    
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;";
        SqlConnection  conn  =  new  SqlConnection(  cstr  );

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

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

        rdr.Close();
    }
}
    
   
  
   

Related in same category :
• Create a SqlCommand
• Create SqlCommand with both sql query and connection
• Execute two sql commands
• Asynchronous Processing Sql command
• SqlCommand with Callback Handler
• Add parameters to the SqlCommand
• SQL StoredProcedure