Execute nonquery to insert a record (row) : SqlCommand Insert : ADO.Net C# Examples

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

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

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

            string  sqlins  =  @"insert  into  employee  (firstname,lastname)values('Z',  'Z')";

            string  sqldel  =  @"delete  from  employee  where  firstname  =  'Z'  and  lastname  =  'Z'";

            SqlCommand  cmdqry  =  new  SqlCommand(sqlqry,  conn);
            SqlCommand  cmdnon  =  new  SqlCommand(sqlins,  conn);

            try
            {
                  conn.Open();

                  Console.WriteLine("Before  INSERT:  Number  of  employee  {0}\n",  cmdqry.ExecuteScalar());

                  Console.WriteLine("Executing  statement  {0}",  cmdnon.CommandText);
                  cmdnon.ExecuteNonQuery();
                  Console.WriteLine("After  INSERT:  Number  of  employee  {0}\n",  cmdqry.ExecuteScalar());

                  cmdnon.CommandText  =  sqldel;
                  Console.WriteLine("Executing  statement  {0}",  cmdnon.CommandText);
                  cmdnon.ExecuteNonQuery();
                  Console.WriteLine("After  DELETE:  Number  of  employee  {0}\n",  cmdqry.ExecuteScalar());
            }
            catch  (SqlException  ex)
            {
                  Console.WriteLine(ex.ToString());
            }
            finally
            {
                  conn.Close();
                  Console.WriteLine("Connection  Closed.");
            }
      }
}