[Solved] Dynamic colum enable/disable search

[Chetan]

Hello,

I am using Radgrid. I have dynamically added columns in this grid like mentioned below. I wanted to add filter for some of the columns. What is the way to enable this so that some columns will have filter. I am using custom paging so how to make filter on complete records instead of current page records? Also there is column for phone where records are displayed as (123)-456-1234. If user enters 12345.. then also it should search the phone.      

GridBoundColumn boundColumn1 = new GridBoundColumn();

RadGrid1.MasterTableView.Columns.Add(boundColumn1);

boundColumn1.ItemStyle.Wrap = false;

boundColumn1.DataField = DataField;

boundColumn1.SortExpression = DataField;

boundColumn1.HeaderText = HeaderText;

[Jayesh Goyani]

Hello,

// Allow Column for all column
       RadGrid1.AllowFilteringByColumn = true;

       GridBoundColumn boundColumn1 = new GridBoundColumn();
       RadGrid1.MasterTableView.Columns.Add(boundColumn1);
       boundColumn1.ItemStyle.Wrap = false;
       boundColumn1.DataField = DataField;
       boundColumn1.SortExpression = DataField;
       boundColumn1.HeaderText = HeaderText;
       // Disable filter to this column
       boundColumn1.AllowFiltering = false;

Thanks,
Jayesh Goyani

[Chetan]

Thank you Jayesh, it worked for me. I also wanted to know that there is column for phone where records are displayed as (123)-456-1234. If user enters 12345.. then also it should search the phone. Any thoughts on this?

[Shinu]

Hi,

One suggestion is that you can use GridMaskedColumn for the purpose .This column type is for values that fit a specific format. Set the Mask property to specify an edit mask that defines the valid values. Check the following help documentation for more.
Column Types

Thanks,
Shinu.

[Chetan]

Actually I have two columns, FormattedPhone and Phone. FormattedPhone has phone like [phone] and Phone has value like 1231231234. I have boundcolumn which has data coming from  FormattedPhone column. Also I have added filter for this column. When I search the record like 1234, it should return this phone. Is there any way so that I can change search column name to Phone from FormattedPhone. 

Thank you

[Eyup]

Hello Chetan,

I am afraid it is difficult to figure out your exact requirement. Can you please elaborate on your specific scenario and provide us some screenshots demonstrating the desired behavior?

Looking forward to your reply.

Greetings,
Eyup
the Telerik team