[Solved] DataFormatString is not applied

[Chetan]

I have a radgrid and it has dynamically added columns using following code. I have phone number column and I want to apply dataformatstring for this column but it is not getting reflected. What is that I am missing here?

GridBoundColumn boundColumn1 = new GridBoundColumn();
RadGrid1.MasterTableView.Columns.Add(boundColumn1);
boundColumn1.ItemStyle.Wrap = false;
boundColumn1.DataField = "PhoneNumber";
boundColumn1.UniqueName = "PhoneNumber";
boundColumn1.SortExpression = "PhoneNumber";
boundColumn1.HeaderText = "Phone Number";
boundColumn1.AllowFiltering = AllowFiltering;
boundColumn1.ShowFilterIcon = false;
boundColumn1.AutoPostBackOnFilter = true;
boundColumn1.DataFormatString = "{0:(###)###-###}";

Please help

Thank you

[Shinu]

Hi,

In order string format to be applied the data should be of the correct type. Thus in the your case the data should be of some numeric type (int, double, float etc) , please specify data type.
C#:

boundColumn1.DataType = Type.GetType("System.Double");

Thanks,
Shinu

[Chetan]

What if there are phone numbers like UI12312312? Also I tried but it is not working there.
boundColumn1.DataType = Type.GetType("System.Double");

[Chetan]

Is there any solution for this?

[Andrey]

Hello,

It is better to use the GridMaskedColumn for this purpose instead of the GridBoundColumn. You could check this online demo application which demonstrates the approach.

Kind regards,
Andrey
the Telerik team