Series: Subject: Topic:
Question: 46 of 58

What is main difference between ADO and ADO.Net

Asked by: Interview Candidate | Asked on: Nov 21st, 2005
Showing Answers 1 - 20 of 20 Answers

Ado is connected mode and is disconnected mode

Login to rate this answer.

Answered On : Dec 21st, 2005

Please tell me the diff b/w recordset and datagrid

Login to rate this answer.
Suvesh Sonker

Answered On : Dec 30th, 2005

Yes  2 Users have rated as useful.
Login to rate this answer.

Answered On : Feb 8th, 2006

View all answers by Shree

There is one more point I would like to add:In, 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.

Login to rate this answer.

Answered On : Jul 22nd, 2006

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

Login to rate this answer.

Answered On : 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.

Yes  1 User has rated as useful.
Login to rate this answer.

Answered On : Sep 5th, 2006

1. is a disconnected  architecture   Ado is not support to disconnected architecture2. 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

Login to rate this answer.

Answered On : Dec 21st, 2006

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

Login to rate this answer.
Praveen Gorantla

Answered On : Mar 14th, 2007

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

Login to rate this answer.

Answered On : 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....???

Login to rate this answer.

Answered On : May 28th, 2007

As you know that is disconnected case you want to update the data in database frequently in this case it is better to use ado 

Login to rate this answer.

Answered On : Jun 28th, 2007

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

Login to rate this answer.

Answered On : Mar 6th, 2009

View all answers by mageshthomas

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

Login to rate this answer.

Answered On : May 12th, 2011

View all answers by sayoojt

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

Login to rate this answer.
Lokesh garg

Answered On : 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

Login to rate this answer.
Sanjay Raizada

Answered On : Oct 14th, 2011

ADO- Connection-Oriented Architecture
Use Record Set
Communicate in Binary mode Dis-connected architecture
Use DataSet,Adapter
Parse Data in XML mode
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.

Login to rate this answer.

Answered On : Oct 18th, 2011

Ado: connected mode Disconected Mode

Login to rate this answer.

Answered On : 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.?

Login to rate this answer.

Answered On : 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 provide Data binding link between Data source controls.

Login to rate this answer.
ponraman m

Answered On : May 5th, 2012

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

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

Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.