I have written previously about how to convert an object to a DataTable and how to create one based on an existing MSSQL table, but now I will share a function to create a new empty DataTable. Sure, this isn’t very complicated to do manually, but using this function you can define the table structure using an ordered dictionary, which makes it much easier to update later if needed.

function New-DataTable {
<#
.SYNOPSIS
Create a new DataTable.
.DESCRIPTION
Create a new DataTable.
.EXAMPLE
`
$myColumns = [ordered] @{
ID = [int32]
Name = [string]
Age = [int]
Date = [DateTime]
}
$myTable = New-DataTable -TableName 'MyTable' -Columns $myColumns
.NOTES
Author: Øyvind Kallstad
Date: 20.10.2014
Version: 1.0
#>
[CmdletBinding()]
[OutputType([System.Data.DataTable])]
param (
[parameter()]
[string] $TableName,
# Use an ordered dictionary to define the table columns.
[parameter()]
[System.Collections.Specialized.OrderedDictionary] $Columns
)
# create new datatable
$newDataTable = New-Object TypeName 'System.Data.DataTable' ArgumentList $TableName
Write-Verbose "DataTable created '$TableName'"
# create columns
if ($PSBoundParameters['Columns']) {
$Columns.GetEnumerator() | ForEach-Object {
$columnName = $_.Key
$columnType = $_.Value.ToString()
$dataColumn = New-Object TypeName 'System.Data.DataColumn' ArgumentList ($columnName,$columnType)
$newDataTable.Columns.Add($dataColumn)
Write-Verbose "New column created '$columnName'"
}
}
Write-Output @(,$newDataTable)
}

view raw
New-DataTable.ps1
hosted with ❤ by GitHub

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s