Use a sql select query similar to this….
select * from EmployeeDetails ed
left join EmployeeEntries ee on ee.EmpId = ed.EmpId
Note that this query will return all entries for each employee and each record will have the employee details as well. That means the employee details will be repeated for each entry the have in the EmployeeEntries table
Then use a web server control that handles grouping such as the ListView, for more info, read this….
http://msdn.microsoft.com/en-us/library/system.windows.forms.listview.groups(v=vs.110).aspx
Which will produce something similar to this…
Your question is too abstract and there’s a lot to cover but if you still don’t get how to achieve this, then read this tutorial…
https://web.archive.org/web/20210301194237/https://www.4guysfromrolla.com/articles/091708-1.aspx
Hope it helps,
Leo.
1
solved showing records from two sql table alternatively [closed]