Microsoft® .NET Compact Framework Kick Start

Modeling Relational Data with the DataSet

You now understand enough about the DataSet to populate it with a DataTable, access the data, and enforce some forms of constraints on the data. In this section we build on that knowledge and learn to perform common relational database operations with data inside a populated DataSet.

Deriving DataColumn Values with Expressions and Computed Fields

The value for a DataColumn can be computed based on the value of another DataColumn in the same DataRow. To do this, use the DataColumn.Expression property to describe the computed value for the DataColumn. The Expression property is a string value that describes the computation that derives the value for the DataColumn.

The syntax for the expression is rich ...