which one is faster execute reader, scalar, execute non
query ?
- 18 Answers
- 32803 Views
- Intiger, Minecode, I also Faced
- E-Mail Answers
Answer Posted / monalika
Execute Reader is faster it
internally stores result of a query as an array.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between the response.write() and response.output.write() methods?
Why is string called immutable data type?
Hello, Using Visual Studio 2005 (VB) I am working to create a Web Site implementing the following: Within a gridView I have placed a dropdownlist control with a DataSourceID="SDSLkupList". SDSLkupList is a sqlDataSource used to store a lookup list for dropdownlist translation from ID to text. SDSLkupList contains the translation text and other fields related to the dropdown selection ID. (Thought it would be efficient to get everything at the same time.) I would like to provide the user the ability to select from the dropdownlist and, based on the selection, use labels to list related columns stored on the SDSLkupList in separate gridView columns. I have read that SqlDataSources are not meant to be used for individual controls. Since SDSLkupList contains all related information, is there a way to do a find using the dropdownlist selectedValue? (I was not able to discover one.) Otherwise, what should I use? It would need to set the labels on the gridView DataRowBound event as well as the SelectedIndexChanged events. Has anyone done this? Any help would be appreciated. Thanks in Advance. Neal
What is the significance of finalize method in .net?
What is server side in asp.net?
What is master page in dtp?
Can we have multiple worker process in an ASP.NET application? If so then how it has been handled by application? And who handles it?
What is runat?
What are different types of api?
Why do I get error message "could not load type" whenever I browse to my asp.net web site?
How to improve performance of web application asp.net mvc? : Asp.Net MVC
Describe paging in asp.net?
How can we secure the data which is send from client side to server? Like the login id and paasword needs to be authenticated on the server but we cannot send it in plain text into the server.One more thing we are not using the SSL here.
Can we make activex dll also ti execute in some process as that of client ? How can we do?
Is redux flux?
