PC Review Forums Newsgroups Microsoft DotNet Microsoft Dot NET Compact Framework display columns from 2 different tables in the same datagrid

Reply

display columns from 2 different tables in the same datagrid

 
Thread Tools Rate Thread
Old 04-02-2005, 11:13 AM   #1
=?Utf-8?B?U2l0YXI=?=
Guest
 
Posts: n/a
Default display columns from 2 different tables in the same datagrid


Hello,

I need to display 2 tables in the same datagrid.
I've been playing with this http://support.microsoft.com/kb/319076/EN-US/
which works great except for a few things:
- I know no way to format the displayed data (I have some datetime columns)
- sorting does not work either
- I can't replace null values with what I want

I would like to avoid the hassle of merging my 2 datatables into a 3rd one
and then displaying it. Any changes in this datatable I will have to manually
update my 2 original datatables.

Eventually I have to implement this on a WinCE device so I'm also concerned
with performance issues.

This seems like a common issue (having IDs + data in one table and the
matching description + ID in another table and needing to display the
description + data itself) but I haven't found anything good but this MS
article.

Anyone has any ideas on how to achieve this?

Thanks,
Sitar.

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off