ExecuteRedear vs ExecuteScalar

•

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 426,363 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,459 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.

Join our community!

Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting

ExecuteRedear vs ExecuteScalar

•

Join Date: Mar 2006

Posts: 11

Reputation: rajni11 is an unknown quantity at this point

Rep Power: 3

Solved Threads: 0

rajni11

Offline

Newbie Poster

ExecuteRedear vs ExecuteScalar

May 8th, 2006

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