I have written a query in SQL server 2008 R2 and it is:
select *, Row_Number() Over(Order By Total_Marks DESC) as Rank from tbl_Ranking_System order by Rank
In this query, I have taken variable called "Rank" and I am getting the value as expected. Now I am trying to map this Rank to a Column I have taken in the gridview. I am not able to see any value in the Rank column in the gridview. But when i execute in back end i am able to see the result. Please help me in mapping this Rank to the gridview column Rank.