I have 2 questions, which have presented me with about 2 days of lost work, trying to figure this out. 

1.  I have 2 gridviews.  Once a record is "Selected" in the top gridview1 then the gridvew2 is populated based on a Select Query.

 This works fine.  Each row of both gridviews allow sorting at the column header, execpt the one row in the gridview2 which is a templatefield . I need to sort by this field, but I cannot get it to work. Any and all help would be appreciated.

2. Next,  I would like to write a select statement that retrieves all records with a date of 24 months back. I can get it to work in vb express datagrid using DATEADD('M', -24, Now), but I cannot get it to work in ASP using vwd express

 Please help!
 

 Could you post the code for your gridview, and the code involving the select statement as well?

My  Select statement calls all the fields      -    Select *

Then I use the Row DataBound Sub to modifiy the data in one of the fields.  This iworks.

Then when trying to use sort or use filterexpression on that field, or sorting neither seem to work.

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

Here is what I think is happening.

The original query retrieves all rows including the field I want to change called "Dist" which is "0" in every record.

Although the gridview shows the properly calculated new number in the "Dist" field, I think the sort routine must only look at the query value of distance which was "0" instead of the gridview value which is populated through the RowDataBound Sub

If this is true then the solution would be to do the distance calcuation within the SELECT statement using an AS statement.  This seems to work but I cannot figure out how to put the 10 lines of calculations in the SELECT statement.. I tried using a VB Protected Function, but can't get it to work in the SELECT Statement either

AM I on the right track?

ANy Suggestions would be helpful

Thanks

 check this

 http://community.strongcoders.com/content/CSGridViewSortingPaging.aspx

 It seems the sorting in gridview uses the datasource, not the gridview data to sort. I do not see a way to sort the actual gridview data.

 There are 62 columns in my gridview, so here is the top and bottom of it:

The sort on the last column "Dist2" does not work. Nor does any filtering (using filterexpression)

   <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False"
        DataSourceID="AccessDataSource2" BackColor="#DEBA84" BorderColor="#DEBA84"
        BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2"
        ShowFooter="True" AllowSorting="True" Font-Size="X-Small">
        <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
        <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" Wrap="True" />
        <Columns>

 lots of normal boundfields

...... (bottom)

 <asp:BoundField DataField="Misc1" HeaderText="Misc1" SortExpression="Misc1" />
            <asp:BoundField DataField="Misc2" HeaderText="Misc2" SortExpression="Misc2" />
            <asp:BoundField DataField="Misc3" HeaderText="Misc3" SortExpression="Misc3" />
            <asp:BoundField DataField="Misc4" HeaderText="Misc4" SortExpression="Misc4" />
            <asp:TemplateField HeaderText="Dist2" SortExpression="lblDist2">
                 <ItemTemplate>  
                     <asp:label ID="lblDist2" runat="server"  Text='<%# DisplayDistance(Eval("GeoLat"), Eval("GeoLon")) %>' ></asp:label>
                </ItemTemplate>
             </asp:TemplateField>

 Souce and select statments

 <asp:AccessDataSource ID="AccessDataSource2" runat="server"
        DataFile="~/App_Data/Franklin.mdb"
         

        SelectCommand="SELECT  *  FROM Franklin WHERE (SaleDate &gt; ?) AND (SalePrice &gt; ?) AND (AudMap = ?) ORDER BY SalePrice DESC">
        <SelectParameters>
            <asp:Parameter DefaultValue="01/01/2006" Name="SaleDate" Type="DateTime" />
            <asp:Parameter DefaultValue="10" Name="SalePrice" Type="Decimal" />
                    
            <asp:ControlParameter ControlID="GridView1" Name="AudMap"
                PropertyName="SelectedValue" Type="String" DefaultValue="" />
               
                
          
        </SelectParameters>
    </asp:AccessDataSource>