A question about GridView sorting

scindy521

See the following data arranged by total score, but the total score is the same, so the rankings must be the same

Rank Teacher name Total score
1st Zhang San 85
2nd place Li Si 69
# 3 Wang Wu 69
# 4 Wu Liu 69
5th Liu Qi 68

How can I turn the data into:
Rank Teacher name Total score
1st Zhang San 85
2nd place Li Si 69
2 Wang Wu 69
# 2 Wu Liu 69
3 Liu Qi 68

yfacmilan

For records with the same total score, is there any requirement for sorting? It should be casual, but the value of the "rank" column is the same.

scindy521

Yes

yfacmilan

Set ds.defaultview.sort = "total score"&"desc"

In the OnRowDataBound process, put the total score into a viewstate,
When the next row is generated, the total score is compared with the viewstate. If they are the same, the ranking is the same as the value of rows (e.rowindex-1).
If they are not the same, add 1 to the ranking, and finally overwrite the total score of the new line with viewstate

scindy521

Can you make it clear

yfacmilan

Page_Load:
If Not IsPostBack Then
  viewstate ("total") = "" 'Initialize the total score
  viewstate ("piac") = 0 'Initial ranking
end if


rowdatabound:
If e.Row.RowType = DataControlRowType.DataRow then
   if e.Row.Cells (2) .Text = viewstate ("total") then
      e.row.Cells (0) .text = viewstate ("piac")
   else
      viewstate ("piac") = viewstate ("piac") + 1
      e.row.Cells (0) .text = viewstate ("piac")
   end if
   viewstate ("total") = e.Row.Cells (2) .Text
end if

The above code may not compile successfully, just understand the idea

xianzhe990

It seems to continue according to the total score, `` He has three total scores are the same ''
It seems like it should come out the same`

scindy521

There is still a compilation error...