ATLPhenx

function selectPOSData ($Server, $Database, $SQLQuery, $Username, $Password) {
    $Connection = New-Object System.Data.SQLClient.SQLConnection
    $Connection.ConnectionString = "server='$Server';database='$Database';User ID= $Username; Password= $Password;"
    $Connection.Open()
    $Command = New-Object System.Data.SQLClient.SQLCommand
    $Command.Connection = $Connection
    $Command.CommandText = $SQLQuery
    
    $Reader = $Command.ExecuteReader()
    while ($Reader.Read())

ATLPhenx

$conn = New-Object System.Data.SqlClient.SqlConnection
$conn.ConnectionString = $connectionString
$cmd = New-Object System.Data.SqlClient.SqlCommand
$cmd.commandtext = $query
$conn.open()
#Creates sql command
if ($conn.Open())
{
    Write-Host "connection established..."
}

ATLPhenx

$conn = New-Object System.Data.SqlClient.SqlConnection
$conn.ConnectionString = $connectionString
$cmd = New-Object System.Data.SqlClient.SqlCommand
$cmd.commandtext = $query
$conn.open()
#Creates sql command
if ($conn.Open())
{
    Write-Host "connection established..."
}

ATLPhenx

$connectionString = "Data Source=SQLSERVER;Initial Catalog=SYSINFO;Integrated Security=SSPI;"
#Find Connection information
#Gets system information
$os = Get-WmiInfo Win32_OperatingSystem
#loads the part of the .NET Framework that’s responsible for working with databases
[assembly.reflection]::loadwithpartialname('System.Data')
#Create new connection to database
$conn = New-Object System.Data.SqlClient.SqlConnection
$conn.ConnectionString = $connectionString
$conn.open()

ATLPhenx

$jsonObject = @{
    "TERMINALID" = "3232"
    "PINSERV" = "192.168.1.52:5145"
    "MERCHANTID" = "01"
    "ID" = "1421336011"
    "Serv" = "192.168.1.180:5150"
    "Lane" = "2017"
} | ConvertTo-Json

$TestDir = 'URL/Filename.xml';

ATLPhenx

MemberType                 : TypeInfo
DeclaringType              : 
DeclaringMethod            : 
ReflectedType              : 
StructLayoutAttribute      : System.Runtime.InteropServices.StructLayoutAttribu
                             te
GUID                       : 5f6aa156-8585-35c9-a6ae-2aefd06aaa4a
Module                     : System.Management.Automation.dll
Assembly                   : System.Management.Automation, Version=3.0.0.0, 
                             Culture=neutral, PublicKeyToken=31bf3856ad364e35

ATLPhenx

$jsonObject = @{
    TERMID = 3232
    PINSERV = '192.168.1.52:5145'
    MERCHANTID = 01
    ID = 1421336011
    Serv = '192.168.1.180:5150'
    Lane = 2017
} | ConvertTo-Json

$TestDir = 'path/filename.xml';