Grid filter

[Seban]

Dear Konstantin Dikov,



Thanks for your replay.



My grid contains three columns, named as ID, NAME and SELECTED. The
"SELECTED" column is template column contains one check box with
Autopostback=false. And, I applied the filter to the NAME column, its a
bound bound column.



When I applied the filter to NAME column, I want to show the all record
based on the Name column filter and already I checked items (the
SELECTED Column) in that grid.



ie., The filter condition string is : Name LIKE '%telerik%' AND SELECTED = true



please reply .

very urgent.



Thanks,

Jessy

[Princy]

Hi Jessy,

In order to filter a TemplateColumn, please set its DataField property for that column. Please check the below code snippet:

ASPX:

<telerik:GridBoundColumn DataField="Name" HeaderText="Name" UniqueName="Name" />
<telerik:GridTemplateColumn DataField="SELECTED">
    <ItemTemplate>
        <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%#DataBinder.Eval(Container.DataItem,"SELECTED") is DBNull ?false:Eval("SELECTED")) %>' />
    </ItemTemplate>
</telerik:GridTemplateColumn>

C#:

protected void RadGrid1_PreRender(object sender, EventArgs e)
 {
   if (!Page.IsPostBack)
   {
     foreach (GridDataItem item in RadGrid1.Items)
     {
       string filter = "[Name]= 'Name' AND [SELECTED] = True ";
       RadGrid1.MasterTableView.FilterExpression = filter;
       RadGrid1.MasterTableView.Rebind();
     }
   }
 }

Thanks,
Princy

[Princy]

Hi Jessy,

In order to filter a TemplateColumn, please set its DataField property for that column. Please check the below code snippet:

ASPX:

<telerik:GridBoundColumn DataField="Name" HeaderText="Name" UniqueName="Name" />
<telerik:GridTemplateColumn DataField="SELECTED">
    <ItemTemplate>
        <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%#DataBinder.Eval(Container.DataItem,"SELECTED") is DBNull ?false:Eval("SELECTED")) %>' />
    </ItemTemplate>
</telerik:GridTemplateColumn>

C#:

protected void RadGrid1_PreRender(object sender, EventArgs e)
 {
   if (!Page.IsPostBack)
   {
     foreach (GridDataItem item in RadGrid1.Items)
     {
       string filter = "[Name]= 'Name' AND [SELECTED] = True ";
       RadGrid1.MasterTableView.FilterExpression = filter;
       RadGrid1.MasterTableView.Rebind();
     }
   }
 }

Thanks,
Princy