/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

5 votes122 views2 answers
Read xml file c#
C#
0 vote110 views1 answer
How to get the hour on c#
C#
1 vote155 views1 answer
Unity find closest point on line
C#Unity
0 vote116 views1 answer
My context class is in different project and i want migration in different project in asp.net mvc
C#
1 vote121 views1 answer
Revitapi
C#
0 vote116 views2 answers
Declare prop array c#
C#
0 vote146 views1 answer
Unity Interstitial ad C#
C#Unity
0 vote130 views1 answer
C# dictionary with dictionary as value
C#
5 votes115 views2 answers
How to check if key is held in unity
C#
3 votes121 views1 answer
Stop sound in unity
C#