LibrarySqlData (modification of post by view diff)
embed code: <script type="text/javascript" src="http://PoshCode.org/embed/1139"></script>download | new post
Library defines two simple functions that use ADO.NET to get and set SQL data.
- #######################
- function Get-SqlData
- {
- param([string]$serverName=$(throw 'serverName is required.'), [string]$databaseName=$(throw 'databaseName is required.'),
- [string]$query=$(throw 'query is required.'))
- Write-Verbose "Get-SqlData serverName:$serverName databaseName:$databaseName query:$query"
- $connString = "Server=$serverName;Database=$databaseName;Integrated Security=SSPI;"
- $da = New-Object "System.Data.SqlClient.SqlDataAdapter" ($query,$connString)
- $dt = New-Object "System.Data.DataTable"
- [void]$da.fill($dt)
- $dt
- } #Get-SqlData
- #######################
- function Set-SqlData
- {
- param([string]$serverName=$(throw 'serverName is required.'), [string]$databaseName=$(throw 'databaseName is required.'),
- [string]$query=$(throw 'query is required.'))
- $connString = "Server=$serverName;Database=$databaseName;Integrated Security=SSPI;"
- $conn = new-object System.Data.SqlClient.SqlConnection $connString
- $conn.Open()
- $cmd = new-object System.Data.SqlClient.SqlCommand("$query", $conn)
- [void]$cmd.ExecuteNonQuery()
- $conn.Close()
- } #Set-SqlData
Submit a correction or amendment below (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.