Sort date in arraylist

Question

0.00/5 (No votes)

See more:

Hi all,

I have gather a data which contain date,desc,status etc.
The data that I retrieve is not sorted.
How can I sort data by in arraylist by date?
My date format is M/d/yyyy

My sample data from arraylist:

SQL

Date      Status   Code      Description
1/1/2013  B        12010     Tunggakan
9/14/2013 R        11030     Cukai Semasa
7/1/2013  B        11010     Waran

The result should be:

SQL

Date      Status   Code      Description
1/1/2013  B        12010     Tunggakan
7/1/2013  B        11010     Waran
9/14/2013 R        11030     Cukai Semasa

Or can I put sort bydate asc in my query? Which one is the best approach?

Posted 2-Oct-13 15:34pm

Luiey Ichigo

Add a Solution

1 solution

Add a Solution

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

_Damian S_ · Accepted Answer · 2013-10-02T15:49:00

Solution 1

Yes, the best approach is to let your database do what it's best at - retrieving, sorting, grouping data... all usually more efficient in your database than anywhere else.

Throw the sort clause onto your query and it should be all good.

Posted 2-Oct-13 15:49pm

_Damian S_

Comments

Luiey Ichigo 2-Oct-13 23:25pm

Yup sir,

I guess the best approach is sort automatically when query the data.tq

Sergey Alexandrovich Kryukov 3-Oct-13 1:12am

Good idea, a 5.
Besides, OP should not use ArrayList, it is obsolete...
—SA

Sort date in arraylist

1 solution

Solution 1

Add your solution here

Preview 0

Sort date in arraylist

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us