how to arrange values in descending order in asp.net?

Question

i got below dataset like 10 6 8 4 how to arrange them in descending order?

Sanjeeb Lenka · Answer

hi check this: str = select Sum(FEELERS) as FEELERS sum(INTUITORS) as INTUITORSsum(THINKERS) as THINKERSsum(SENSORS) as SENSORS from GivenAns where UserID =1; dt = ObjConn.GetDataTable(str); if (dt != null && dt.Rows.Count > 0) { dt.DefaultView.Sort = FEELERS desc;// sort applied to 1st column dt = dt.DefaultView.ToTable(); }

Hardik Patel · Answer

it's not working i am using datatable int f = 0; int i = 0; int t = 0; int s = 0; DataTable dt = new DataTable(); string str; str = select Sum(FEELERS)sum(INTUITORS)sum(THINKERS)sum(SENSORS) from GivenAns where UserID =1; dt = ObjConn.GetDataTable(str); if (dt != null && dt.Rows.Count > 0) { dt.ro.DefaultView.Sort = columnname desc; ds.Tables[0] = ds.Tables[0].DefaultView.ToTable(); //f = Convert.ToInt32(dt.Rows[0][0]); //i = Convert.ToInt32(dt.Rows[0][1]); //t = Convert.ToInt32(dt.Rows[0][2]); //s = Convert.ToInt32(dt.Rows[0][3]); //if (f > i && f > t && f > s) //{ // Label1.Text = f.ToString(); // Label5.Text = FEELERS; //} }

Sanjeeb Lenka · Answer

try like this ds.Tables[0].DefaultView.Sort = columnname desc; ds.Tables[0] = ds.Tables[0].DefaultView.ToTable();