What is the difference between ExecuteReader,ExecuteNonQuery
and ExecuteScalar.
Answer Posted / ashish kumar gupta
Execute Reader: Use for accessing data. It provides a
forward-only, read-only (Select), connected record set.
Execute Non Reader: Use for data manipulation, such as
Insert, Update, and Delete.
Execute Scalar: Use for Retrieving 1 row 1 col. Value. I.e.
single value. E.g. for retrieving aggregate function. It is
faster than other ways of retrieving a single value from
database.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is the concept of postback in asp.net?
How can we pass info between 2 asp.net pages?
What does it mean your session has timed out?
Define globalization and localization.
What is AutoEventWireup attribute for ?
What do you understand from custom control?
Explain About duration in caching technique
How does session authentication work?
We Only Know The Total Number Of Feet In The Farmyard. Write A Program that will compute the total number of rabbits and chickens in the farmyard. Assume number of feet in the farmyard are 40. how many rabbits and chickens are?
Explain login control and form authentication.
Explain the difference between AutoPostBack and IspostBack in ASP.NET?
What is another word for redirect?
What is the difference between typeof() vs gettype()?
Why session is necessary in web application?
Who is using asp.net?