$conn = New-Object System.Data.SqlClient.SqlConnection("Data Source=(local);Integrated Security=true;Initial Catalog=TestDB")

$conn.Open()

$adp = New-Object System.Data.SqlClient.SqlDataAdapter("SELECT * FROM Kaboom", $conn)
$ds = New-Object System.Data.Dataset
$adp.Fill($ds)

$ds.Tables[0]