Can you explain the difference between an ADO.NET Dataset
and an ADO Recordset?
Answers were Sorted based on User's Feedback
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 |
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 |
Is sql backend or frontend?
Explain how cookies work. Give an example of cookie abuse.
Explain diff. Betn dataset and recordset?
Explain the difference between authentication and authorization.
How to disable validator control by client side JavaScript?
Why does a user need nothing more than a Web browser to view ASP.NET pages?
How can you register a custom server control to a web page?
What is tracing? Where is it used?
How do I force the dispose method to be called automatically, as clients can forget to call dispose method?
Tell About Global.asax ?
What is Pre-Render event in ASP.NET?
If you are using two select queries and retrieving data. how do you access second query's result set using data reader?
1 Answers Cap Gemini, Keane India Ltd, MindSquare,
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)