Difference between an ado.net dataset and an ado recordset, DOT NET Programming

Explain the difference between an ADO.NET Dataset and an ADO Recordset.

The two main basic differences between recordset and dataset are as shown below :-

1) With the dataset you can retrieve data from two databases such as oracle and sql server and combine them in one dataset , with the recordset this is not possible

2) All the representation of Dataset is by using XML while the recordset uses COM.

3) The Recordset  cannot be transmitted on the HTTP while Dataset can be.

Posted Date: 9/24/2012 5:07:17 AM | Location : United States







Related Discussions:- Difference between an ado.net dataset and an ado recordset, Assignment Help, Ask Question on Difference between an ado.net dataset and an ado recordset, Get Answer, Expert's Help, Difference between an ado.net dataset and an ado recordset Discussions

Write discussion on Difference between an ado.net dataset and an ado recordset
Your posts are moderated
Related Questions
How do I force the Dispose method to be called automatically, as clients can forget to call Dispose method? To Call the Dispose method in the Finalize method and in the Dispose

Project Description: Legacy ASP.NET application for managing tasks for a private client needs a complete re-write. The application has approximately 2500 lines of code, combi

I need asp.net print page task Project Description: I have a little task on asp.net, I need to print a text data to receipt printer from web page, I used the subsequent code

What is ViewState? The Viewstate is built-in structure for automatically retaining the values among the multiple requests for the similar page. The viewstate is internally main

I need Desktop App for website Project Description: We own a big website. Basically we want a desktop app or mobile app for our website. So people download and have our websi

Are you available to discuss about my project. I'd like you to show first and then accept the project provided if we both agree to continue with each other. Skills required:

Explain collation sequence in sql server. The Collation sequences are the set of rules which determine how the data is sorted and compared. The Sorting rules can be defined wit

How can we use Culture Auto in project? We will make a very simple login screen which we will try to use for English as well as the Greek. The login screen will display Engl

Create a Calculator application using Web Form with the following functions: 1.  Add 2.  Minus 3.  Multiply 4.  Divide Each of the above has to be a Web Service

How can you add or remove rows from the DataTable object of DataSet? The DataRowCollection class explains the collection of rows for the DataTable object in a DataSet. The Data