Difference between ADO.net Dataset , ADO Record Set & ADO Data Reader?
Answer Posted / lovenier
We use DataSet to retrieve data from database in disconnected mode, but in the data RecordSet it retrieve data in connected mode..
DataSet is designed to work without any continuing connection to the orignal database, but RecordSet is Required a connected environment.
Data in DataSet is bulk loaded, rather than being loaded on demand.
DataSet have no concept of Cursor and current pointer, you can use for each loops to move through data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the most appropriate lifetime for a database connection/orm context in an asp.net mvc application? : Asp.Net MVC
What is the Intermittent crashing of application in production?
Explain the main function of url routing system in asp.net mvc? : asp.net mvc
Who is using asp.net?
Differences between “dataset” and “datareader”.
What is the difference between page.registerclientscriptblock and page.registerstartupscript?
What is query string? What are its advantages and limitations?
What are url fragments?
What does a switch do?
How may clustered index we can create in table?
while developing webservices if i want some users to use my webservice only how can i give security to my webservice?
Where you store Connection string in "Web.Config" file in ASP.NET?
Explain the Session state management options available with ASP.NET?
Can you change a Master Page dynamically at runtime?
How do I use a proxy server when invoking a web service?