Get started
#
Create one or more tablesTo get started we need to create a table
#
Add columns to tablesNext we need to add a few columns to the table. First we'll add a few plain columns. Secondly we will add a column with an expression. This expression concatinates firstname and lastname to a displayname. Last we will add a column that has a default value in case nothing is set.
#
Add rows to tablesNow that we have a basic strucutre in our users table we can start
to add rows. The Add-DataTableRow
cmdlet accepts
psobjects as input. The object should contains properties
corresponding to columns in the DataTable.
The content of the data table is now
#
Create a datasetIn case several data tables are needed a data set can be created. A data set can be viewed as a container of data tables and provides a few extra capabilities like data table relations. To create a data set and add tables run the following commands.