Posted on 2012-09-17
Last Modified: 2012-09-18

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,
Question by:FCapo
    1 Comment
    LVL 83

    Accepted Solution

    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.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video discusses moving either the default database or any database to a new volume.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now