How to set Filter Column and FilterValue from code behind radgrid

  Here I am going to explain how to get list of filtered columns including filter value from code behind in telerik radgrid.

 The below tutorial helps us to get list of filtered values from telerik radgrid. For reports we are able to save the filtered values in database and also we can apply when next time we opening the report grid. For get list of group columns click here get list of group columns.

      

string filterXml = "<Filters><Filter><ColumnName>FirstName</ColumnName>

<Vlaues>Dhina,Venkatesh</Vlaues></Filter></Filters>";

filterXml = filterXml.TrimStart('"').TrimEnd('"');

if (filterXml != "" && filterXml != null)

{

    XDocument oXDoc = XDocument.Parse(filterXml);

    var FilterDetails = from x in oXDoc.Root.Descendants("Filters").Descendants("Filter") select x;

    if (FilterDetails.Count() > 0)

    {

        foreach (var item in FilterDetails)

        {

            string FilterData = item.ToString();

            XDocument oXDocFilter = XDocument.Parse(FilterData);

            string ColumnName = XmlReConversionFromat(oXDocFilter.Root.Element("ColumnName").Value.ToString());

            string Values = XmlReConversionFromat(oXDocFilter.Root.Element("Values").Value.ToString());

            if (boundColumn.DataField.ToLower() == ColumnName.ToLower())

            {

                boundColumn.ListOfFilterValues = Values.Split(',');

            }

        }

    }

}

How to set group columns from code behind radgrid

  Here I am going to explain how to set list of group columns  from code behind in telerik radgrid.

 The below tutorial helps us to set list of group columns from telerik radgrid. For reports we are able to save the group columns in database and also we can apply , when next time we opening the report grid. For get list of group columns click here get list of group columns 

string groupColumns = "Name,Age,Address";

if (groupColumns != "")

{

    string[] GroupColumnsSplit = groupColumns.Split(',');

    foreach (string field in GroupColumnsSplit)

    {

        GridGroupByExpression expression = new GridGroupByExpression();

        GridGroupByField gridGroupByField = new GridGroupByField();

        gridGroupByField = new GridGroupByField();

        gridGroupByField.FieldName = field;

        gridGroupByField.HeaderText = field;

        expression.SelectFields.Add(gridGroupByField);

        gridGroupByField = new GridGroupByField();

        gridGroupByField.FieldName = field;

        expression.GroupByFields.Add(gridGroupByField);

        radgrid.MasterTableView.GroupByExpressions.Add(expression);

        radgrid.DataBind();

    }

}

How to get group columns from code behind radgrid

 Here I am going to explain how to get list of group columns  from code behind in telerik radgrid.

 The below tutorial helps us to get list of group columns from telerik radgrid. For reports we are able to save the group columns in database and also we can apply when next time we opening the report grid

  string groupColumns = "";

int i = 0;

foreach (GridGroupByExpression group in radReports.MasterTableView.GroupByExpressions)

{

    foreach (GridGroupByField field in group.GroupByFields)

    {

        if (i != 0)

        {

            groupColumns = groupColumns + "," + field.FieldName;

        }

        else

        {

            groupColumns = field.FieldName;

        }

        i++;

    }

}

How to get Filter Column and FilterValue from code behind radgrid

 Here I am going to explain how to get list of filtered columns including filter value from code behind in telerik radgrid.

 The below tutorial helps us to get list of filtered values from telerik radgrid. For reports we are able to save the filtered values in database and also we can apply when next time we opening the report grid

      

XElement docFilters = new XElement("Filters");

string FilterValues = "";

int j = 0;

foreach (GridTableView.PersistableColumnSetting filter in radgrid.MasterTableView.ColumnSettings)

{

    if (filter.ListOfFilterValues != null)

    {

        string filterColumn = filter.UniqueName;

        foreach (string FilterValue in filter.ListOfFilterValues)

        {

            if (j != 0)

            {

                FilterValues = FilterValues + "," + FilterValue;

            }

            else

            {

                FilterValues = FilterValue;

            }

            j++;

        }

        XElement XelFilter = new XElement("Filter");

        XelFilter.Add(

                   new XElement("ColumnName", filterColumn),

                   new XElement("Values", FilterValues));

        docFilters.Add(XelFilter);

        FilterValues = "";

    }

    

}