DataGrideView Question

Question

Hi
I want to make a DGV bind from database for Employees information table
so every column in the DGV will take column from the table and I did that
but the problem is there is a field in the Employee information(column) named Address
so it will take integer number and it is a foreign key to primary key in address table
so every Employee has one row in address table
so problem is here>>>>I want to make in the column address in Employee DGV also sub-columns contain the information of address table


please just tell how to make that from the DGV side but from the DB side it doesn't matter.

like below:
---------------------------------------------------------------------
ID|first name|last name|age|              address           |Gender |
  |          |         |   |Street|Building|City|Phone|Email|       |
---------------------------------------------------------------------
1 |Jhon      |Smeth    |34 |tefa  | stim   |city|0975.|[email protected]|male   |

so please how can I do that???


thanks