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

What is CMMI? This is a collection of instructions an organization can follow with the purpose to gain the better control over its software development process. According to

How can we get the state of the requested process? XMLHttpRequest get the current state of the request operation by using the readyState property. This property checks the cond

What is Object Relational Designer? The 0/R Designer provides a visual design surface to make LINQ to SQL entity classes and associations (relationships) that are based on obje

im retrieving the path of image from the database i want to get the image in that path to be displayed in my datagridviewvolumn

WP7 get data from public API with XML or JSON Project Description: Hello, I'm seeking someone who knows his way around using an API with XML or JSON output in a windows phone

As you have probably realized by now, Web pages are much more useful when they are dynamic. In Internet terminology, the word dynamic means several things. Primarily, it refers to

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

What is Cache Callback? The Cache object is dependent on its dependencies for example time based, file based, etc...The Cache items remove the object when cache dependencies ch

What is a static constructor? Static constructors are introduced with C# to initialize the static data of a class. CLR calls the static constructor before the initial instance