select lasted purchase according to date time and email c#

Question

 

 

hii friends,

how to get latest purchase itme in table

 

according to email and date time

 

like

[email protected]  22/11/2016  product1

 

[email protected] 23/11/2016 product2 

 

[email protected] 25/11/2016 product23

 

[email protected] 25/11/2016 product2

 

i want select  devendra purchase latest details according to date time and email id

 

thanks in advance