1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

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

Question Posted / ganesh

Answers were Sorted based on User's Feedback



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

Answer / ganesh

Valid answers are:
· 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 ?    1 Yes 0 No

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

Answer / siddarth

dataset is nothing but in memory database for client
application.
Dataset supports bidirectional navigation and it supports
purely disconnected architecture with xml integration.
it supports plat form independency.
The above are all not supported by recordset.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

In which scenario we use Session and Cookies? With Example..

1 Answers  

is it possible to use web site without web server from remote place?

1 Answers   ABC, Mannar Company, Quadrant,

What is the lifespan for items stored in ViewState?

4 Answers   Siebel Systems,

Best Institute in india for online training (Dotnet/java/Tibco/Dwh/etc.....)

4 Answers  

How to automatically get the latest version of all the asp.net solution items from source safe when opening the solution?

0 Answers  




What do you mean by caching in asp.net?

0 Answers  

Is it possible to perform data validations in the database?

1 Answers   Quest,

How to handle errors in Web API?

0 Answers  

What is a global postback url?

0 Answers  

Can we use the java script code in .Net Code behind?

5 Answers   eXensys,

If Asp Dot Application is stateless what happened? during designing

3 Answers   TCS,

Which property needs to be set for script manager control to extend the time before throwing time out expection if no response is received from the server?

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories