49 lines
1.2 KiB
PowerShell
49 lines
1.2 KiB
PowerShell
$SQLServer = "192.168.13.101" #use Server\Instance for named SQL instances!
|
|
$SQLDBName = "CP2DD"
|
|
$SqlQuery = "select top 1 * from lief"
|
|
$user = "sa"
|
|
$pwd = "dd"
|
|
|
|
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
|
|
$SqlConnection.ConnectionString = "Server = $SQLServer; ;uid=$user; pwd=$pwd; Database = $SQLDBName; Integrated Security = False"
|
|
|
|
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
|
|
$SqlCmd.CommandText = $SqlQuery
|
|
$SqlCmd.Connection = $SqlConnection
|
|
|
|
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
|
|
$SqlAdapter.SelectCommand = $SqlCmd
|
|
|
|
$DataSet = New-Object System.Data.DataSet
|
|
|
|
$SqlConnection.Open()
|
|
$SqlAdapter.Fill($DataSet)
|
|
$SqlConnection.Close()
|
|
|
|
$DataSet.Tables[0] | Out-GridView
|
|
# $DataSet.Tables[0] | Export-CliXML e:\Test2.xml
|
|
|
|
$DataSet.Tables[0] | select liefname
|
|
|
|
#----------------------------X M L ------------------------#
|
|
|
|
$xml = New-Object XML
|
|
$xml.Load("e:\Vorlage3.xml")
|
|
#$xml
|
|
|
|
$oldperson = @($xml.employees.employee)[0]
|
|
$oldperson
|
|
|
|
|
|
|
|
$newperson = $oldperson.Clone()
|
|
$newperson.name = "Cofi"
|
|
$newperson.age = "30"
|
|
$newperson.id = "103"
|
|
|
|
$xml.employees.AppendChild($newperson)
|
|
|
|
write-host "---------------"
|
|
$xml
|
|
|
|
$xml.Save("e:\Vorlage3.xml") |