[Solved] filtering the data in the grid

[Jols]

hello to all expert

                          Good Day ! i would like to ask some again to all of you who knows very will, here's my question in my page i have two textbox namely idnumber and firstname, one button namely search and one grid. i'm using stored procedure to load the data on the grid..now when the user input an idnumber or firstname and click the button search it will filter..is there a way to filter the data inside the grid without having any stored proc.on my search button to filter the data..

sample codes is highly appreciated

thanks to all

[Princy]

Hi Jols,

You may try setting the FilterExpression for the Grid in the click event of the Search button as shown below.

CS:

 protected void Button1_Click(object sender, EventArgs e)
    {
        RadGrid1.MasterTableView.FilterExpression = "([ProductName] LIKE '"+TextBox1.Text +"')";
        RadGrid1.MasterTableView.Rebind();
    }

Thanks
Princy.

[Jols]

Sir.. there is no need to configure my Radgrid_needdatasource ? or i straigthly just call the rebind() as you showned the above codes of yours?

[Princy]

Hi Jols,

Rebind() will automatically call the NeedDataSource event. You just need to replace the ProductName with the UniqueName of your Grid column.

Princy.