Thank you for that nice solution!
(here is the final version)
Rank.aspx.cs
protected void Page_Load(object sender, EventArgs e)
{
MyAdoHelper.SetRanks("db.mdf", "select player, allPoints from ranking");
}
MyAdoHelper.cs
public static void SetRanks(string fileName, string sql)
{
DataTable dt = ExecuteDataTable(fileName, sql);
int rank = 1;
string player = "";
DataView dv = new DataView(dt, "","allPoints DESC", DataViewRowState.CurrentRows);
foreach (DataRowView dr in dv)
{
DataRow row = dr.Row;
int num = 1;
foreach (object myItemArray in row.ItemArray)
{
if (num == 1)
{
player = myItemArray.ToString();
string sqlrank = "update ranking set rank='" + rank + "' where player='" + player + "'";
MyAdoHelper.DoQuery("db.mdf", sqlrank);
rank++;
num++;
}
}
}
}