Avatar of Sonny G
Sonny G
 asked on

What are the best practices for using, and differences of, DataSet, DataView and DataTable?

I have been a programmer since 1968 and I am learning VS2015 VB.NET. I have read three solid books on the subject and am writing code as an exercise to learn this VB.NET language.

After making the connection and creating an adapter to read the data, Then, I believe that the next step is to populate the dataset object.

Some books then suggest creating a DataView or DataTable. Some just work with the dataset. I am an MSDN subscriber/partner but their write-ups leave a lot to be desired at times.

What is the difference between the three? What are the conditions that you would use one over the other?

I will follow-up with another question so that you can get more points.

Thanks, in advance.
Visual Basic.NET* dataadap* datasets* 'dataviews* datatabes

Avatar of undefined
Last Comment
Fernando Soto

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Fernando Soto

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Sonny G

ASKER
Fernando, you are a natural teacher.

I am grateful for your explanation. It was really clear.

Lenny
Fernando Soto

Not a problem Lenny, glad I was able to help.
Your help has saved me hundreds of hours of internet surfing.
fblack61