Create SqlCommand with both sql query and connection : SqlCommand : ADO.Net C# Examples

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

class  CommandScalar
{
      static  void  Main()
      {
            SqlConnection  conn  =  new  SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated  Security=SSPI;");

            string  sql  =  @"select  count(*)  from  employee";

            SqlCommand  cmd  =  new  SqlCommand(sql,  conn);
            Console.WriteLine("Command  created  and  connected.");

            try
            {
                  conn.Open();

                  Console.WriteLine("Number  of  Employees  is  {0}",  cmd.ExecuteScalar());
            }
            catch  (SqlException  ex)
            {
                  Console.WriteLine(ex.ToString());
            }
            finally
            {
                  conn.Close();
                  Console.WriteLine("Connection  Closed.");
            }
      }
}