how to sort data in dataset without dataview by descending o

Question

how to sort numerical data by descending order in dataset without dataview and database query ???

Vulpes · Answer

Here's one way of doing it using LINQ: using System; using System.Data; using System.Linq; class Program { static void Main() { var dt = new DataTable(); dt.Columns.Add(Name); dt.Columns.Add(Age typeof(int)); dt.Rows.Add(Fred 45); dt.Rows.Add(Mahesh 35); dt.Rows.Add(Janet 25); dt.Rows.Add(Rajesh 55); DataRow[] rows = dt.Rows.Cast () .OrderByDescending(r => (int)r[Age]) .ToArray(); foreach(DataRow row in rows) { dt.Rows.Add(row.ItemArray); dt.Rows.Remove(row); } // check it worked foreach(DataRow row in dt.Rows) Console.WriteLine(String.Join(  row.ItemArray)); Console.ReadKey(); } } The output is: Rajesh 55 Fred 45 Mahesh 35 Janet 25

mayur pandit · Answer

Cooool.................. DataView view = ds3.Tables[0].DefaultView; view.Sort = FINAL_RESULT DESC; DataTable d1 = new DataTable(); d1 = view.ToTable(); ds3.Reset(); ds3.Tables.Add(d1);