Skip to Content
Visual Studio® 2010 All-in-One For Dummies®
book

Visual Studio® 2010 All-in-One For Dummies®

by Rick Leinecker
June 2010
Beginner
912 pages
18h 27m
English
For Dummies
Content preview from Visual Studio® 2010 All-in-One For Dummies®

Chapter 3. Working with Strongly Typed DataSets

In This Chapter

  • Creating DataSets in a class library

  • Using the DataSet Designer

  • Accessing data with TableAdapters

  • Digging into the code of a typed DataSet

  • Consuming typed DataSets

Programmers have always needed a way to work with data in their applications. Accessing data from files or databases every time you need data is impractical. To accommodate the need to have programs access data quickly, programmers store data in memory, using everything from arrays to integers to custom data structures.

Instead of making you spend lots of time thinking about how to store data in memory, Microsoft created the DataSet to provide a standardized means of storing data in memory for quick access.

A DataSet works like an in-memory database. The DataSet has tables with columns and rows, and you create relations between tables. You can load data into a DataSet from a database, or you can enter new data into the DataSet. You can insert, delete, and update records. After you make all the changes to records in your DataSet, you commit those changes to the actual database.

Visual Studio provides the DataSet Designer for creating and manipulating DataSets. This chapter explains what a DataSet is and shows you how to use the DataSet Designer to create a special kind of DataSet, the strongly typed DataSet.

Understanding the DataSet

A DataSet is a resource provided by the Microsoft .NET Framework for storing data in memory. DataSets store data in tables, and you can ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Microsoft® Visual Studio® 2010 Unleashed

Microsoft® Visual Studio® 2010 Unleashed

Mike Snell, Lars Powers
Visual Studio Condensed

Visual Studio Condensed

Patrick Desjardins

Publisher Resources

ISBN: 9780470539439Purchase book