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 StudentsTotalRANK() 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 T P · Answer

Hi If you need data to be ranked without gap then you have to use dense_rank method. select studentstotaldense_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(Totaltypeof(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