To get started we need to create a table
Next 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.
Now 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
In 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.