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,
Who is Participating?
CodeCruiserConnect With a Mentor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.