/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

10 votes218 views3 answers
Switch case in c# with multiple values
C#
0 vote241 views1 answer
How to set the value of a textbox textmode=date asp.net c#
C#
0 vote218 views1 answer
Check shell command success
C#
0 vote241 views2 answers
Vb.net substring after character
C#
0 vote224 views1 answer
List to array f#
C#
0 vote220 views1 answer
C# exec command output
C#
0 vote216 views1 answer
Allelrt box wpf
C#
1 vote242 views1 answer
Renaming table name entity framework code first fluent api
C#
1 vote227 views1 answer
Http error 502.5 asp.net core 2.2
C#
0 vote228 views2 answers
ViewBag as a list
C#