•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 360,995 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,426 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 5993 | Replies: 2
 |
•
•
Join Date: Mar 2006
Posts: 11
Reputation: 
Rep Power: 3
Solved Threads: 0
Newbie Poster
I am having confusion in ExecuteScalar & ExecuteReader
If we use ExecuteReader for select with aggregate function, it will not give any error and run successfully so if we can do both queries select with aggregate & select with non aggregate with the help of only one method ExecuteReader so why is there ExecuteScalar………, is there any other benefit of it?
Please give the proper answer
If we use ExecuteReader for select with aggregate function, it will not give any error and run successfully so if we can do both queries select with aggregate & select with non aggregate with the help of only one method ExecuteReader so why is there ExecuteScalar………, is there any other benefit of it?
Please give the proper answer
•
•
Join Date: Dec 2004
Posts: 1,589
Reputation:
Rep Power: 7
Solved Threads: 34
The main difference is the "footprint" of the return value. ExecuteReader always returns an object, for example, a SqlDataReader. Then, to get the actual results, you have to do a Read(), then get the value.
ExecuteScalar immediately returns the actual value.
So, in terms of retrieving Scalar data from a database, ExecuteScalar is more efficient.
ExecuteScalar immediately returns the actual value.
So, in terms of retrieving Scalar data from a database, ExecuteScalar is more efficient.
•
•
Join Date: Mar 2006
Posts: 11
Reputation:
Rep Power: 3
Solved Threads: 0
Newbie Poster
Thanx......
•
•
•
•
Originally Posted by tgreer
The main difference is the "footprint" of the return value. ExecuteReader always returns an object, for example, a SqlDataReader. Then, to get the actual results, you have to do a Read(), then get the value.
ExecuteScalar immediately returns the actual value.
So, in terms of retrieving Scalar data from a database, ExecuteScalar is more efficient.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb ASP.NET Marketplace
Linear Mode
- Error Retrieving Single Data Using ExecuteScalar Method (VB.NET)
- retrieving ids from dynamically created controls in asp.net (ASP)
- problem with connection to sql server (ASP.NET)
- Compilation Error Handles cmdLogin.ServerClick (ASP.NET)
- Simple ASP.Net Login Page (Using VB.Net) (ASP.NET)
- help newbie alert needs help with login page (ASP.NET)
- Sql Query (VB.NET)
Other Threads in the ASP.NET Forum
- Previous Thread: Beginner: Insert, Update, Delete & Search records from/to sql database
- Next Thread: role of web.config file in MVC
