What is the difference between ExecuteScalar and ExecuteNonQuery?

.Net - Interview Questions

ExecuteScalar	ExecuteNonQuery
Returns the output value	Does not return any value
Used for fetching a single value	Used to execute insert and update statements
Does not return the number of affected rows	Returns the number of affected rows.

More Technologies Interview Questions