$cmd = New-Object system.Data.SqlClient.SqlCommand($query, $conn)

$ds = New-Object System.Data.DataSet
       $da = New-Object System.Data.SqlClient.SqlDataAdapter($cmd)

try {
    [void]$da.Fill($ds)
    }
    catch {
    Write-Error "Not able to fill dataset for list of customers!"
    }