Number of rows in a datagrid

[PaulNaude]

I discovered the hard way that the property "VisibleRowCount" of a datagrid
is ONLY that, the number of visible rows, NOT the number of populated rows in
the datagrid.

I need the number of populated rows (i.e. the number of records the user has
access to by scrolling to the end of the list).

I can't get it from the table since the datagrid is filtered.

Should I actually run a for next loop to count the rows, or even create a
datatable from the datagrid?

I am sure there must be a short cut!

 

[Scott M.]

What about using the table's defaultView.Rows.Count?

nope either loop or use the dataset.tables.rows.count. if it is filtered
like you say, you can still get the sum of the filtered row by passing in
the filter to the dataset and a count expression. there's more help on
this
topic on MSDN and code snippets to do it as well.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I discovered the hard way that the property "VisibleRowCount" of a datagrid
is ONLY that, the number of visible rows, NOT the number of populated
rows in
the datagrid.

I need the number of populated rows (i.e. the number of records the user has
access to by scrolling to the end of the list).

I can't get it from the table since the datagrid is filtered.

Should I actually run a for next loop to count the rows, or even create a
datatable from the datagrid?

I am sure there must be a short cut!

 

[PaulNaude]

Unfortunaterly, Rows is not a member of defaultview. That should have been
ideal!

What about using the table's defaultView.Rows.Count?

nope either loop or use the dataset.tables.rows.count. if it is filtered
like you say, you can still get the sum of the filtered row by passing in
the filter to the dataset and a count expression. there's more help on
this
topic on MSDN and code snippets to do it as well.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I discovered the hard way that the property "VisibleRowCount" of a datagrid
is ONLY that, the number of visible rows, NOT the number of populated
rows in
the datagrid.

I need the number of populated rows (i.e. the number of records the user has
access to by scrolling to the end of the list).

I can't get it from the table since the datagrid is filtered.

Should I actually run a for next loop to count the rows, or even create a
datatable from the datagrid?

I am sure there must be a short cut!

 

[PaulNaude]

BUT, I found ...defaultview.count which does exaclty that!!! Thanks for the
idea!

What about using the table's defaultView.Rows.Count?

nope either loop or use the dataset.tables.rows.count. if it is filtered
like you say, you can still get the sum of the filtered row by passing in
the filter to the dataset and a count expression. there's more help on
this
topic on MSDN and code snippets to do it as well.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I discovered the hard way that the property "VisibleRowCount" of a datagrid
is ONLY that, the number of visible rows, NOT the number of populated
rows in
the datagrid.

I need the number of populated rows (i.e. the number of records the user has
access to by scrolling to the end of the list).

I can't get it from the table since the datagrid is filtered.

Should I actually run a for next loop to count the rows, or even create a
datatable from the datagrid?

I am sure there must be a short cut!

 

[Scott M.]

HTH

BUT, I found ...defaultview.count which does exaclty that!!! Thanks for
the
idea!

What about using the table's defaultView.Rows.Count?

nope either loop or use the dataset.tables.rows.count. if it is
filtered
like you say, you can still get the sum of the filtered row by passing
in
the filter to the dataset and a count expression. there's more help on
this
topic on MSDN and code snippets to do it as well.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------



I discovered the hard way that the property "VisibleRowCount" of a
datagrid
is ONLY that, the number of visible rows, NOT the number of populated
rows
in
the datagrid.

I need the number of populated rows (i.e. the number of records the
user
has
access to by scrolling to the end of the list).

I can't get it from the table since the datagrid is filtered.

Should I actually run a for next loop to count the rows, or even
create a
datatable from the datagrid?

I am sure there must be a short cut!