| Difference between ExecuteScalar and ExecuteNonQuery
Below are the 3 main difference between ExecuteScalar and ExecuteNonQuery
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. | | |