I'm struggling trying to sort by date, this is my code:
SelectCommand="SELECT s.id, s.fecha as fecha, e.descri as entrenamiento, d.descri as modalidad
FROM SESION_ENTRENAMIENTO
WHERE (s.id_usuario = 1)
ORDER BY s.fecha"
FilterExpression="fecha like '{0}%' and entrenamiento like '{1}%' and
modalidad like '{2}%' and meteorologia like '{3}%' and sensaciones like '{4}%'">
<FilterParameters>
<asp:ControlParameter Name="fecha" ControlID="ddlFecha"
PropertyName="SelectedValue" />
and:
<asp:DropDownList ID="ddlFecha" DataSourceID="dsPopulateFecha"
AutoPostBack="true" DataValueField="fecha" runat="server" AppendDataBoundItems="true">
< ...
Go to the complete details ...