what is the return type of executescalar and executenonquery and executereader in asp.net

Question

0.00/5 (No votes)

See more:

ADO.NET

Can you tell me the return types for execute scalar and execute reader and execute non query

Posted 26-Jun-12 18:16pm

skpraveenkumar

Add a Solution

Comments

Member 11443915 25-Feb-15 0:17am

what use public class in asp.net mvc

2 solutions

Solution 3

ExecuteNonQuery(): will work with Action Queries only (Create,Alter,Drop,Insert,Update,Delete).

Returns the count of rows effected by the Query.
Return type is int
Return value is optional and can be assigned to an integer variable.

ExecuteReader(): will work with Action and Non-Action Queries (Select) Returns the collection of rows selected by the Query.

Return type is DataReader.
Return value is compulsory and should be assigned to an another object DataReader.

ExecuteScalar(): will work with Non-Action Queries that contain aggregate functions.

Return the first row and first column value of the query result.
Return type is object.
Return value is compulsory and should be assigned to a variable of required type

Posted 3-Mar-13 0:24am

Mukesh Bhagat

Comments

Member 11443915 25-Feb-15 0:16am

what use public class in asp.net mvc

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad_Kulkarni · Accepted Answer · 2012-06-26T18:23:00

ExecuteNonQuery: Use this operation to execute any arbitrary SQL statements in SQL Server if you do not want any result set to be returned.

You can use this operation to create database objects or change data in a database by executing UPDATE, INSERT, or DELETE statements. The return value of this operation is of Int32 data type, and:
For the UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the SQL statement.

For all other types of statements, the return value is -1.

ExecuteReader: Use this operation to execute any arbitrary SQL statements in SQL Server if you want the result set to be returned, if any, as an array of DataSet.
For information about DataSet, see “DataSet Class” at http://go.microsoft.com/fwlink/?LinkId=119631.[^]
(e.g., SELECT col1, col2 from sometable).

ExecuteScalar: Use this operation to execute any arbitrary SQL statements in SQL Server to return a single value.
This operation returns the value only in the first column of the first row in the result set returned by the SQL statement.
An example might be SELECT @@IDENTITY AS 'Identity'.

Refer similar thread:
What is the difference between Execute Scalar , Execute Reader and ExecuteNonQuery[^]
What is the difference between ExecuteNonQuery, ExecuteReader, and ExecuteScalar?[^]

MSDN:
http://msdn.microsoft.com/en-us/library/dd787963(v=bts.10).aspx[^]
http://msdn.microsoft.com/en-us/library/dd788418(v=bts.10).aspx[^]