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

Question

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 >>

ketan borsdiya · Answer

Hi lamasat, Use below query in sql for your output, select Students,Total,RANK() over(order by Total desc) as Ranking from

ketan borsdiya · Answer

Hi Lamasat, You need to create object like below way, OleDbDataAdapter ad5 = new OleDbDataAdapter ();

lamasat lamasat · Answer

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 Tp · Answer

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 borsdiya · Answer

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[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");

lamasat lamasat · Answer

more clear , like this