Getting Datagridview to Populate Correctly

[TechGy]

I have a GUI application designed that includes a button and a datagridview box. The button click event loads the datagridview box. Unfortunately I can't get the datagridview box to populate with information

Button Click Code:

Code: [Select all] [Expand/Collapse] [Download] (Untitled.ps1)

1. $buttonStep2LoadSoftwareLis_Click={
2.     #Send PDQ server command to list all PDQ Deploy packages via Powershell Remoting
3.     $packages = Invoke-Command -ComputerName $PDQServerName -Credential (Get-Credential) { "SELECT Packages.Name from Packages;" | sqlite3.exe "C:\ProgramData\Admin Arsenal\PDQ Deploy\Database.db" }
4.     $table = ConvertTo-DataTable -InputObject $packages
5.     #Load the Software List
6.     Update-DataGridView -DataGridView $datagridview1 -Item $table
7. }

You can see what the form outputs in the Datagridview_Click_Output.png attachment in this post
You can see what the command outputs in the PS_Output.png


Can someone help me get this into a format that loads the datagridview box with the information like it's output when running the command in Powershell?

[jvierra]

The output of your query is text and not objects. You muse use a command based of OLEDB.Net and the System.Data.OleDbClient. The sqllite EXE cannot create objects.

[jvierra]

Here is an article from MS showing how to access SQLLite databases from PowerShell using the SQLLite provider.

https://social.technet.microsoft.com/wi ... bases.aspx