Can you explain the difference between an ADO.NET Dataset
and an ADO Recordset?

Answer Posted / ramgopal reddy

? A DataSet can represent an entire relational database in
memory, complete with tables, relations, and views.
? A DataSet is designed to work without any continuing
connection to the original data source.
? Data in a DataSet is bulk-loaded, rather than being loaded
on demand.
? There's no concept of cursor types in a DataSet.
? DataSets have no current record pointer You can use For
Each loops to move through the data.
? You can store many edits in a DataSet, and write them to
the original data source in a single operation.
? Though the DataSet is universal, other objects in ADO.NET
come in different versions for different data sources.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference in .net 1.1 and .net 2.0?

592


What are ASP.NET Web Forms? How is this technology different than what is available though ASP?

945


What is syntax code to send email from an asp.net application?

536


Can you use Web API with ASP.NET Web Form?

698


How do you do client-side validation in .net? How to disable validator control by client side javascript?

538






What is __ requestverificationtoken?

555


What r the asp.net list controls and difference between them?

508


Name the two properties are on every validation control?

547


Why do we use sessions?

581


What are server side controls?

537


What are the layouts of ASP.NET Pages?

621


Where is the session stored?

639


What is another word for redirect?

514


Can a master page have more than one contentplaceholder?

512


Explain the use of resource manager class in .net.

508