[Solved] Telerik grid Group By Expression Error

[Wella]

I have try group telerik grid using drop down list grouping method source code is bellow try { this.grd.MasterTableView.GroupByExpressions.Clear();//clear all group expressions grd.MasterTableView.GroupsDefaultExpanded = false; GridGroupByExpression expression = new GridGroupByExpression(); GridGroupByField gridGroupByField = new GridGroupByField(); gridGroupByField = new GridGroupByField(); if (cboGroupByItem1.SelectedValue != "0") { gridGroupByField.FieldName = cboGroupByItem1.SelectedValue; gridGroupByField.HeaderText = cboGroupByItem1.SelectedItem.Text; expression.SelectFields.Add(gridGroupByField); } if (cboGroupByItem2.SelectedValue != "0") { gridGroupByField.FieldName = cboGroupByItem2.SelectedValue; gridGroupByField.HeaderText = cboGroupByItem2.SelectedItem.Text; expression.SelectFields.Add(gridGroupByField); } grd.MasterTableView.GroupByExpressions.Add(expression); } catch (Exception ex) { label1.Text = ex.ToString(); } finally { grd.Rebind(); } when grid rebind method it will generate bellow error An error occured adding a relation to DataRelationCollection. Please, make sure you have configured the expressions properly - both GroupByFields and SelectFields are required! How i solve this question please help me

[Eyup]

Hi Wella,

You need also to add the created GridGroupField to the GroupByFields collection of the expression:

protected void Button1_Click(object sender, EventArgs e)
{
    RadGrid1.MasterTableView.GroupByExpressions.Clear();//clear all group expressions
    RadGrid1.MasterTableView.GroupsDefaultExpanded = false;

    GridGroupByExpression expression = new GridGroupByExpression();
    GridGroupByField gridGroupByField = new GridGroupByField();

    gridGroupByField.FieldName = "ShipCountry";
    gridGroupByField.HeaderText = "ShipCountry";
    expression.GroupByFields.Add(gridGroupByField);
    expression.SelectFields.Add(gridGroupByField);

    RadGrid1.MasterTableView.GroupByExpressions.Add(expression);

    RadGrid1.Rebind();
}

Please check out this demo for a reference:
http://demos.telerik.com/aspnet-ajax/grid/examples/groupby/groupfooter/defaultcs.aspx

Hope this helps.

Greetings,
Eyup
the Telerik team

[Wella]

ThanK You Very much .

It's Solved my Problem.