how to sort student by Total degrees as 1st - 2nd - 3rd

lamasat lamasat

I have Table of student's Degrees , I want sort student by Total degrees as 1st - 2nd - 3rd ...

and if Two Or more than one Total is same , I want display 3rd -3rd like that >>

6 Replies

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

ketan borsdiya10y ago
Hi Lamasat,
You need to create object like below way,
OleDbDataAdapter ad5 = new OleDbDataAdapter();
lamasat lamasat10y ago
What is wrong with this code :
OleDbDataAdapter ad5 = new OleDbDataAdapter
("select name , total ,dense_rank() over(order by total desc) as Ranking from test ", Program.cn);
DataSet ds5 = new DataSet();
ad5.Fill(ds5, "test");
wrong is :Syntax error (missing operator) in query expression
please help me
Midhun Tp10y ago
Hi,
If you need data to be ranked without gap, then you have to use dense_rank method.
select students,total,dense_rank() over(order by total desc) as Ranking from tablename
Please check below link for understanding difference between RANK() and DENSE_RANK() -
http://www.besttechtools.com/articles/article/sql-rank-functions
ketan borsdiya10y ago
Hi Lamasat,
If you need in coding side then follow below method,
Add below method in your class,
public DataTable CalculateRank(DataTable dt, string column)
{
var dtNew = (from row in dt.AsEnumerable()
orderby row.Field(column) descending
select row).CopyToDataTable();
dtNew.Columns.Add("Ranking");
int rank = 1;
for (int i = 0; i < dtNew.Rows.Count - 1; i++)
{
dtNew.Rows[i]["Ranking"] = rank;
if (dtNew.Rows[i][column].ToString() != dtNew.Rows[i + 1][column].ToString())
rank++;
}
dtNew.Rows[dtNew.Rows.Count - 1]["Ranking"] = rank;
return dtNew;
}
After add this you may use like below,
DataTable dt = new DataTable();
dt.Columns.Add("Students", typeof(string));
dt.Columns.Add("Total",typeof(int));
dt.Rows.Add("A", 300);
dt.Rows.Add("B", 350);
dt.Rows.Add("C", 400);
dt.Rows.Add("D", 300);
var rankDt = CalculateRank(dt, "Total");
ketan borsdiya10y ago
Hi lamasat,
Use below query in sql for your output,
select Students,Total,RANK() over(order by Total desc) as Ranking from
lamasat lamasat10y ago
more clear , like this