Solved

Silverlight: Gridview Load according to another tables ID

Posted on 2013-05-16
3
343 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
  • 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

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…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
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…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

735 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