Relational Data in a DataGrid

Article View: borland.public.csharpbuilder.winforms.controls.using

Article #48

Back to borland.public.csharpbuilder.winforms.controls.using Previous Next

#48

From: Tim Frost
Date: Tue, 18 Apr 2006 08:21

22 lines
1713 bytes

Hi,

I have a really simple data base, that has a main table and a couple of 
lookup tables.  This is all stored in XML and accessed using a DataSet.

I want to display the join of the main table and the lookup tables in a 
DataGrid - so the integer values in the main table is replaced with the text 
from the lookup tables.

Is there an easy way to do this?

Is  there a way I can write SQL queries on the dataset I have loaded from 
the XML file?  (I think I could do this with a DataAdaptor and a real DB 
connection, but I don't have one.)

I have set up data relations between the main and lookup tables.

I have also setup a drop down control to use the lookup tables.

Thanks

Tim

Technical Details

Message-ID: <4444a17b$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news1.google.com!atl-c05.usenetserver.com!news.usenetserver.com!peer01.west.cox.net!cox.net!newshub.sdsu.edu!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1eff3c,b1806cf59d9fb843,start
X-Google-Attributes: gid1eff3c,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Tim Frost" <Tim@FrostNet.ltd.uk>
From: "Tim Frost" <Tim@FrostNet.ltd.uk>
Newsgroups: borland.public.csharpbuilder.winforms.controls.using
Subject: Relational Data in a DataGrid
Date: Tue, 18 Apr 2006 09:21:06 +0100
Lines: 24
Organization: FrostNet Ltd
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: 86.130.15.31
Message-ID: <4444a17b$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1145348475 86.130.15.31 (18 Apr 2006 01:21:15 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news1.google.com!atl-c05.usenetserver.com!news.usenetserver.com!peer01.west.cox.net!cox.net!newshub.sdsu.edu!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail