Member Avatar for winkler

Hi
I consider myself fairly new to VB.NET, so maybe you could help me here.
I have a bindingSource which is bound to a dataset. I have a filter on the bindingsource. My problem is that when I add a new row, with BindingSource.AddNew, even if it does not match the filter criteria, it still isn't filtered out.
Could it be that the bindingsource filter never filters out detached rows? If so, what can I do in this situation?

Example

Me.TblStempelkarteBindingSource.Filter = "Month = " & getCurrentDate.Month & _
                                                " AND  Day = " & getCurrentDate.Day & _
                                                " AND  Year = " & getCurrentDate.Year

I add a new row to the BindingSource and then do BindingSource.Count. The count always includes the added row, even if the fields do not match Month/Day/Year of my filter.
Thank You!

  • 2 Contributors
  • 4 Replies
  • 803 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by winkler
Member Avatar for Mariandi

you need to filter your dataview again

Member Avatar for winkler

I removed the filter and then applied it again. Doesn't seem to work. Any other suggestions?

Member Avatar for Mariandi

Can you provide a bit more code? Like the whole function?

Member Avatar for winkler

I didn't find a solution to this problem, but I was able to work around it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.