how to sort data in dataset without dataview by descending o

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