I am having problem to make the records in the table sort in desc or asc order, when user click on the header.

One click on one of the header title such as (date) desc then another click back asc/ or another way round.

The records retrieve from SQL data via array method.
When the record appear in the page, the user can click any of the title to perform sorting base on the title.


Below are my XSLT.

How to sort by using the header No., DN and MM?
Hope someone can advice me on this please, thank you.
***********************************
<xsl:template match="/Array">


<table id="Table1" cellspacing="0" cellpadding="2" style="width:500px;">
<tr>
<th width="50" align="left">No.</th>
<th align="left">DN</th>
<th align="center">MM</th>
<center>
<input type="button" value="Edit" onClick="OpenMEditPanel(this); "></input>
</center>
</th>
<th align="center">
<center>
<input type="button" value="Select All" onClick="SelectAll(); "></input>
</center>
</th>
<th align="center">
<center>
<input type="button" value="Delete" onclick="DeleteMChecked();"></input>
</center>
</th>
</tr>


<xsl:for-each select ="NameMaster" >
<xsl:variable name ="count" >
<xsl:value-of select="position()"/>
</xsl:variable>
<xsl:variable name="TdN">
<xsl:value-of select ="DN"/>
</xsl:variable>
<xsl:variable name ="Tmm" >
<xsl:value-of select ="Mm"/>
</xsl:variable>


<tr>
<xsl:if test="position() mod 2 = 0">
<xsl:attribute name="bgcolor">#F4F4F4</xsl:attribute>
</xsl:if>
<td align="left" valign="top" id="No">
<xsl:value-of select ="position()" ></xsl:value-of>
</td>
<td align="left" valign="top" id="TdN">
<xsl:value-of select ="DN" ></xsl:value-of>
</td>
<td align="left" valign="top" id="Tmm">
<xsl:value-of select ="Mm" ></xsl:value-of>
</td>

<td></td>
<td align="center" valign="top" id="Select">
<input type="checkbox" name="chkBoxE" onclick="collectMChecked('{TdN}');" value="{DN}"></input>
</td>

</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>

****************************

SqlConnection myconn = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"];
string strcon = "SELECT * FROM table order by datecreated asc";
.........
.........
.........

try the code if it will be useful

Firstly, in answer to the OP:

There isn't anything in XSLT specifically that allows you to do what you are asking. You need to generate something from the XSLT that would either refresh the page (if we are talking web site), either in JavaScript, or just as a full href link.

There is a version of Saxon XSLT CE (Client Edition) which does add the idea of 'events' to XSLT, but I don't know how that works or if that helps, as you are probably running your XSLT on the server in the first place: http://www.saxonica.com/ce/index.xml

Secondly, Benjoo: I don't think some C# code telling him how to connect to a database is going to be helpful for an XSLT issue.

__________________
/- Sam Judson : Wrox Technical Editor -/

Think before you post: What have you tried?