datagrid 1:1 relationships display

I have 2 tables from a sql server who have a 1:1 relationship. When I display the rows in a datagrid control (using a dataset with 2 tables in it and one relationship) I end up with a grid that displays one row that has a plus sign, and behind that sign there is always just one record from the second table. My question is: is there a way to display these 1:1 records side by side in only one row in the grid, avoiding the hierarchal behavior of the grid?
I know I can use a sql join and use only one table instead of two but that is not a perfect alternative.
I'm using vb.net 2003 and sql server 2000.
Thanks in advance.
Leo Leys

[705 byte] By [LeoLeys] at [2007-12-16]
# 1
No the DataGrid or DataGridView support being databound to two different tables. The workaround you mention is one way. The other way is to create a DataView that loads both DataTables into one table (basically performing a Join except on the client side. Note that these records are not updateable)

-mark
Program Manager
Microsoft
This post is provided "as-is"

MarkRideout at 2007-9-9 > top of Msdn Tech,Windows Forms,Windows Forms General...