Hi,
Please refer below code.
C#
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[4] { new DataColumn("Id"), new DataColumn("Name"), new DataColumn("Sid", typeof(int)), new DataColumn("Age", typeof(int)) });
dt.Rows.Add("1", "xxx", 19, 20);
dt.Rows.Add("2", "yyy", 18, 20);
dt.Rows.Add("3", "zzz", 18, 20);
dt.Rows.Add("4", "aaa", 01, 20);
dt.Rows.Add("5", "aaa", 18, 20);
dt.DefaultView.Sort = "Sid DESC";
DataTable dtResult = dt.DefaultView.ToTable();
VB
Dim dt As New DataTable()
dt.Columns.AddRange(New DataColumn(3) {New DataColumn("Id"), New DataColumn("Name"), New DataColumn("Sid", GetType(Integer)), New DataColumn("Age", GetType(Integer))})
dt.Rows.Add("1", "xxx", 19, 20)
dt.Rows.Add("2", "yyy", 18, 20)
dt.Rows.Add("3", "zzz", 18, 20)
dt.Rows.Add("4", "aaa", 1, 20)
dt.Rows.Add("5", "aaa", 18, 20)
dt.DefaultView.Sort = "Sid DESC"
Dim dtResult As DataTable = dt.DefaultView.ToTable()
I hope this will help you out.
