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
Loading
Bilal SalasPosted Dec 20, 2010, 8:30 PM
I just want to know how to make sub-column in DGV columns....
that's it..
Sam HobbsPosted Dec 20, 2010, 5:08 PM
Your SQL statement can join two tables; do you know how to do that?
Do you need to be able to updae the data? If you do, then it is a little bit more work to do that using a bound form; my article explains how to create a bound form, but not when two tables are joined.