SAPIEN Technologies

The full table is there I just cut it off because the wordwrap would make it confusing.

Can you tell me how to change the build version?

This is what my table looks like. UPN AzureRMS Office_PP Lync Office_Onli ne --- -------- --------- ---- ----------- email1... Disabled Enabled Disabled Enabled email2... Disabled Enabled Disabled Enabled email3... Disabled Enabled Disabled Disabled email4... Disabled Enabled Disabled Disabled email...

No dice unfortunately. This is via the shell. Enumerating all rows just to test but will eventually have to be all that equal Enabled. PS C:\Windows> $list = $dataset.tables[0] PS C:\Windows> PS C:\Windows> $p = @{ >> Sharepoint = ($list.sharepoint).Count >> RMS = ($list.azurerms).Count >> } >> $o =...

The data is definitely there. I put a hidden datagridview on the form. $textbox2.Text = $datagridview3.rows.count It gives me 140 rows. I was going to make one last attempt at enumerating the counts by rows in the datagrid to populate the text box but I can't figure out how to select a column from it.

JRV? Sorry, the screen shot was just to show the difference between the shell and gui. As you can seen in the debug window the counts are empty. You're two snippets work fine, I don't have an issue updating the text box with text, or the full table. It's when I count the objects from the table that ...

Thanks, I tried but still having trouble converting to an array.

After multiple attempts I decided to abandon the datagrid in favor of a text box and now I'm having issues with it as well.

I am not understanding why there is a difference in output via the shell and PS studio.

I have a sql table with a row of users and licensing status. I can get a count of the products in powershell just fine but I can only get the column headers in datagridview. $list = $dataset.Tables[0] New-Object psobject -Property @{ sharepoint = ($list.sharepoint | ? { $_ -like "enab*" })...

Thank you, I was able to get it to work with a datareader function instead.

I have a stored procedure to search all my tables for a string. I can return the data and populate a gridview without issue. Where I'm having issues is I need to select data from a column and reuse it in another function. When I change the bottom line to $dataset.Tables[0].columnname it will not ret...