Radgrid get data filter

[Carlos]

Hi all, ho can i get data from a filtered Radgrid, using autogenerated columns.

Best Regards.

[Princy]

Hi Carlos,

Please try the following code snippet to obtain data after Filter for autogenerated columns.

C#:

static bool IsFilter = false;

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (IsFilter == true) //Access after the filter
    {
        if (e.Item is GridDataItem)
        {
            GridDataItem item = (GridDataItem)e.Item;
            // Get the datas after filtering
            string name1= item["DataFieldName1"].Text;
            string name2= item["DataFieldName2"].Text;
        }
    }
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.FilterCommandName)
    {
        IsFilter = true;
    }
}

Thanks,
Princy

[Carlos]

Hi doesnt that code only give the ones that a e one page in radgrid, when paging in on.
Ihave to remember that my column are auto generated and i dont know the name of the columns.

[Princy]

Hi Carlos,

Please try the following code snippet to access the filtered data when Paging is allowed.

C#:

static bool IsFilter = false;
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.FilterCommandName)
    {
        IsFilter = true;
    }
}
protected void RadGrid1_PreRender(object sender, EventArgs e)
{
    if (IsFilter )
    {
        int count = RadGrid1.MasterTableView.Items.Count;
        RadGrid1.AllowPaging = false;
        RadGrid1.Rebind();
        foreach (GridColumn col in RadGrid1.MasterTableView.AutoGeneratedColumns)
        {
          foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
          {
            string name1= item[col.UniqueName].Text;
          }
       }
        RadGrid1.AllowPaging = true;
        RadGrid1.Rebind();
    }
}

Thanks,
Princy