/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 vote183 views1 answer
How to make an object jump in unity
C#Unity
2 votes140 views1 answer
C# get certain character from string
C#
0 vote134 views1 answer
How to make character respawn if touches sprite c#
C#
0 vote154 views1 answer
System.Collections.Generic.List`1[System.Int32] c# fix
C#
1 vote137 views1 answer
Csharp check if env is development
C#
18 votes175 views1 answer
Unity delete all children
C#Unity
0 vote135 views1 answer
C# button click gets assigned the last value
C#
0 vote123 views3 answers
Finding holydays asp.net
C#
0 vote130 views2 answers
Stringify c#
C#
0 vote122 views1 answer
C# iorderedenumerable to dictionary
C#