Overview/Description
To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns
Target Audience
Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
Prerequisites
Good knowledge of VB.NET, SQL, relational databases, and Visual Studio .NET
describe the different approaches that can be used to retrieve data from data sources.
describe the DataSet class, its main properties and constituent objects, the role of constraints, relations, and views, and strategies for using DataSets.
explain how to work with DataSets in Windows Forms.
describe the role of the DataAdapter object and its key methods and properties.
use the Data Adapter Configuration Wizard to define DataAdapters with SQL statements or stored procedures.
use the Data Adapter Configuration Wizard to build command objects and data adapters for common data-access strategies.
create DataSets manually using Visual Basic .NET code or Visual Studio .NET tools.
create a DataSet and add DataTables and custom expression columns.
describe an XSD Schema and how to create one using Visual Studio .NET tools.
fill a DataSet using a DataAdapter.
define relationships and constraints, including primary keys, foreign keys, and DataRelations.
create and manage relationships between DataTables in code.
bind data to a Windows control, such as a text box or DataGrid.