RadGrid Paging after bending from search

[Lord Vader]

Hi,
In this case I am binding the grid programmatically in the page load, then when a user does a search, I am binding the grid with a different dataset, when I enable paging after the search it binds back the original dataset; here is the code:

public partial class PageSearch : System.Web.UI.Page
{
    public ACHPagingDLL.dl dl = new ACHPagingDLL.dl();
    protected void Page_Load(object sender, EventArgs e)
    {
        LoadGrid();
    }
    public void LoadGrid()
    {
        DataSet dsPatients = dl.c_FN_Paging_getAllEmployees();
        rgEmployees.DataSource = dsPatients;
        rgEmployees.DataBind();
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        if (txtSearch.Text.Length < 2)
        {
            litResult.Visible = true;
            litResult.Text = "<FONT color=#cc0000 size=3>Search for 2 or more characters!</FONT>";
            LoadGrid();
            return;
        }
        else
        {
            DataSet dsSearch = dl.c_FN_seachEmployees(txtSearch.Text);
            rgEmployees.DataSource = dsSearch;
            rgEmployees.DataBind();
        }
    }
}

And here is the HTML:

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server">
        <table class="style4">
            <tr>
                <td class="style5">
                    Search for employee by name:</td>
                <td class="style6">
                    <telerik:RadTextBox ID="txtSearch" Runat="server" Width="160px">
                    </telerik:RadTextBox>

                    <telerik:RadButton ID="btnSearch" runat="server" onclick="btnSearch_Click"
                    Text="Search">
                    </telerik:RadButton>
                </td>
                <td>
                    <asp:Literal ID="litResult" runat="server"></asp:Literal>
                </td>
            </tr>
            <tr>
                <td colspan="3">
                    <telerik:RadGrid ID="rgEmployees" runat="server" AllowPaging="True"
                    AutoGenerateColumns="False" GridLines="None" Skin="WebBlue">
                        <MasterTableView pagesize="20">
                            <CommandItemSettings ExportToPdfText="Export to Pdf">
                            </CommandItemSettings>
                            <Columns>
                                <telerik:GridBoundColumn DataField="EmployeeNo" UniqueName="EmployeeNo"
                                Visible="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="EmployeeName" HeaderText="Employee"
                                UniqueName="EmployeeName">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="Pager" HeaderText="Pager"
                                UniqueName="Pager">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="Office" HeaderText="Office#"
                                UniqueName="Office">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="Cell" HeaderText="Cell Phone"
                                UniqueName="Cell">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="Email" HeaderText="Email"
                                UniqueName="Email">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </MasterTableView>
                        <HeaderContextMenu EnableImageSprites="True"
                        CssClass="GridContextMenu GridContextMenu_Default">
                        </HeaderContextMenu>
                    </telerik:RadGrid>
                </td>
            </tr>
            <tr>
                <td colspan="3">
                     </td>
            </tr>
        </table>
    </telerik:RadAjaxPanel>

I am not sure if there should be a code to be inserted in the index paging?
Please let me know.

Thank you in advance,
Shehab

[Lord Vader]

UPDATE:
I added an is not post back in the page load, now after the search, when I try to navigate pages, it goes blank...

protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            LoadGrid();
        }
    }

[Iana Tsolova]

Hello Shehabeldin,

The described behavior is rather expected with the simple data-binding you are using for the grid. I suggest that you bind the grid through its NeedDataSource event. There you only should assing the RadGrid DataSource property and remove any other assingments to this property from the page code as well as the DataBind() method calls.

For more information, please refer to the below articles:

http://www.telerik.com/help/aspnet-ajax/grdsimpledatabinding.html
http://www.telerik.com/help/aspnet-ajax/grdadvanceddatabinding.html

Regards,
Iana
the Telerik team

[Lord Vader]

Thank you for your reply.
If I bind the grid in need data source, how am I going to bind the grid when users search for patient name's as I showed in the code?

[Iana Tsolova]

Hi Shehabeldin,

In the button click event you can call the Rebind() method for the grid. This will invoke the NeedDataSource event so you can move the logic for getting/filtering the data there.

Greetings,
Iana
the Telerik team