Solved

Silverlight: Gridview Load according to another tables ID

Posted on 2013-05-16
3
344 Views
Last Modified: 2013-05-16
Hi,

I have two entities/tables in my model.  The first one has master information regarding a customer.   The second table has detail and is related to the first table by the master's ID.

The second table's data is entered in a small gridview on the form and is saved according to the master ID but when I try to open the form again, all of the data loads except for the data in the gridview.

How do I load the gridview where master id equals detail id?
0
Comment
Question by:Annette Wilson, MSIS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
3 Comments
 

Author Comment

by:Annette Wilson, MSIS
ID: 39172601
I want to use the following query and call it after a window closes.  just don't know how to correctly write the query.

public IQueryable<Certification> GetCertByID()
        {
            return this.ObjectContext.Certification.Where(e =>  e.EvalChkList_ID = e.FORMData.ID);
        }

Open in new window

0
 

Accepted Solution

by:
Annette Wilson, MSIS earned 0 total points
ID: 39172887
public IQueryable<Certification> GetCertByID()
        {
            return this.ObjectContext.Certification.Where(e =>  e.EvalChkList_ID == e.FORMData.ID);
        }

Open in new window

0
 

Author Closing Comment

by:Annette Wilson, MSIS
ID: 39172890
Sorry,  I was jsut missing the == sign.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

751 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