ADO is used in windows based application and ADO.NET is used in web based application.
Posted by: vivek
ADO is mainly used for data Access and its an Connection Oriented.
where as ADO.Net is also used for Data Access and its an Connectionless Oriented.
Posted by: Channabasava Banakar
Contact Channabasava Banakar
-Ado is a connected architecture.
-Ado is supported by Lock Types.
-Ado.Net is a Disconnected Architecture.
-Ado.Net is not supported by Lock Types.
Posted by: krishnasamy
Main difference is that ADO.Net is mainly XML based and by using datasets we can get disconnected recordset.
Posted by: Pawan Tewari
Contact Pawan Tewari
1.Ado is created using COM technology,whereas Ado.net is implemented by using .NET framework technology.
2.In ADO we can store only one table,whereas in ado.net we can store multiple tables in the dataset.
3.In ADO we can't generate relations whereas in ADO.NET we can generate relations.
4.In ADO we can't generate SQL statements whereas in ADO.NET we can generate SQL statements.
5.ADO is connection-oriented,but ADO.NET is connectionless.
Posted by: UJJWAL KUMAR ADHYA
Contact UJJWAL KUMAR ADHYA
1)ActiveX data object is a connection oriented
2)No connection with XML
i) 24/7 online
ii) updated information
1)It's disconnected architecture
2)connection with xml & sql server only
No update information
Posted by: Sathishbabu
it use RecordSet
it uses Dataset
Posted by: SathishBabu
1.In case of ADO memory represantation of data is record set,
and In case of ADO.NET memory represantation of data is dataset.
2.uses of xml is very restricted in ADO.
We can use xml in ADO.NET.
Posted by: SHIMUL PAUL
Contact SHIMUL PAUL
1.ADO is a connection oriented architecture where as ADO.NET is a connection less architecture.
2.In ADO we can use recordset on the other hand in ADO.NET we can use Data set.
Data set can hold table in bulk
The ADO Recordset object is used to hold a set of records from a single table
Posted by: Arpit Mathur
Contact Arpit Mathur
ADO allows you to create client-side cursors only.
whereas ADO.NETgives you to choice either using client side or server side cursors.
Posted by: rupinder kaur bhinder
Contact rupinder kaur bhinder
difference between ado and ado.net
Posted by: venkat reddy
Contact venkat reddy
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
There should not be any Spelling Mistakes.
There should not be any Gramatical Errors.
Answers must not contain any bad words.
Answers should not be the repeat of same answer, already approved.
Answer should be complete in itself.