Formatted Label in GridTemplateColumn

[WAMatt]

Greetings,

I am using the following GridTemplateColumn in a RadGrid...

<telerik:GridTemplateColumn HeaderText="Phone" ItemStyle-Wrap="False">
  <ItemTemplate>
    <asp:Label ID="lblNotifyingIndividualPhoneNumber"
               runat="server"
               Text='<%# string.Format("{0:(###) ###-####}", Convert.ToInt64(Eval("NotifyingIndividualPhone")))%>'>
    </asp:Label>
  </ItemTemplate>
</telerik:GridTemplateColumn>

The problem is when the database field "NotifyingIndividualPhone" is null or empty, it throws an error: "Input string was not in a correct format".  Any ideas how to get around this issue?

Your help is appreciated!
Matt

[Jayesh Goyani]

Hello,

Try With below code snippet.

Text='<%# Eval("NotifyingIndividualPhone") == null ? string.Empty : string.Format("{0:(###) ###-####}", Convert.ToInt64(Eval("NotifyingIndividualPhone"))) %>'

Thanks,
Jayesh Goyani

[WAMatt]

Thank you, that is a good way to do it all from the markup.  I ended up writing a function so that I could have a bit more flexibility...

ASPX...

<telerik:GridTemplateColumn HeaderText="Phone" ItemStyle-Wrap="False">
  <ItemTemplate>
    <asp:Label ID="lblNotifyingIndividualPhoneNumber"
               runat="server"
               Text='<%# FormatPhoneNumber(Eval("NotifyingIndividualPhone").ToString())%>'>
    </asp:Label>
  </ItemTemplate>
</telerik:GridTemplateColumn>

CP...

protected string FormatPhoneNumber(string s)
{
  if (s == "" || s.Equals(DBNull.Value))
  {
    return "Not found";
  }
  else
  {
    return string.Format("{0:(###)###-####}", Convert.ToInt32(s));
  }
}

Matt