[Solved] Grid filtering after button clicked

[sabarishbabu]

Grid filtering after button clicked

Hi,

1. I am using RadGrid, Bind data from database.

2. I want to filter my grid data, based on dates (from and to).

3. I have two text box From date, Todate field and one Go button

4. Select the dates  and hit the go button, I want the Grid to show the data between the selected two dates.

5. Any idea let me know.

Thanks

Sabarish

[Princy]

Hello Sabarish,

I suppose that you have the textboxes and the button outside the grid. If that is the case, you can try setting the FilterExpression as shown below:
c#:

 protected void btnGo_Click(object sender, EventArgs e)
    {
           string filterExpression;
           filterExpression = "([DateColumnDataField] >= '"+ TextBox1.Text+"') AND ([DateColumnDataField] <= '"+ TextBox2.Text+"')";

           RadGrid1.MasterTableView.FilterExpression = filterExpression;
           RadGrid1.MasterTableView.Rebind();

    }

Thanks
Princy.