Powershell Datenimport

$hashtable['Einstellung1']
$hashtable['Einstellung2']

$hashtable.'Einstellung1'

$csv = @"  
Variable;Typ;Wert
var1;string;Max Muster
var2;array;2001,2002,2003,2003
var3;int;100
"@ | convertfrom-CSV -Delimiter ";"  

# Hashtable hält unsere Daten
$data = @{}
# CSV durchlaufen und Werte der Hashtable zuweisen
foreach($line in $csv){
   switch($line.Typ){
        'int' {$data[$line.Variable] = [int]$line.Wert}  
        'array' {$data[$line.Variable] = [array]$line.Wert.Split(',')}  
        default {$data[$line.Variable] = [string]$line.Wert}
    }
}
$data

"Bla,Blub" -split ','

$array = $variable.Split(',')

$data['NameDerVariablen']

$data.'Name Der Variablen'

$pathSettings = 'A:\meine_app_settings.xml'  

# Klassendefinition
Add-Type -TypeDefinition @"  
    public class myAppSettings {
        public string var1;
        public int var2;
        public double var3;
        public string var4;
    }
"@ -EA Ignore  

# Objekt von Klasse erzeugen
$settings = new-object myAppSettings
$settings.var1 = "teststring"  
$settings.var2 = 333
$settings.var3 = 999383828
$settings.var4 = @("1","2","3","4")  

# XML-Serialization
$serializer = New-Object System.Xml.Serialization.XmlSerializer ([myAppSettings])
$writer = New-Object System.IO.StreamWriter($pathSettings)
$serializer.Serialize($writer,$settings)
$writer.Close()


# Settings-Objekt für die Demo zerstören
$settings = $null

# XML-Deserialization wieder aus XML-Datei laden
$serializer = New-Object System.Xml.Serialization.XmlSerializer([myAppSettings])
$settings = $serializer.Deserialize((New-Object System.IO.StreamReader($pathSettings)))

# geladene Daten wieder anzeigen
$settings

# Der Zugriff auf die einzelnen Eigenschaften(Variablen) erfolgt wie bei jedem anderen Custom-Objekt
$settings.var4

$table = $datagridviewResults.DataSource.Copy()
$table.WriteXml("$global:ProgramXMLPath\Library.xml", [system.data.xmlwritemode]::WriteSchema)  

$scriptpath = Split-Path $MyInvocation.MyCommand.Definition -Parent
$xmlpath = "$scriptpath\data.xml"  

