ExecuteScalar:-It will returns the output value
ExecuteNonQuery:-It will not return any value
ExecuteScalar:-It is used for fetching a single value
ExecuteNonQuery:-It is used to execute insert and update statements
ExecuteScalar:-It does not return the number of affected rows
ExecuteNonQuery:-It will Returns the number of affected rows.