gistfile1.txt

function selectPOSData ($Server, $Database, $query, $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 = $query
    #Set the SqlDataAdapter's SelectCommand.
  
    # Fill the DataSet.
    $ds=New-Object system.Data.DataSet
    $da=New-Object system.Data.SqlClient.SqlDataAdapter($Command)
    $da.fill($ds) | Out-Null

    $Connection.Close()
}