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 difference between datalist and gridview?
What is the difference between repeater over datalist and datagrid ?
How can you execute stored procedure from windows application?
Explain the scenario where we go for inpro and outpro session?
How many types of state management are there in asp net?
if i have placed the button control with the OnClick event like <asp:Button ID="mybutton" runat="server" Text="Insert" onclick="mybutton_Click" /> and some other controls(buttons, textboxes) in .aspx page. When i run the page, the button displays in the page source of the browser like <input type="submit" name="mybutton" value="Insert" id="mybutton" /> here, it does not display the onclick event, then how the page calls the button click on the server side, how the server side identify which button cause the submit, and how this page moves to the server side.
What is the difference between Server.Transfer and Response.Redirect?
If i have 1000 records in dataset, how to do paging?
Differnce between Control an View State
Do you support digital rights management to protect my videos?
when user is logged on the information is saved in a cookie, what is the name of that cookie?
How do you handle server controls?
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)