If i am expecting a single result from sqlserverdatabase
then what command should i follow ?sqlcommand.executereader
(commandbehaviour.singleresult)or sqlcommand.executescalar()
- 4 Answers
- 7097 Views
- I also Faced
- E-Mail Answers
Answer Posted / vinay
Both of these are same commandbehaviour.singleresult also
give you a single result. but we should use
sqlcommand.executescalar()
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
Explain the advantage of ADO.Net?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
List the 4 common ado.net namespaces?
What are the rules to implement connection pooling?
What are the parameters that control most of connection pooling behaviours?
What do you mean by performing asynchronous operation using command object?
What are the benefits of using of ADO.NET in .NET 4.0?
Define isolation?
What are the classes in System.Data.Common Namespace?
What are the advantages and drawbacks of using ado.net?
Define the executescalar method?
Which object is used to add relationship between two Datatables?
Define connection string?
What is the difference between data grid and data repeater?
