Click here to Skip to main content
16,005,178 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
hi to all,

i have more tables in MYSQL

1st datatable with columns like, Deptno studentNo studentName

2nd datatable with columns like, Deptno DeptName DeptAddress

3rd datatable with columns like,
Deptno staffname staffAddress staffQulification

add data to both the tables Dynamically

and merge these tables into one table and display it in Grid view
as
Deptno studentNo studentName
Deptno DeptName DeptAddress
Deptno staffname staffAddress staffQulification

Note:
Columns should be vary like one table have 5 columns and another table have 10 columns.But i need to display in single gridview or somedataviewer.

Thanks in advance
Sundaramoorthy.B
Posted
Comments
Sergey Alexandrovich Kryukov 8-Aug-12 0:43am    
And..? (Not a question)
--SA
Santhosh Kumar Jayaraman 8-Aug-12 0:48am    
You want to merge all columns where deptno is same?
sundaramoorthy.b 8-Aug-12 2:27am    
yes, but one by one.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900