How to sort dataset on basic of Date.

Question

How to sort dataset on basic of Date. Thanks in advance...

Kalai · Answer

Try this also. public DataTable sortDate() { DataTable dt = new DataTable(); dt.Columns.Add(Id typeof(int)); dt.Columns.Add(Date typeof(DateTime)); dt.Rows.Add(1 System.DateTime.Now); dt.Rows.Add(2 System.DateTime.Now.AddDays(1)); dt.Rows.Add(3 System.DateTime.Now.AddDays(2)); DataSet ds = new DataSet(); ds.Tables.Add(dt); ds.Tables[0].DefaultView.Sort = Date desc; DataTable dtSort = ds.Tables[0].DefaultView.ToTable(); return dtSort; }

Vulpes · Answer

Suppose you want to sort the first DataTable in the DataSet (ds) on a column called Date of type DateTime. Then you can do it as follows: DataTable dt = ds.Tables[0]; DataView dv = dt.DefaultView; dv.Sort = Date; dt = dv.ToTable();