How to generate position from a table using EF

pius joshua

Good day All, I need your help, I want to generate Position from a list of record for a particular user

//I have a table Named Mark
MarkID UserId SubjectName TotalScore
1 20 English 60.00
2 21 English 70.00
3 20 Maths 80.00
4 21 Maths 80.00
// From the Table above i want to automatically generate Subject position for each each user in a gridview like this
MarkID UserId SubjectName TotalScore Postition
1 20 English 60.00 2
3 20 Maths 80.00 1
How do i automatically generate the subject position on it
Normally this is what i have tried so far to get the list of a particular record
var acc = from c in cdc.Marks where c.userId = "20" select c).tolist();
gridview1.datasource = acc;
gridview.datindind();
//The above code only generate the student records and displays it on a gridview but automatically generating Position without is what i am looking for.. Please your help is really needed..
Thanks in advance

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
Hi
Try the below query
var query=cdc.Marks.where (t=>t.userId = "20").Select((t,i)=>new {
Postition =i,
t.MarkID,
t.UserId ,
t.SubjectName,
t.TotalScore
});
Nitin Sontakke10y ago
declare @Marks table
(
MarkID integer not null
,UserId integer not null
,SubjectName varchar(10) not null
,TotalScore decimal(10, 2)
)
insert into @Marks values
(1, 20, 'English', 60.00),
(2, 21, 'English', 70.00) ,
(3, 20, 'Maths', 80.00),
(4, 21, 'Maths', 80.00)
select MarkId, UserId, SubjectName, TotalScore, row_number() over (partition by UserId order by UserId, SubjectName, TotalScore) [Position]
from @Marks
pius joshua10y ago
the table is named Marked in the SQL,How do i get theRANKING FUNCTIONS in SQL Server.
Thanks
Nitin Sontakke10y ago
If you are saying you table named Mark in SQL Server, try looking into RANKING FUNCTIONS in SQL Server and you will have the answer.
If not sure, please do let me know.