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 ...

Get Professional Visual Studio® 2010 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.