ASP.NET runtime environment website

 dotnetfiddle.net

How to find MAX date in SQL- Latest or highest date in SQL

 SELECT MAX(Date) 

               FROM Table

How to find Second highest date in SQL - Second newest date in SQL

 https://stackoverflow.com/questions/8590296/how-to-return-second-newest-record-in-sql

Difference between ienumerable and iqueryable in ASP.NET C# - interface

 https://www.c-sharpcorner.com/UploadFile/a20beb/ienumerable-vs-iqueryable-in-linq/

How to apply LINQ to datatable in ASP.NET C#

  DataTable dt2 = ApplyFiltersWithSorting(dt, sort, "");

            

            GridView1.DataSource = dt2.AsEnumerable().Where(r => r.Field<string>("PresentInstitutePostingDate") == "").CopyToDataTable();

reference:- https://stackoverflow.com/questions/19449449/how-i-can-filter-a-datatable-with-linq-to-datatable