praveenkatragadda

 Profile Answers by praveenkatragadda 

• Dec 2nd, 2005

 

ado is connected mode and ado.net is disconnected mode

sachin

• Dec 21st, 2005

 

Please tell me the diff b/w recordset and datagrid

Suvesh Sonker

• Dec 30th, 2005

 

ADO and ADO.NET are different in several ways:

?         ADO works with connected data. This means that when you access data, such as viewing and updating data, it is real-time, with a connection being used all the time. This is barring, of course, you programming special routines to pull all your data into temporary tables.

ADO.NET uses data in a disconnected fashion. When you access data, ADO.NET makes a copy of the data using XML. ADO.NET only holds the connection open long enough to either pull down the data or to make any requested updates. This makes ADO.NET efficient to use for Web applications. It's also decent for desktop applications.

?         ADO has one main object that is used to reference data, called the Recordset object. This object basically gives you a single table view of your data, although you can join tables to create a new set of records. With ADO.NET, you have various objects that allow you to access data in various ways. The DataSet object will actually allow you to store the relational model of your database. This allows you to pull up customers and their orders, accessing/updating the data in each related table individually.

?         ADO allows you to create client-side cursors only, whereas ADO.NET gives you the choice of either using client-side or server-side cursors. In ADO.NET, classes actually handle the work of cursors. This allows the developer to decide which is best. For Internet development, this is crucial in creating efficient applications.

?         Whereas ADO allows you to persist records in XML format, ADO.NET allows you to manipulate your data using XML as the primary means. This is nice when you are working with other business applications and also helps when you are working with firewalls because data is passed as HTML and XML.

Shree

 Profile Answers by Shree 

• Feb 8th, 2006

 

There is one more point I would like to add:In Ado.net, Data Binding (linking data source to data consumer) is possible with the help of DataGrids and DataLists.This makes organizing and displaying data faster and more efficient.

somesh

• Jul 22nd, 2006

 

ADO's are stateful(TCP/IP),  ADO.NET's are stateless(internet)

meezan

• Sep 2nd, 2006

 

Recordset contains result of a database query, It is not used to display the data from the database. We use recordset in ADO technology.

Datagrid is used to only display data from database not to contain data.

Murugan

• Sep 5th, 2006

 

1. Ado.net is a disconnected  architecture

   Ado is not support to disconnected architecture

2. ADO allows you to create client-side cursors only, whereas ADO.NET gives you the choice of  either using client-side or server-side cursors.

3. Whereas ADO allows you to persist records in XML format, ADO.NET allows you to manipulate  your data using XML as the primary means

vikram,dhaval,saurabh

• Dec 21st, 2006

 

ADO works with connected Architechture and ADO.net works with Both Connected as well as disconnected.Ado.Net navigate data with XML. ADO Not nevigate.

Praveen Gorantla

• Mar 14th, 2007

 

Table lockings is Possible in ADO and Table Lockings is not Possible in ADO.Net

galaxy

• Mar 31st, 2007

 

I need a clarrification. If ADO.NET is disconnected, ie., if data from database is moved to DATASET using DATAADAPTER's FILL method, if any other user /  from some other apps data updated to the same table, how do the DATASET get the UPDATED data from database.

In simple, how to ADO.NET handles database concurrency....???

shefali

• May 28th, 2007

 

as you know that ado.net is disconnected mode.
in case you want to update the data in database frequently in this case it is better to use ado
 

SHANAKR

• Jun 28th, 2007

 

Record set maintains only one table from database where as dataset maintains more than one table

mageshthomas

 Profile Answers by mageshthomas 

• Mar 6th, 2009

 

ADO - Connected Architecture and ADO.Net - Disconnected Architecture.

sayoojt

 Profile Answers by sayoojt 

• May 12th, 2011

 

ADO.NET supports disconnected data model where ADO is not.

Lokesh garg

• Sep 25th, 2011

 

data adapter worked on the disconnected model.
when we work on the disconnected model we use data adapter to fetch the data from the database domain.
so when you fetch data with data adapter then updated data is fetched

Sanjay Raizada

• Oct 14th, 2011

 

1.
ADO- Connection-Oriented Architecture
Use Record Set
Communicate in Binary mode

Ado.net Dis-connected architecture
Use DataSet,Adapter
Parse Data in XML mode
2.
ADO was a connected data access model, which means that when
a connection to the database is made, the connection remains
open until the application is closed.

ADO.NET is disconnected database access model, which means
when an application interacts with the database, the
connection is opened to serve the request of the
application, and is closed as soon as the request is completed.

All data is presented in XML, as compared to ADO.

karvy

• Oct 18th, 2011

 

Ado: connected mode

Ado.net: Disconected Mode

Praveen

• Nov 19th, 2011

 

Am Satisfy your answer but i have one doubt,What is meaning of locking and where it is used in our applications.?

DEEPIKA

• Dec 7th, 2011

 

ADO use only OLEDB and it is COM based technology.ADO use tabel log and user log

ADO.NET is Built-in technology.it provide Data binding link between Data source controls.

ponraman m

• May 5th, 2012

 

classic asp is a connection mode. asp.net is disconnected mode and most efficient to work with web application

asp is using recordset in a single table and asp.net is using dataset in multiple table

Chaitanya

• Aug 23rd, 2017

 

ADO
Based on COM
Data is stored in binary format
Provides Recordset
Connection oriented
Cannot handle multiple transactions
Gives rows as a single table view
Scans rows sequentially
Creates client side cursor

ADO.NET
Based on CLR
XML Format
Provides Dataset and Adapter
Disconnected
Can handle multiple transactions
Gives rows as collections
Can go through a table
Create both client and server side cursor