DataGrid with Relations

Feb 8 2006 1:05 PM
Hi, i´m using ASP.NET 2.0 and I have a problem with a datagrid. I have, for example two tables: PERSON with the columns FIRSTNAME, LASTNAME and ADDRESS_ID ADDRESS with the columns ADDRESS_ID and PLACE There´s a relation between these tables. The key ist ADDRESS_ID. Now I have a DataSet with these two tables and the DataRelation in the DataSet is set correctly. How can I show a record of the PERSON table with the relation to the ADDRESS table? So, what I want is to see something like this. FIRSTNAME LASTNAME PLACE Michael Smith London Can anybody help me, I´m a newbie Thanks Rupert