Need to display dates in descending order from database table. How to write LINQ query in C# to display dates in descending order?
Eg:
21-03-2022
03-02-2022
17-04-2022
08-01-2022
31-01-2022
01-12-2021
Loading
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Check the following code:
- SqlConnection sqlConn = new SqlConnection("YourConnectionString");
- SqlCommand cmd = new SqlCommand("SELECT * FROM [dbo].[DOB]", sqlConn);
- cmd.CommandType = CommandType.Text;
- try
- {
- sqlConn.Open();
- DataTable dtValues = new DataTable();
- SqlDataAdapter da = new SqlDataAdapter(cmd);
- da.Fill(dtValues);
- // DateOfBirth is date column in database
- var sortedList = dtValues.AsEnumerable().OrderByDescending(d => d.Field
("DateOfBirth")).ToList(); - }
- catch (Exception)
- {
- throw;
- }
Sachin SinghPosted May 2, 2022, 9:22 AM