Setting columns based on checkbox selection

[Royal]

I am interested in setting the output columns of my RadGrid based on the checked columns (true or false) selected by the user.

As an example, lets say I have ten default columns returned to my datagrid, but the user only wants to display 5 of those. Can anyone point me in the right direction?

Thanks in advance.

[Shinu]

Hello Royal,

If you want to customize the grid column visibility based on the checkbox selection, then you can either use HeaderContextMenu option or code behind approach.

1) From aspx page
Simply set EnableHeaderContextMenu property to "True", which allows show/hide the grid columns based on user preferences.

Mark-up:


<telerik:RadGrid EnableHeaderContextMenu="true" ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource"

               OnUpdateCommand="RadGrid1_UpdateCommand" OnPreRender="RadGrid1_PreRender">

2)From code behind:
If the CheckBoxes are placed outside grid, then set the column visibility in PreRender event by using following code snippet.

Code behind:

protected void RadGrid1_PreRender(object sender, EventArgs e)
   {
       RadGrid1.MasterTableView.GetColumn("EmployeeID").Visible = CheckBox1.Checked;
       RadGrid1.MasterTableView.GetColumn("FirstName").Visible = CheckBox2.Checked;
       RadGrid1.Rebind();
   }

Regards,
Shinu.

[Royal]

Awesome, thank you!