[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

Bindingsource.filter

Hi,

I have 2 binding sources connected to 2 separate databases,

I filtered one of the binding sources, I'd like to know if I can use the results of the filter and apply it as a filter to the other binding source. Both databases have the same fields and data except one of them has a few extra fields.

Essentially, I want to filter the first binding source, obtain 10 records, select those same 10 records in the other binding source.

I know this is probably a very wrong way of doing things, but right now it's the fastest solution I can think of.

Thank you,
0
FCapo
Asked:
FCapo
1 Solution
 
CodeCruiserCommented:
Is your bindingsource connected to a datatable/dataset? You can directly filter the DataView of your datatable and then loop through the result to filter the other datatable.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now