Retrieve PowerShell array and put in an ASP.NET C# array?

Question

0.00/5 (No votes)

See more:

Hey guys, I am able to run PowerShell scripts via an ASP.NET C# page and write single valued PS variables to a label. However, I can't figure out how to get or convert a PS array to a multidimensional array in ASP.NET C#.

Here is what I have so far. If "MyVar1" is an array in PS, how do I properly retrieve the data, convert it to a multidimensional array so I can bind into gridview?

I get "Cannot implicitly convert type 'object' to 'string[*,*]'. An explicit conversion exists (are you missing a cast?)" error when trying

C#

string[,] arrMultiD = Results;

Here is the code to run and get the PS results.

C#

Runspace runspace = RunspaceFactory.CreateRunspace();
runspace.Open();
var shell = PowerShell.Create();
string filePath = Server.MapPath("Scripts/MyScript.txt");
StreamReader reader = File.OpenText(filePath);
string powerShellCode = reader.ReadToEnd();
reader.Close();

shell.Commands.AddScript(powerShellCode);
var results = shell.Invoke();
var MyVar1 = shell.Runspace.SessionStateProxy.GetVariable("MyVar1");
runspace.Close();

Thanks!

Posted 25-May-13 17:46pm

Tyson3264

Updated 27-May-13 20:55pm

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tyson3264 · Accepted Answer · 2013-05-29T18:33:00

I was able to figure this out, the test script file contains 2 lines...
$result = Get-Process
$result

C#

Runspace runSpace = RunspaceFactory.CreateRunspace();
runSpace.Open();
string filePath = Server.MapPath("Scripts/TestScript.txt");
StreamReader reader = File.OpenText(filePath);
string powerShellCode = reader.ReadToEnd();
reader.Close();
var shell = PowerShell.Create();
shell.Commands.AddScript(powerShellCode);
Collection<psobject> results = shell.Invoke();

DataTable tempTable = new DataTable();
tempTable.Columns.Add("Id");
tempTable.Columns.Add("Processname");

foreach (PSObject psObject in results)
{
    DataRow row = tempTable.NewRow();
    row["Id"] = psObject.Properties["Id"].Value.ToString();
    row["Processname"] = psObject.Properties["Processname"].Value.ToString();
    tempTable.Rows.Add(row);
}

GridView1.DataSource = tempTable;
GridView1.DataBind();
runSpace.Close();</psobject>

Retrieve PowerShell array and put in an ASP.NET C# array?

1 solution

Solution 1

Add your solution here

Preview 0

Retrieve PowerShell array and put in an ASP.NET C# array?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us