Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

RECORDSET vs DATASET

Posted on 2003-12-02
9
Medium Priority
?
1,170 Views
Last Modified: 2007-12-19
hey, i keep reading in different places that the whole VB6/ADO recordset concept is now obsolete in VB.Net and has been replaced by ADO.Net, Datasets and DataAdaptors.  In some situations I still find ADO recordsets more usefull and easier to work with.  Is there a reason I should stay away from them in .Net or do you guys, like me, find yourself still using them in certain situations?
0
Comment
Question by:dwops
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 48

Expert Comment

by:AlexFM
ID: 9858974
You can continue using recordsets without any problems.
0
 
LVL 10

Expert Comment

by:GoodJun
ID: 9859041
ADO recordset is obsolete. If you use .net, then switch to ado.net, it may need some get used to, but you will be there eventually.
0
 
LVL 1

Author Comment

by:dwops
ID: 9859142
so, who's right, is it obsolete or should i keep using it?  are there any specific disadvantages or is it just personal opinion?
0
The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

 
LVL 28

Expert Comment

by:mmarinov
ID: 9859162
you will find situations that may be record set is more usefull , but this will be only a matter of time
once you get used to wth ado.net you will work more easily

B..G
0
 
LVL 3

Expert Comment

by:Geo123
ID: 9859362
err how about recordsets dont exist in VB.net.... Datasets are king. I know its a shock concept... but once you start using they are easy and can be related to 1.

cheers George
0
 
LVL 15

Expert Comment

by:liebrand
ID: 9859386
If you are using .NET do not use recordsets... definitely switch to ADO.NET -- once you start using it more you will see it has its advantages and it way better!
0
 
LVL 15

Assisted Solution

by:SRigney
SRigney earned 75 total points
ID: 9860837
.Net does offer more advantages than traditional ADO recordsets.  The sorting and filtering functionality work faster.  If you are connecting to SQL Server 7 or 2000 then the data access is faster, even if you are not the data access should be faster.  When you use traditional ADO in .Net, which you can do, you have to go through an interop to go between managed and unmanaged code.  This reduces the efficiency of the data access.

ADO is not officially dead, but it is a really (let me put a stress) REALLY good idea to use ADO.net when writing your application in .NET.  I have yet to see anything that you can do in the old version of ADO that ADO.Net does not also handle.  The only reason that I can think to keep using the older ADO is familiarity, but that will never change if you don't start using ADO.Net.
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 75 total points
ID: 9860960
ADO can be used, but since it is built on COM technology there has to be an additional layer added to .NET to give you access to it methods, properties, and events.  I realize that a lot of programmers have difficulty letting go of what they know and are comfortable with.  Micro$oft has rebuilt ADO in a new beast called ADO.NET, and a lot of things are built around this new technology.  Slowly but surely ADO will become a thing of the past, a dinosaur like DAO.  

So get on board, move into the future, and keep up with Jones', and learn about DataAdapters, DataSets, and all the other periphery.
0
 
LVL 1

Author Comment

by:dwops
ID: 9861131
thanks everybody
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question