O'Reilly logo

Professional Visual Studio® 2010 by Chris Anderson, Michael Minutillo, David Gardner, Nick Randolph

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 27. DataSets and DataBinding

WHAT'S IN THIS CHAPTER?

  • Creating DataSets

  • Connecting visual controls to a DataSet with DataBinding

  • How BindingSource and BindingNavigator controls work together

  • Chaining BindingSources and using the DataGridView

  • Using Service and Object data sources

A large proportion of applications use some form of data storage. This might be in the form of serialized objects or XML data, but for long-term storage that supports concurrent access by a large number of users, most applications use a database. The .NET Framework includes strong support for working with databases and other data sources. This chapter examines how to use DataSets to build applications that work with data from a database.

In the second part of this chapter you see how to use DataBinding to connect visual controls to the data they are to display. You see how they interact and how you can use the designers to control how data is displayed.

The examples in this chapter are based on the sample AdventureWorksLT database that is available as a download from http://professionalvisualstudio.com/link/1029A.

DATASETS OVERVIEW

The .NET Framework DataSet is a complex object that is approximately equivalent to an in-memory representation of a database. It contains DataTables that correlate to database tables. These in turn contain a series of DataColumns that define the composition of each DataRow. The DataRow correlates to a row in a database table. It is also possible to establish relationships between ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required