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 |
What is the Difference B/W Finalize() and Dispose() in .Net?
12 Answers HCL, IBM,
how we declare interface
What is the difference between client-side and server-side validations in ASP.NET?
0 Answers Sans Pareil IT Services,
web farm .. how does session shuld be stored... if inproc used? does the session persists from one server to other.
How can I open ashx file in mobile?
What are Http handler ?
How do you relate an aspx page with its code behind page ?
4 Answers Accenture, BirlaSoft,
I M working in 1.1 .net framework. In a page I have 5 text box & 2 data grid. In PageLoad() All text box will populate with blank value & 1st dataGrid with some value. When I click on EDIT button Of the 1st dataGrid,The Relevent data Of the particular row will populate in first 3 textboxs & corresponding relevent data Will populate in the 2nd DataGrid. Now when I click 2nd datagrid's EDIT button of a perticular Row,relevent data will populate on last 2 textboxs & 1st 3 textbox's value will be same as per as it was........ ........My Problem Is ........... When I click on edit button Of 2nd DataGrid, 1st 3 text boxes values goes Off & 2nd DataGrid Is goes off Due to Postback.but The relevent value is populated In last 2 textboxes.So How I stoped this postback??So that all the data in 1st 3 textboxes will be same.So that I can edit the values of 2nd Grid with 1st 3 textBoxes value.. plz dirctly mail me 1 copy of post to... maloy.adhikari@in.com
What is the size of Get method and how much data it can store?
What are demand-paging and pre-paging?
what is page life cycle state management postback cross page postback types of feilds in gridview gridview events their life cycle cte in sql diff truncate and delete paging concepts in gridview diff bet gridview datalist and repeater what new operations in sql 2005 compared to earlier you get
WHAT IS THE SEQUENCE IN WHICH ASP.NET EVENTS IS PROCEED?
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)