Find the earliest Date time Element in a Dataset

Question

0.00/5 (No votes)

See more:

I want to compare the date time elements of rows of a dataset and my requirement something like :

i want to fetch the all the dates for all i number of rows returned by the query and store in an array or list or something(what ever you suggest?). Then compare these dates and find the ItemArray which is the earliest/newest of all the elements.

For Instance , below gives me a Data Set row count of 5

C#

ds.Tables[0].Rows[i]ItemArray["DateTime"].ToString()).ToString("dd/MM/yyyy");

and i get following dates
05/07/2012
23/06/2011
13/11/2013
24/04/2014
30/01/2014

Once I fetch the dates from the dataset , I want to compare these and find which is the earliest one.

Here I should get 24/04/2014 as my result as it is the newest.

Posted 24-May-14 0:14am

Kunal Ved

Updated 24-May-14 0:16am

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Answer 1 · 2014-05-24T00:44:00

Solution 1

C#

var minDate =ds.Tables[0].AsEnumerable().Select(record => record.Field<datetime>("DateTime")).Max();

Posted 24-May-14 0:44am

DamithSL

Updated 24-May-14 0:47am

v3

OriginalGriff · Answer 2 · 2014-05-24T00:46:00

First things first: that isn't your code, as that code (a) won't compile and (b) is pretty pointless even if you fix the compilation errors - what do you expect ToString with a date related format string to do when given a string to play with? Because format it as a DateTime is not in the list of things it will do...

DataRow values and DataRowCollections are not directly usable by the sort facilities in C# - you really need to extract the data into a class (and a collection of that class) that can sort easily, and keep the data in it's native format for that - in this case that means DateTime values, not strings as they are much much easier to sort.

So look at your code, work out what data you are feeding into the DataTable and consider creating a class that holds that information. Then load a collection of that from the DataTable, and sort the collection.