Hi,
    Posted this thread on ASP.Net but have had no answers as yet, hopefully someone can assist me as i am now at a dead end...
Overview is I am trying to return a filtered set of data dependant upon a column selection and then giving a partial entry of whats required i.e. Column = CourseID, Search Expr = "ms"

I have had partial success by adding a second objectdatasource and connecting it to my business logic using the code below:

<Code>
Sub BindData(ByVal myCol As String, ByVal myFilter As String, ByVal myInt As Integer)
            Try
                If myCol = "" And myInt = 1 Then
                    GridView1.DataSourceID = ""
                    GridView1.DataSource = ObjectDataSourceCRS
                    GridView1.DataBind()
                End If
                If myCol = "CourseID" Then
                    GridView1.DataSourceID = ""
                    GridView1.DataSource = ObjectDataSource1
                    GridView1.DataBind()
                End If

            Catch exc As Exception        'Module failed to load
                ProcessModuleLoadException(Me, exc)
            End Try
        End Sub
<\Code>

This has caused some other issues:
1. The returned filter only shows one record, when infact it should show more (why one???)
2. When resetting the filter to show all records the paging function fails with the following error:
<error>
A critical error has occurred.
The GridView 'GridView1' fired event PageIndexChanging which wasn't handled.
</error>

I am getting closer to resolving this, assitance in sorting the above errors would be greatly appreciated.

Regards..
Peter.

Vladan,
      Here's the aspx code as requested..

<ascx start>

<%@ Control language="vb" Inherits="HomeProd.Modules.Tmgr_CourseType.ViewTmgr_CourseType" CodeFile="ViewTmgr_CourseType.ascx.vb" AutoEventWireup="false" Explicit="True" %>
<%@ Register TagPrefix="dnn" TagName="Audit" Src="~/controls/ModuleAuditControl.ascx" %>
<table cellspacing="0" style="text-align: left">
    <tr>
        <td>
            <p align="center">
                <font color="maroon" size="4"><strong>Filter On</strong></font>
            </p>
        </td>
        <td>
            <p align="center">
                <font color="maroon" size="4"><strong>Text to Filter On</strong></font>
            </p>
        </td>
        <td>
        </td>
    </tr>
    <tr>
        <td>
            <div align="center">
                <asp:DropDownList ID="DDLCol" runat="server">
                </asp:DropDownList></div>
        </td>
        <td>
            <div align="center">
                <asp:TextBox ID="txtFilter" runat="server" Width="129px"></asp:TextBox></div>
        </td>
        <td>
            &nbsp;
            <asp:Button ID="btnFilter" runat="server" OnClick="btnFilter_Click" Text="Filter" />
            &nbsp;<asp:Button ID="btnClear" runat="server" OnClick="btnClear_Click" Text="Reset" />
            &nbsp;</td>
    </tr>
</table>
&nbsp;&nbsp;&nbsp;
<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="Vertical" AllowPaging="True" AutoGenerateColumns="False" Font-Size="Smaller" DataSourceID="ObjectDataSourceCRS">
    <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
    <RowStyle BackColor="#EFF3FB" />
    <EditRowStyle BackColor="#2461BF" />
    <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
    <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
    <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
    <AlternatingRowStyle BackColor="White" />
    <Columns>
        <asp:BoundField DataField="CourseID" HeaderText="CourseID" SortExpression="CourseID" />
        <asp:BoundField DataField="CourseName" HeaderText="CourseName" SortExpression="CourseName" />
        <asp:BoundField DataField="CourseVendor" HeaderText="CourseVendor" SortExpression="CourseVendor" />
        <asp:BoundField DataField="ModuleID" HeaderText="ModuleID" SortExpression="ModuleID" />
        <asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID" />
    </Columns>
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSourceCRS" runat="server" TypeName="HomeProd.Modules.Tmgr_CourseType.Tmgr_CourseTypeController" OldValuesParameterFormatString="original_{0}" SelectMethod="GetTmgr_CourseTypes">
</asp:ObjectDataSource>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}"
    SelectMethod="GetTmgr_FltTraining" TypeName="HomeProd.Modules.Tmgr_CourseType.Tmgr_CourseTypeController">
    <SelectParameters>
        <asp:ControlParameter ControlID="txtFilter" Name="CourseID" PropertyName="Text" Type="String" DefaultValue="" />
    </SelectParameters>
</asp:ObjectDataSource>

</ascx end>

Regards..
Peter

Vladan,
        Thanks I never thought of using a second gridview and is worth looking into..

I still have one issue though the filtering that i am trying to implement is not working correctly (exceuting the Stored Procedure in my SQL Database works correctly), when i supply a value and i know that there is more than one value in the database the filter is only returning the first value of the filtered list not all the values. Not too sure why, any ideas??

Also I did end up fixing the paging by implementing a manual paging routine but that is by the way as i'll be looking into using your idea of a second gridview. The only problem that i need to fix now is the filter return values.

Regards..
Peter.