Tag Archives: fill

Missing row when using ExecuteReader to fill a DataTable

I’ve been using the following PowerShell code to retrieve the contents of an SQL Server table and store it in a DataTable for fast local processing: $BuildDBConnection = New-Object -TypeName System.Data.SqlClient.SqlConnection -ArgumentList “Server=RCMSQL01;Database=TSBuild;Integrated Security=SSPI” $BuildDBConnection.Open() # Get Main table $SQLCommand … Continue reading

Rate this:

Posted in PowerShell, Scripting | Tagged , , , , , , , , | Leave a comment