dyco

$server = ".";
$instance = "EPT";
$query ="select * from APAUTH";

  
$connection = new-object system.data.sqlclient.sqlconnection( `
    "Data Source=$server;Initial Catalog=$instance;Integrated Security=SSPI;");
    
$adapter = new-object system.data.sqlclient.sqldataadapter ($query, $connection)
$set = new-object system.data.dataset
  
$adapter.Fill($set)
  
$table = new-object system.data.datatable
$table = $set.Tables[0]
  
#return table
$table