C#•3y ago

✅ PowerShell Method in WinUI C#

So firstly, yes I have to use Powershell and am unable to just do it in C#.

Below will be an example of a basic PowerShell script that I have
My issue is that I'm returning a System.Data.Datarow, but I'm unable to return any data in C#.

PowerShell Console Results

PS R:\> \\ris1\xnet\data\Wan\RestDB_Dependencies\PowerShell_Scripts\POS\Get-POS.ps1 -Site 1124

POS              POSNumber
---              ---------
POS 1 - Cashier  01
POS 2 - Takeout  02
POS 3 - Takeout  03
POS 4 - Bar      04
POS 5 - Takeout  05
POS 6 - Takeout  06
POS 7 - Takeout  07
POS 8 - Takeout  08


PS R:\> \\ris1\xnet\data\Wan\RestDB_Dependencies\PowerShell_Scripts\POS\Get-POS.ps1 -Site 1124 |GM


   TypeName: System.Data.DataRow

Name              MemberType            Definition
----              ----------            ----------
AcceptChanges     Method                void AcceptChanges()
BeginEdit         Method                void BeginEdit()
CancelEdit        Method                void CancelEdit()
ClearErrors       Method                void ClearErrors()
Delete            Method                void Delete()
EndEdit           Method                void EndEdit()
Equals            Method                bool Equals(System.Object obj)
GetChildRows      Method                System.Data.DataRow[] GetChildRows(string relationName), System.Data.DataRow[] GetChildRows(string relationName, ...
GetColumnError    Method                string GetColumnError(int columnIndex), string GetColumnError(string columnName), string GetColumnError(System.Da...
GetColumnsInError Method                System.Data.DataColumn[] GetColumnsInError()
GetHashCode       Method                int GetHashCode()
GetParentRow      Method                System.Data.DataRow GetParentRow(string relationName), System.Data.DataRow GetParentRow(string relationName, Syst...
GetParentRows     Method                System.Data.DataRow[] GetParentRows(string relationName), System.Data.DataRow[] GetParentRows(string relationName...
GetType           Method                type GetType()
HasVersion        Method                bool HasVersion(System.Data.DataRowVersion version)
IsNull            Method                bool IsNull(int columnIndex), bool IsNull(string columnName), bool IsNull(System.Data.DataColumn column), bool Is...
RejectChanges     Method                void RejectChanges()
SetAdded          Method                void SetAdded()
SetColumnError    Method                void SetColumnError(int columnIndex, string error), void SetColumnError(string columnName, string error), void Se...
SetModified       Method                void SetModified()
SetParentRow      Method                void SetParentRow(System.Data.DataRow parentRow), void SetParentRow(System.Data.DataRow parentRow, System.Data.Da...
ToString          Method                string ToString()
Item              ParameterizedProperty System.Object Item(int columnIndex) {get;set;}, System.Object Item(string columnName) {get;set;}, System.Object I...
POS               Property              string POS {get;set;}
POSNumber         Property              string POSNumber {get;set;}

PS R:\> \\ris1\xnet\data\Wan\RestDB_Dependencies\PowerShell_Scripts\POS\Get-POS.ps1 -Site 1124

POS              POSNumber
---              ---------
POS 1 - Cashier  01
POS 2 - Takeout  02
POS 3 - Takeout  03
POS 4 - Bar      04
POS 5 - Takeout  05
POS 6 - Takeout  06
POS 7 - Takeout  07
POS 8 - Takeout  08


PS R:\> \\ris1\xnet\data\Wan\RestDB_Dependencies\PowerShell_Scripts\POS\Get-POS.ps1 -Site 1124 |GM


   TypeName: System.Data.DataRow

Name              MemberType            Definition
----              ----------            ----------
AcceptChanges     Method                void AcceptChanges()
BeginEdit         Method                void BeginEdit()
CancelEdit        Method                void CancelEdit()
ClearErrors       Method                void ClearErrors()
Delete            Method                void Delete()
EndEdit           Method                void EndEdit()
Equals            Method                bool Equals(System.Object obj)
GetChildRows      Method                System.Data.DataRow[] GetChildRows(string relationName), System.Data.DataRow[] GetChildRows(string relationName, ...
GetColumnError    Method                string GetColumnError(int columnIndex), string GetColumnError(string columnName), string GetColumnError(System.Da...
GetColumnsInError Method                System.Data.DataColumn[] GetColumnsInError()
GetHashCode       Method                int GetHashCode()
GetParentRow      Method                System.Data.DataRow GetParentRow(string relationName), System.Data.DataRow GetParentRow(string relationName, Syst...
GetParentRows     Method                System.Data.DataRow[] GetParentRows(string relationName), System.Data.DataRow[] GetParentRows(string relationName...
GetType           Method                type GetType()
HasVersion        Method                bool HasVersion(System.Data.DataRowVersion version)
IsNull            Method                bool IsNull(int columnIndex), bool IsNull(string columnName), bool IsNull(System.Data.DataColumn column), bool Is...
RejectChanges     Method                void RejectChanges()
SetAdded          Method                void SetAdded()
SetColumnError    Method                void SetColumnError(int columnIndex, string error), void SetColumnError(string columnName, string error), void Se...
SetModified       Method                void SetModified()
SetParentRow      Method                void SetParentRow(System.Data.DataRow parentRow), void SetParentRow(System.Data.DataRow parentRow, System.Data.Da...
ToString          Method                string ToString()
Item              ParameterizedProperty System.Object Item(int columnIndex) {get;set;}, System.Object Item(string columnName) {get;set;}, System.Object I...
POS               Property              string POS {get;set;}
POSNumber         Property              string POSNumber {get;set;}

Within my application I have a PowerShellHelper.cs where I'm trying to use System.Management.Automation with the below method

        public static Collection<PSObject> GetTableData(string script)
        {
            using (PowerShell powerShellInstance = PowerShell.Create())
            {
                Debug.WriteLine("Script: " + script);
                powerShellInstance.AddScript(script);


                Collection<PSObject> results = powerShellInstance.Invoke();

                if (results == null || results.Count == 0)
                {
                    Debug.WriteLine("No results returned.");
                }
                else
                {
                    Debug.WriteLine("Results: " + results.ToString());
                }

                return results;
            }
        }

        public static Collection<PSObject> GetTableData(string script)
        {
            using (PowerShell powerShellInstance = PowerShell.Create())
            {
                Debug.WriteLine("Script: " + script);
                powerShellInstance.AddScript(script);


                Collection<PSObject> results = powerShellInstance.Invoke();

                if (results == null || results.Count == 0)
                {
                    Debug.WriteLine("No results returned.");
                }
                else
                {
                    Debug.WriteLine("Results: " + results.ToString());
                }

                return results;
            }
        }

Sir RuggieOP•1/29/23, 11:46 PM

Also tried

and in my class that is calling it, I'm calling it something like

Andrew•1/30/23, 1:25 AM

I was able to get results with a simple test:

and the script:

dance?•1/30/23, 7:19 AM

i think i would use json too

Sir RuggieOP•1/30/23, 1:22 PM

This thing is kicking my butt..

It will not display anything with the above data at all using Json, but it will return something with this, but then it's just a big jumbled together mess of string.

AAndrew I was able to get results with a simple test: ```csharp using Newtonsoft.Json;...

Sir RuggieOP•1/30/23, 2:32 PM

I am using WinUI 3.0
Do you think that would make it any different?

dance?•1/31/23, 7:10 AM

you are not serializing the data
try piping the datatable to ConvertTo-Json
or probably better, first make a list of your object
like @{} with all the fields, the json, the send it to your app

Andrew•1/31/23, 8:23 PM

the json usage was just because "toString" on DataRow just outputs the type. You shouldn't need JSON here, the object was visible in the debugger without it

AAndrew the json usage was just because "toString" on DataRow just outputs the type. You...

Sir RuggieOP•1/31/23, 9:01 PM

For some reason I'm not able to see any data...
I am using the same code you're using and I made a new WIN UI project just to make it fresh to test it and it keeps coming back as null data

Sir RuggieOP•1/31/23, 9:01 PM

but I can run the script from powershell and return the data

Andrew•1/31/23, 9:10 PM

I don't think WinUI will cause any issue, but have you tried with just a commandline app just in case?

Andrew•1/31/23, 9:18 PM

othwerwise, the next thing to check is that this returns anything

If it does, the rest is just failing because of conversion (likely)

AAndrew othwerwise, the next thing to check is that this returns anything `Collection<PS...

Sir RuggieOP•1/31/23, 9:28 PM

So this is the result that I'm getting by using this

Andrew•1/31/23, 9:38 PM

what's in test.ps1?

AAndrew what's in test.ps1?

Sir RuggieOP•1/31/23, 9:38 PM

Just that one column 1

Sir RuggieOP•1/31/23, 9:38 PM

It's the script you sent above

Sir RuggieOP•1/31/23, 9:38 PM

Andrew•1/31/23, 9:43 PM

interesting... what version of .NET are you using? and packages?

Andrew•1/31/23, 9:43 PM

is my csproj

Andrew•1/31/23, 9:44 PM

is what I see in the debugger

Sir RuggieOP•1/31/23, 9:44 PM

Sir RuggieOP•1/31/23, 9:45 PM

So maybe I need to reference .NET 7

Andrew•1/31/23, 9:45 PM

idk, but I'd reduce differences until we figure it out

Sir RuggieOP•1/31/23, 9:46 PM

ok, changing now...

Andrew•1/31/23, 9:46 PM

I also wonder if there's some issue with script execution policy... if the script isn't returning anything that could be it? does it have errors on invocation?

Sir RuggieOP•1/31/23, 9:46 PM

I always see this error when changing

Sir RuggieOP•1/31/23, 9:46 PM

The project 'TableTest' ran into a problem during the last operation: A numeric comparison was attempted on "$(TargetPlatformVersion)" that evaluates to "" instead of a number, in condition "'$(TargetPlatformVersion)' < '10.0.18362.0'". C:\Users\gposab7.nuget\packages\microsoft.windowsappsdk\1.2.221109.1\buildTransitive\Microsoft.InteractiveExperiences.Common.targets You may need to reload the solution after fixing the problem.

AAndrew I also wonder if there's some issue with script execution policy... if the scrip...

Sir RuggieOP•1/31/23, 9:47 PM

Execution policy is Bypass

Andrew•1/31/23, 9:50 PM

just try a new console project, not winui

Sir RuggieOP•1/31/23, 9:54 PM

Sir RuggieOP•1/31/23, 9:58 PM

That matches now

Sir RuggieOP•1/31/23, 10:04 PM

Andrew•1/31/23, 10:09 PM

is there anything in the error stream of the psinstance?

Sir RuggieOP•1/31/23, 10:11 PM

{System.Management.Automation.PSDataCollection<System.Management.Automation.ErrorRecord>}

Sir RuggieOP•1/31/23, 10:12 PM

Andrew•1/31/23, 10:13 PM

does it have errors in the error stream?

Sir RuggieOP•1/31/23, 10:13 PM

Sir RuggieOP•1/31/23, 10:13 PM

Is that what you were looking for?

Andrew•1/31/23, 10:16 PM

it will be null on that line because it's not initialized yet. Look at

Andrew•1/31/23, 10:16 PM

when broken on a line, the line hasn't been executed yet

Sir RuggieOP•1/31/23, 10:19 PM

Sir RuggieOP•1/31/23, 10:20 PM

found the error

Sir RuggieOP•1/31/23, 10:21 PM

But I can run the script outside of this

Andrew•1/31/23, 10:24 PM

try setting execution policy to unrestricted?

Andrew•1/31/23, 10:24 PM

I'm not quite a powershell expert, but policy is definitely the problem here

Sir RuggieOP•1/31/23, 10:33 PM

Alright, I will have to try this on a non work laptop as I don't have permissions to change policy.

I'll let you know, thank you!

Andrew•1/31/23, 10:40 PM

you might be able to do

var sessionState = InitialSessionState.CreateDefault();
sessionState.ExecutionPolicy = Microsoft.PowerShell.ExecutionPolicy.Unrestricted;
PowerShell powerShellInstance = PowerShell.Create(sessionState);

Andrew•1/31/23, 10:40 PM

but it's beyond my expertise at that point, just a guess based on API structure

I know you can invoke ps with a different execution policy than the default

AAndrew you might be able to do > var sessionState = InitialSessionState.Creat...

Sir RuggieOP•2/1/23, 10:14 PM

That worked!

Sir RuggieOP•2/1/23, 10:14 PM

even though my execution policy was set to unrestricted it still complained, idk y