hide/show rows using a single checkbox

[Ryan]

Hi,
I'd like to create a toogle checkbox Filter for RadGrid this would hide/show rows based on one column contents  = Achieved or not.
how would i go about doing this with a RadGrid ?  

[Princy]

Hi Ryan,

I'm not clear about your requirement. I guess you want to filter the Grid based on a column value and using checkbox filter. Please take a look at the below code snippet. Please elaborate your scenario if this doesn't help.

ASPX:

<telerik:GridBoundColumn DataField="IsAchieved" HeaderText="IsAchieved" UniqueName="IsAchieved">
    <FilterTemplate>
        <asp:CheckBox ID="CheckBox1" runat="server" AutoPostBack="true" OnCheckedChanged="CheckBox_CheckedChanged" />
    </FilterTemplate>
</telerik:GridBoundColumn>

C#:

protected void CheckBox_CheckedChanged(object sender, EventArgs e)
{
  CheckBox chk = (CheckBox)sender;
  if (chk.Checked)
  {
      RadGrid1.MasterTableView.FilterExpression = "([IsAchieved]= IsAchieved)";
      GridColumn column = RadGrid1.MasterTableView.GetColumnSafe("IsAchieved");
      column.CurrentFilterFunction = GridKnownFunction.EqualTo;
      column.CurrentFilterValue = "IsAchieved";
      RadGrid1.MasterTableView.Rebind();
  }
  else
  {
      RadGrid1.MasterTableView.FilterExpression = "([IsAchieved]= NotAchieved)";
      GridColumn column = RadGrid1.MasterTableView.GetColumnSafe("IsAchieved");
      column.CurrentFilterFunction = GridKnownFunction.EqualTo;
      column.CurrentFilterValue = "NotAchieved";
      RadGrid1.MasterTableView.Rebind();
  }
}

Thanks,
Princy