Can you explain the difference between an ADO.NET Dataset
and an ADO Recordset?

Answer Posted / thangaraj.r

. ADO used connected data usage, while ADO.net used
disconnected data environment.
2. ADO used OLE DB to access data and is COM-based, while
ADO.net uses XML as the format for transmitting data to and
from your database and web application.
3. In ADO, Record set, is like a single table or query
result, while in ADO.net Dataset, can contain multiple
tables from any data source.
4. In ADO, it is sometime problematic because firewall
prohibits many types of request, while in ADO.net there is
no such problem because XML is completely firewall-proof.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the disadvantages of asp.net?

779


What is the difference between asp.net and mvc?

791


Explain difference betn dataset and recordset?

682


Define a static class?

709


How do I create a web form?

705


What is a web server? What are the load limits in it?

780


Explain about Application and Session Events ?

809


What is the application pool?

712


How do you do Client-side validation in .Net?

803


What is the benefit of WebAPI over WCF?

746


What is the question mark in a url?

695


What is meant by web application?

709


What is the namespace to create thread in .net?

699


How can we pass info between 2 asp.net pages?

754


If there are multiple update panels on the page say upd1 and upd2. There is a button placed in upd1. How can you stop upd2 to update when button placed in upd1 is clicked?

762