/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

1 vote226 views1 answer
Mvc 5 dropdownlist
C#
0 vote220 views1 answer
What is napalm made of
C#
0 vote215 views1 answer
How to know pm or am C#
C#
3 votes234 views2 answers
Unity pause coroutine
C#
0 vote222 views1 answer
Propertychanged is not firing up when text is change
C#
0 vote248 views1 answer
Unity draw ray from one object to another
C#Unity
0 vote187 views1 answer
Unity scene load
C#
1 vote253 views2 answers
Modify middleware response c# .net
C#
-1 vote228 views1 answer
How to create a random vector2 in unity
C#
0 vote235 views1 answer
Devexpress aspxdatagridview set VerticalScrollableHeight in codebehind
C#