What is the difference between ExecuteReader,ExecuteNonQuery
and ExecuteScalar.
Answer Posted / jerry joseph
ExecuteReader - This method returns a DataReader which is
filled with the data that is retrieved using the command
object.
ExecuteNonQuery - This method returns no data at all. It is
used majorly with Inserts and Updates of tables.
ExecuteScalar - Returns only one value after execution of
the query. It returns the first field in the first row.
This would be excellent for receiving a count of records
(Select Count(*)) in an sql statement, or for any query
where only one specific field in one column is required.
| Is This Answer Correct ? | 35 Yes | 9 No |
Post New Answer View All Answers
What I need to create and run an asp.net application?
How many types of state management are there in asp net?
What is postback request?
How many types of sessions in asp.net?
Explain the difference between globalization and localization techniques
What is the used of "ispostback" property?
What is repository pattern in mvc.net? : asp.net mvc
Explain method to handle error using HttpError in Web API?
What is variable and constant in .net programming language?
How do I know asp.net mvc version? : Asp.Net MVC
Difference between application events and session events
Explain what is an abstract class?
Define what is razor? : asp.net mvc
Explain exception handling in .net.
Can a master page have more than one contentplaceholder?