Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: Get a DataTable from SQL Server via query (PowerShell)
Title: Get a DataTable from SQL Server via query Language: PowerShell
Description: A short function that can be used to get a DataTable of data from a SQL Server. Views: 91
Author: Michael Wood Date Added: 7/1/2008
Copy Code   
$CnnString = "server=.;integrated security=true;database=DBName"

function Get-DataTable([string]$query)
{
	$dataSet= new-object "System.Data.DataSet" "DataSetName"
	$da = new-object "System.Data.SqlClient.SqlDataAdapter" ($query, $CnnString)
	[void] $da.Fill($dataSet)
	return $dataSet.Tables[0]
}
Usage 
Set the $CnnString to your connection string and pass in a query to execute.
Notes
This script only returns the first table in the dataset.