Re: DataTable made from JOINed tables and the DataAdapter wizard

Hi Gary,

I hadn't thought of that, thanks. It seems like a reasonable solution
but it's never a good idea to edit autogen'd code manually.

I was hoping there was some obvious way to do this easily, but it looks
like you've given it some thought as well and come up against the same
problem as me.

To William: I don't get what you're trying to say. You're saying to
create a DataRelation between the tables, but how do I display the data
from both tables into one DataGrid then? Like I said, all I know about
is using datarelations for master/detail where you have the first table
as parent and second as child, but not both combined.

I anyone at MSFT sees this, we'd all appreciate a quick answer to
enlighten us all.

Thanks to both of you for answering
--
Paul