WPF/LINQ - Viewing Data from Associated Tables

Question

0.00/5 (No votes)

See more:

.NET3.5

Hi Guys, I have another question, this time i fear i may have over complicated it. Apologies in advance.

Brief Project Description: I have a Database containing two tables. The Customers Table has four fields, "Name", "Address", "Phone Number" and "Customer ID". The Jobs Table has three fields, "Customer ID", "Description" and "Due Date". I have also associated "Customer ID" in both tables with each other in the DataContext.dbml file.

Window1.xaml has two ListBoxes, the first displays all the Customers from the first table and the second ListBox displays all the Jobs from the second table.

At the moment the second table is displaying all the jobs, i would like to have it so that when a customer in Table 1 is selected, Table 2 displays only jobs with the same Customer ID as the one selected.

Question: Can i filter information from a table based on a information from another table?

Once again, thank you all for your help in advance,
Alex

Posted 9-Mar-10 0:37am

lxmyers

Add a Solution

2 solutions

Solution 2

That code is ASP.NET not WPF.

I can work up a solution either way , but what is it that need ASP.NET or WPF?

Posted 11-Mar-10 2:18am

Alaric Dailey

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kishore yallapragada · Accepted Answer · 2010-03-09T11:20:00

here is the code
In Jobs dropdown data bind

C#

    ddlJobs.DataSource =returnFilteredData(customerid) ;
    ddlJobs.DataTextField = "Description";
    ddlJobs.DataValueField = "Id";
    ddlJobs.DataBind();


public IEnumerable returnFilteredData(int customerid)
{
    //_db is the DataContext(your dbml)
    return from jobs in _db.tbl_JOBS
           where jobs.customerid == customerid
           select jobs;
}

Modify the code according to the control you are binding