Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get record count
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
VB 9.0
Miscellaneous
Thread ID:
01379559
Message ID:
01379582
Views:
19
>Hi All,
>
>How do I get the record count of the Data Table after the filter was applied using BindingSource:
>
>
>'remove any filters first
>DsPPBindingSource.RemoveFilter()
>'apply filter
>DsPPBindingSource.Filter = "cPPStatus = 'Approved' "
>'This returns the original record count before filter was applied
>RowCount.Text = Me.BindingContext(DsPP, "dtPP").Count()
>
>

Something like this should work:
int count = DsPPBindingSource.DefaultView.Count;
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Reply
Map
View

Click here to load this message in the networking platform