Shane O’Neill shows how to deal with .NET DataRows in Powershell:
Now I don’t know about you but when I query stuff in a SQL database, it’s to do something to/with the results. They could be a list of servers that I monitor, they could be a list of databases that I want to check the recovery model of, or it could be a list of tables that I want to see how much space they are using. The main point is that I want to do something with the results.
But for this simple case, I just want to list out the customer name from this table. Simple? Yes, but this is just a test case to prove a point.
So let’s PowerShell this!
The moral of the story is to Get-Member early and Get-Member often.