function GenerateForm {

#region Import the Assemblies
[reflection.assembly]::loadwithpartialname("System.Windows.Forms") | Out-Null  
[reflection.assembly]::loadwithpartialname("System.Drawing") | Out-Null  
#endregion

#region Generated Form Objects
$form1 = New-Object System.Windows.Forms.Form
$btnExport = New-Object System.Windows.Forms.Button
$btnImport = New-Object System.Windows.Forms.Button
$dgv = New-Object System.Windows.Forms.DataGridView
$InitialFormWindowState = New-Object System.Windows.Forms.FormWindowState
$dt = New-Object System.Data.DataTable

#endregion Generated Form Objects

#----------------------------------------------
# Event Script Blocks
#----------------------------------------------
$handler_form1_Load= 
{
    $dt.TableName = "Daten"  
    $dt.Columns.Add('Vorname')  
    $dt.Columns.Add('Nachname')  
    $dt.Rows.Add(@('Max','Muster'))  
    $dt.Rows.Add(@('Anna','Musterfrau'))  
    $dgv.DataSource = $dt
}

$handler_btnExport_Click= 
{
    $dt.WriteXml($xmlpath)
    [System.Windows.Forms.MessageBox]::Show("Daten wurden exportiert nach '$xmlpath' !")  
}

$handler_btnImport_Click= 
{
    if ((Test-Path $xmlpath)){
        $dt.Clear()
        $dt.ReadXml($xmlpath)
        [System.Windows.Forms.MessageBox]::Show("Daten wurden importiert von '$xmlpath'!")  
    }else{
        [System.Windows.Forms.MessageBox]::Show("Führen sie erst einen Export durch!")  
    }

}

$OnLoadForm_StateCorrection=
{#Correct the initial state of the form to prevent the .Net maximized form issue
	$form1.WindowState = $InitialFormWindowState
}

#----------------------------------------------
#region Generated Form Code
$System_Drawing_Size = New-Object System.Drawing.Size
$System_Drawing_Size.Height = 183
$System_Drawing_Size.Width = 340
$form1.ClientSize = $System_Drawing_Size
$form1.DataBindings.DefaultDataSourceUpdateMode = 0
$form1.Name = "form1"  
$form1.Text = "DataGridView Load&Export"  
$form1.add_Load($handler_form1_Load)

$btnExport.Anchor = 10

$btnExport.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point
$System_Drawing_Point.X = 253
$System_Drawing_Point.Y = 157
$btnExport.Location = $System_Drawing_Point
$btnExport.Name = "btnExport"  
$System_Drawing_Size = New-Object System.Drawing.Size
$System_Drawing_Size.Height = 23
$System_Drawing_Size.Width = 75
$btnExport.Size = $System_Drawing_Size
$btnExport.TabIndex = 2
$btnExport.Text = "Exportieren"  
$btnExport.UseVisualStyleBackColor = $True
$btnExport.add_Click($handler_btnExport_Click)

$form1.Controls.Add($btnExport)

$btnImport.Anchor = 10

$btnImport.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point
$System_Drawing_Point.X = 172
$System_Drawing_Point.Y = 157
$btnImport.Location = $System_Drawing_Point
$btnImport.Name = "btnImport"  
$System_Drawing_Size = New-Object System.Drawing.Size
$System_Drawing_Size.Height = 23
$System_Drawing_Size.Width = 75
$btnImport.Size = $System_Drawing_Size
$btnImport.TabIndex = 1
$btnImport.Text = "Importieren"  
$btnImport.UseVisualStyleBackColor = $True
$btnImport.add_Click($handler_btnImport_Click)

$form1.Controls.Add($btnImport)

$dgv.Anchor = 15
$dgv.DataBindings.DefaultDataSourceUpdateMode = 0
$System_Drawing_Point = New-Object System.Drawing.Point
$System_Drawing_Point.X = 12
$System_Drawing_Point.Y = 12
$dgv.Location = $System_Drawing_Point
$dgv.Name = "dgv"  
$System_Drawing_Size = New-Object System.Drawing.Size
$System_Drawing_Size.Height = 139
$System_Drawing_Size.Width = 316
$dgv.Size = $System_Drawing_Size
$dgv.TabIndex = 0

$form1.Controls.Add($dgv)

#endregion Generated Form Code

#Save the initial state of the form
$InitialFormWindowState = $form1.WindowState
#Init the OnLoad event to correct the initial state of the form
$form1.add_Load($OnLoadForm_StateCorrection)
#Show the Form
$form1.ShowDialog()| Out-Null

} #End Function

GenerateForm

$data = @{}
$dt = New-Object System.Data.DataTable
$dt.TableName = "Daten"  
[void]$dt.Columns.Add('Variable')  
[void]$dt.Columns.Add('Typ')  
[void]$dt.Columns.Add('Wert')  
[void]$dt.Rows.Add(@('var01','string','Das ist ein String'))  
[void]$dt.Rows.Add(@('var02','array','400,500,600'))  

foreach ($r in $dt.Rows){
    switch($r.Typ){
        'int' {$data[$r.Variable] = [int]$r.Wert}  
        'array' {$data[$r.Variable] = [array]$r.Wert.Split(',')}  
        default {$data[$r.Variable] = [string]$r.Wert}
    }
}
$data