Relational Data in a DataGrid

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Tim Frost Tue, 18 Apr 2006 08:21

#48

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads