How to sorting date column in gridview using asp.net c#

Question

HiHere i have a gridview control that contains date value columni want to sort gridview data by date column For examplethis is Normaly how i inserting data in databaseSno      Date                   News1          21 June 2016       News12          21 May 2016       News43          26 May  2016       News34         02 Jan 2016       News25            16 Nov 2016        News66            21 Jan 2016       News8 but in grid view i want to show shorted data by datelike Sno      Date

Shashikant · Accepted Answer

Please refer below linkshttpwwwcodeprojectcomTips663532HowtoPerformSortingInGridviewinASPNETwwwcodeprojectcomQuestions375849SortinginGridviewAspnetCsharp

cywa · Answer

Hi allI found the answer forHow to sorting date column in gridview using aspnet c Shashikant Answer also an another method of solving this questionThank you Shashikant and refer the code below SqlCommand cmd  new SqlCommand34SELECT  FROM tblNewsUpdate ORDER BY CONVERT Datetime NewsDate103 ASC34using this sql query  solved to sort date in grid viewThank you all for help me to find the answerRegards cywa

How to sorting date column in gridview using asp.net c#

Company

Explore

Follow us

Contact Us