/C#/Difference between executescalar and executenonquery and executereader

Difference between executescalar and executenonquery and executereader

ExecuteScalar() only returns the value from the first column of the first row of your query.
ExecuteReader() returns an object that can iterate over the entire result set.
ExecuteNonQuery() does not return data at all: only the number of rows affected by an insert, update, or delete

Similar codes

3 votes359 views1 answer
How to locate a specific element in a list c#
C#
-1 vote337 views1 answer
How to dynamically load value in startup file in c#
C#
18 votes311 views2 answers
Unity remove all child
C#
0 vote325 views1 answer
Rigidbody.addforce not working
C#
1 vote348 views1 answer
How to store an array inside an array c#
C#
3 votes371 views1 answer
How to load the active scene unity
C#Unity
4 votes374 views1 answer
Gameobject in unity c#
C#Unity
0 vote342 views1 answer
Asp net core send email async
C#
0 vote320 views1 answer
Options Pattern how to use
C#
0 vote300 views1 answer
Battle.net
C#