[Solved] showing records from two sql table alternatively [closed]


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…

https://web.archive.org/web/20161106210140/http://aspnet.4guysfromrolla.com/images/ListView/05.01.png

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]