Question:
I’ve written a Powershell script that reads a CSV file and returns a predetermined collection from the data. Below is a sample output of said script.
|
1 2 3 4 5 6 |
Count Name ------ ------ 12 Rubies 3 Pearls 20 Emeralds |
I am able to obtain the results in C# by storing it in a PSObject like so:
|
1 2 3 4 |
var shell = PowerShell.Create(); shell.Commands.AddScript("C:\\Scripts\\Powershell\\Get-MyData.ps1"); Collection |
Now when I’m expecting a single object, I am able to obtain each value and assign them to variables like this:
|
1 2 3 4 5 |
foreach (PSObject psObject in results) { localVariable = Convert.ToString(psObject.Properties["Name"].Value); } |
However, I am having trouble converting this solution to a dynamic one. That is to say, the number of rows is expected to vary. So I’ve implemented this before when the source is a SQL database using a solution similar to the one posted here so I’ve assumed that datatables should be the way to go but I cannot get it to work in this scenario. Any ideas or suggestions? Thanks!
Note: The Powershell script component here is compulsory as it includes other mechanisms to formulate the output so while I could just read from the CSV file using C#, this is simply not an option.
Answer:
What I understood from your question is that you want to have DataTable for further data process and you want to use it in your respective collection.
You can proceed like this:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
DataTable dt=new DataTable(); dt.Colums.Add("Count"); dt.Colums.Add("Name"); foreach (PSObject psObject in results) { foreach(PSPropertyInfo prop in psObject.Properties) { var count=prop.Name; var name=prop.Value; //In other words generate output as you desire. dt.Rows.Add(count,name); } } |
Hope it’s helpful for you.