Sorting Date Column in Active.Controls.Grid in 1.0
Hello,
I am using ActiveWidgets version 1.0 to do the following:
I am loading xml data into an Active.Controls.Grid object. My first column is of type Date (in mm/dd/yyyy hh:mm:ss format). The problem is I can not sort the dates properly.
my xml data is the folloing:
...
<result>
<statuscomments>row 1</statuscomments>
<statusactiondate>11/15/2006 01:12:36</statusactiondate>
</result>
<result>
<statuscomments>row 2</statuscomments>
<statusactiondate>11/15/2006 02:14:06</statusactiondate>
</result>
<result>
<statuscomments>row 3</statuscomments>
<statusactiondate>11/16/2006 05:46:04</statusactiondate>
</result>
<result>
<statuscomments>row 4</statuscomments>
<statusactiondate>01/02/2007 08:49:25</statusactiondate>
</result>
...
if sort them in Ascending order the grid displays them as
row 4
row 1
row 2
row 3
the XML snippets has the correct Ascending order. How can I have them sorted in correct order.
Thanks in advance for your help,
MK
I am using ActiveWidgets version 1.0 to do the following:
I am loading xml data into an Active.Controls.Grid object. My first column is of type Date (in mm/dd/yyyy hh:mm:ss format). The problem is I can not sort the dates properly.
my xml data is the folloing:
...
<result>
<statuscomments>row 1</statuscomments>
<statusactiondate>11/15/2006 01:12:36</statusactiondate>
</result>
<result>
<statuscomments>row 2</statuscomments>
<statusactiondate>11/15/2006 02:14:06</statusactiondate>
</result>
<result>
<statuscomments>row 3</statuscomments>
<statusactiondate>11/16/2006 05:46:04</statusactiondate>
</result>
<result>
<statuscomments>row 4</statuscomments>
<statusactiondate>01/02/2007 08:49:25</statusactiondate>
</result>
...
if sort them in Ascending order the grid displays them as
row 4
row 1
row 2
row 3
the XML snippets has the correct Ascending order. How can I have them sorted in correct order.
Thanks in advance for your help,
MK
January 26,