Nabil Nawaz

Nabil Nawaz

  • NA
  • 200
  • 32.3k

Getting Next / Previous Row Record Of Specific User

May 25 2017 5:49 AM
I've a table where record of different users is saved. I differentiate records based on UserID in the table and have separate mechanism for identifying records uniquely. every user is shown his created records only.

now i want to get next record of user or prev record of the user. means when i click next button in my application i get next record of logged in user.
how can i do it in Entityframework OR T-SQL ?

see the picture below. My UserID is 1 in User_Reg_Id_Num_02 column. when i've opened the record no 32 and when i click next i should get record no 36 because it's the next record of currently logged in user.
 
 
 

Answers (3)