How To sort Gridview Column bt Time Only

rao965 · May 22nd, 2009, 04:30 AM

Hi,
I have a gridview on page log it gets populated from a sql server db, however one of the columns (ReportTime) displays the time when the report was added to the db, and in one day we have many reportstherefore I need to sort this column (ReportTime) by time only.

i would be grateful is some one kindly help me to solve this problem.

Code:

 
 <asp:GridView ID="grdReports" runat="server" AutoGenerateColumns="False" 
          DataKeyNames="ReportId" AllowPaging="True" DataSourceID="odsReport" 
           AllowSorting="True" CssClass="Results" PageSize="100">
            <AlternatingRowStyle CssClass="AlternateRow" />
                 <Columns>
                    <asp:BoundField HeaderText="ID" DataField="ReportID"  
                              SortExpression="ReportID" />
                    <asp:TemplateField FooterText="Title" HeaderText="Title" 
                              SortExpression="ReportTitle">
                                <ItemTemplate>
                                    <asp:Label ID="lblReportTitle" runat="server" Text='<%# Bind 
                                                  ("ReportTitle") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                    <asp:TemplateField FooterText="Date" HeaderText="Date"  
                                SortExpression="ReportDate">
                                <ItemTemplate>
                                    <asp:Label ID="lblReportDate" runat="server" Text='<%# Eval
                                        ("ReportDate", "{0:dd MMM yyyy HH:MM}")%>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
 </asp:GridView>

Thanks
Rao