Count the visible rows in DataGridView using Powershell

Question

After I've used $DataGridView1.Rows[$row.Index].Visible = $false to hide some rows, I need to count how many are visible now.

If I use $DataGridView1.Rows.GetRowCount.ToString()

I get this result:

int GetRowCount(System.Windows.Forms.DataGridViewElementStates includeFilter)

So, if I use $DataGridView1.Rows.GetRowCount($DataGridViewElementStates.Visible)

I would expect a number of the visible rows in my DataGridView, but it returns an exception:

    Cannot convert argument "includeFilter", with value: "", for "GetRowCount" 
to type "System.Windows.Forms.DataGridViewElementStates": "Cannot convert null 
to type "System.Windows.Forms.DataGridViewElementStates" due to enumeration 
values that are not valid. Specify one of the following enumeration values and 
try again. The possible enumeration values are 
"None,Displayed,Frozen,ReadOnly,Resizable,ResizableSet,Selected,Visible"."

What am I doing wrong?

Mathias R. Jessen · Accepted Answer · 2018-09-09 12:04:32Z

3

As the error indicates, you'll need to supply a value of type System.Windows.Forms.DataGridViewElementStates:

$DataGridView1.Rows.GetRowCount([System.Windows.Forms.DataGridViewElementStates]::Visible)

answered Sep 9, 2018 at 12:04

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Daniel Sian Over a year ago

All I could find about this was related to C#, but I was unable to translate that code into Powershell. Thanks!

Mathias R. Jessen Over a year ago

This answer may be useful for future reference

Collectives™ on Stack Overflow

Count the visible rows in DataGridView using Powershell

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related