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

