Format Phone Number in the GridButtonColumn

[Asif]

Hi,
               I have used the DataTextFormatString="{0:(###) ###-####}" to format the phone number in the GridButtonColumn which is not working. Please find the solution to format the phone in the GridButtonColumn in the Grid.
Note: Im using the Classic RadGrid.

Thanks in advance....

Best Regards,
Asif

[Princy]

Hello Asif,

The DataTextFormatString property for phone number will only works if your data type in that column is of type numeric. I think you have stored the phone number as 'string'. So in ItemDataBound event, you can convert the data type of that column to something that can be formatted using the format string. Sample code is given below for your reference.

ASPX:

<telerik:GridButtonColumn DataTextField="phone" UniqueName="GridButtonColumn" HeaderText="GridButtonColumn" ></telerik:GridButtonColumn>

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridDataItem)
        {
            GridDataItem item = (GridDataItem)e.Item;
            LinkButton btn = (LinkButton)item["GridButtonColumn"].Controls[0];
            Object ob = btn.Text;
            if (!Convert.IsDBNull(ob))
            {
                Int64 iParsedValue = 0;
                if (Int64.TryParse(ob.ToString(), out iParsedValue))
                {
                    btn.Text = String.Format(System.Globalization.CultureInfo.CurrentCulture,
                       "{0:(###) ###-####}", new object[] { iParsedValue });
                }
            }
        }
    }

Thanks,
Princy.

[Asif]

Its working fine..... thanks princy

Regards,
Asif