Mark Tabor

Mark Tabor

  • 927
  • 1.7k
  • 319.2k

Getting Data from two tables

Jun 12 2016 11:28 AM
I have two tables one of USERS and second of UserFiles just like below 
 
UserTable 
 UserId Name Email Phone
 1 New New@new.co    0909000
 2 Old old@old.com 0998099
 
UserFiles
 FileID(Primary) UserID(Foreignkey) FileNameDateCreated  Active
 1 1 MyResume.Doc 2/2/2016 true
 2 1 Image.JPG 2/17/2016 true
 3 1 Cover.Docx 2/20/2016 true
 4 2 Card.png 1/1/2017 true
 
Now I have a gridview I want to show one File for each user I mean the latest file for this user According to datecreated for example here I have three files for userid=1 but i just want to show the Cover.Docx because it is latest one for this user according to datecreated Field.
I want this record how to do that
 RecordID UserId FileName Email Phone
 1 1 Cover.Docx New@new.co 0909000
 2 2card.png  old@old.com 0998099
I want that record how to achived that  

Answers (8)