I am storing phone numbers on the back end sql server database in an
unformatted nvarch type of column. I want to display the stored data
as US phone number (XXX) XXX-XXXX. I tried to do this in the asp tag
for a label and have been unable to make it work. When it did work,
it threw me an error such as:
FormatException was unhandled in user code. Input string was not
in a correct format.
I think it has to do with the column allows nulls.
On Oct 12, 11:59 am, Mike Fry <[email protected]> wrote:
> On 2010/10/12 18:06, BD wrote:
>
> > Working with sql server back end that allows nulls, trying to get the
> > label of a US Phone Number to display in a Label on a FormView. My
> > page has two formviews that have phone numbers in them. My attempts
> > have not worked.
>
> Telling (or showing) us what's going wrong would be a start.
>
> --
> Regards,
> Mike Fry
> Johannesburg
