Two table data in single collection

Posts   
 
    
Posts: 97
Joined: 29-Apr-2009
# Posted on: 14-Jul-2009 07:13:18   

Hello All,

i have two table:

one is : jobdetails and second is : jobapplication

in jobdetails table i have following fields

like

JobDetailID JobNumber ReferenceNumber Title and more fileds but these are main fields

in jobapplication table i have following fields

JobApplicationID JobDetailID CandidateID JobBoardID DateApplied

now i want to fetch data of these two table in the collection. so i can bind my gridview with Title(jobdetails table field) according to JobDetailID

please help me for these

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 14-Jul-2009 09:14:42   
Posts: 97
Joined: 29-Apr-2009
# Posted on: 31-Jul-2009 05:50:25   

Walaa wrote:

Please check my post here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=13769

Thanks Walaa for help me,