In this blog i'l explain the basic difference between the use of ExecuteScalar and ExecuteNonQuery methods of ADO.NET