[Solved] How to gropu grid according to dropdown list chage event

[Wella]

I need to group rad grid according  to asp drop down list change event according to drop down change

[Princy]

Hi Wella,

I guess you want to Group a RadGrid according to the SelectedValue of the External DropDownList. Please check the following code snippet.

ASPX:

<asp:DropDownList ID="DDl" runat="server" AutoPostBack="true" OnSelectedIndexChanged="DDl_SelectedIndexChanged">
    <asp:ListItem Text="OrderID" Value="OrderID"></asp:ListItem>
    <asp:ListItem Text="EmployeeID" Value="EmployeeID"></asp:ListItem>
</asp:DropDownList>
<telerik:RadGrid ID="Radgrid1" runat="server" AutoGenerateColumns="false" DataSourceID="SqlDataSource2">
    <MasterTableView>
        <Columns>
            <telerik:GridBoundColumn DataField="OrderID">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="EmployeeID">
            </telerik:GridBoundColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

C#:

protected void DDl_SelectedIndexChanged(object sender, EventArgs e)
{
    string selectedvalue = DDl.SelectedValue;
    GridGroupByField field = new GridGroupByField();
    field.FieldName = selectedvalue;
    field.HeaderText = selectedvalue;
    GridGroupByExpression ex = new GridGroupByExpression();
    ex.GroupByFields.Add(field);
    ex.SelectFields.Add(field);
    Radgrid1.MasterTableView.GroupByExpressions.Add(ex);
    Radgrid1.Rebind();
}

Thanks,
Princy.

[Wella]

Thank You very much for your answer but i got an error on this code in rebind call.


An error occured adding a relation to DataRelationCollection. Please, make sure you have configured the expressions properly - both GroupByFields and SelectFields are required!


please help to solve this

Thanks

[Princy]

Hi Wella,

Unfortunately I couldn't replicate the issue. Can you please provide your code.

Thanks,
Princy.

[Wella]

try
            {

                this.grid1.MasterTableView.GroupByExpressions.Clear();//clear all group expressions
                grid1.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);
                }

                grid1.MasterTableView.GroupByExpressions.Add(expression);


            }
            catch (Exception ex)
            {
                lblMessage.Text = ex.ToString();
            }
            finally
            {
                grid1.Rebind();
               
            }


in need data source event i will set data source to grid


 protected void grid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
        {
           DataTable dt = getGridData();
           grid1.DataSource = dt;
            
        }

[Princy]

Hi,

Can you provide the markup , i think you have two DropDownList. Please specify the event in with the above codes are written.

Thanks,
Princy.