Loop through database data in reverse (backward) order in View page in ASP.Net Core MVC

Question

Hi GuysIs it possible to iterate over data from the last data in ASPNet Core MvcIm trying to show data from the last data in database I mean is when data looping it will show all data on table from the last datafor example is  all the looping above is just retrun value 123 etcI want is when the looping running it will get end result 321I use the query belowSelect  From Anggota Order By KodeAnggota Desc foreach var Petugas in Model orfor int i  0 i lt ModelRowsCount i

dharmendr · Accepted Answer

Hi trisetia302Check this example Now please take its reference and correct your codeDatabaseI have made use of the following table Customers with the schema as followsI have already inserted few records in the tableYou can download the database table SQL by clicking the download link belowDownload SQL fileNamespacesusing SystemDatausing SystemDataSqlClientControllerpublic class HomeController  Controller     GET Home    public IActionResult Index            DataTable dt  new DataTable        string constr  34Data Source192168010SQL2014Initial CatalogAjaxSamplesUIDsaPWDpass12334        using SqlConnection con  new SqlConnectionconstr                    string query  34SELECT  FROM Customers ORDER BY CustomerId DESC34            using SqlCommand cmd  new SqlCommandquery                            cmdConnection  con                using SqlDataAdapter sda  new SqlDataAdaptercmd                                    sd

Loop through database data in reverse (backward) order in View page in ASP.Net Core MVC

Company

Explore

Follow us

Contact Us