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

how to sort data in dataset without dataview by descending o

Answers (2)