Interested to Buy Any Domain ? << Click Here >> for more details...
If i am expecting a single result from sqlserverdatabase
then what command should i follow ?sqlcommand.executereader
(commandbehaviour.singleresult)or sqlcommand.executescalar()
- 4 Answers
- 7752 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / m.mohan krishna
Sqlcommand.executescalar() is preffered.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
What are the different ado.net namespaces are available in .net?
Explain the difference between sqlcommand object and command behavior object?
What is the default Timeout for SqlCommand.CommandTimeout property?
Explain the basic use of "dataview" and explain its methods.
What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What is execute scalar in ado.net?
Difference between function and trigger?
What is the difference between ADO and ADO.Net?
What is ole data type?
What are the data access namespaces in .NET?
What are the key events of sqlconnection class?
What is sqlconnection and sqlcommand?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
