How can i calculate rank of Student based on his marks MVC

You have to done these ranking stuff on database level using row_number,rank,dense_rank.

You can find example on this

http://www.itbunch.com/sql/find-nth-highest-salary-using-dense_rank-function-in-sql/334

0

k i will try it.. Thanx.. :)

0

Using store procedure

0

Thanx for ur rly guys. i got rank in sql but how can i pass it to controller.

0

You can do this stuff from database side applying Rank() or dense_rank() or ROW_NUMBER() function on mark field.

You can send extra alias field from your sql query.

Like this in sql query

ROW_NUMBER() OVER ( ORDER BY tbl_Student.Mark) AS Rank

0

Get Rank from Sql and then display on View using Model

0

i am Developing Exam software in mvc 5. i want to show the student rank . so how can i display it???

0

this should be done in sql not in MVC View

0