gistfile1.txt

function selectPOSData ($Server, $Database, $Username, $Password) {
    $Connection = New-Object System.Data.SQLClient.SQLConnection
    $Connection.ConnectionString = "server=$Server;database=$Database;User ID= $Username; Password= $Password;"
    
    $Command = New-Object System.Data.SQLClient.SQLCommand
    $Connection.Open()
    $Command.Connection = $Connection
    $Command.CommandText = 'somequery'
    
    # Fill the DataSet.
    $ds=New-Object system.Data.DataSet
    $da=New-Object system.Data.SqlClient.SqlDataAdapter($Command)
    $da.fill($ds) | Out-Null
    $Connection.Close()
    return $ds
}