phone # display in report view in C#.NET

Hi there,

i have a question in C#.NET report viewer. i save the phone number in the database as (234) 233-1346 . so if the use doesn't type in a phone number it will be saved as [() - ] which is show in side the squared brackets, without the squared brackets. in the report it sows as () - for the number that are not inserted. how can i avoid it and leave a blank over there??

please can someone help me!!!!!!!!!

thanks

Contributors

Replies

41 Minutes

Discussion Span

2 Years Ago

Last Updated

Views

judithSampathwa

Posting Pro in Training

453 posts since May 2010

Reputation Points: 8

Solved Threads: 0

Skill Endorsements: 0

2 Years Ago

Don't insert the () and - in the database, they are formating, not part of the actual data. When you pull them from the database, apply formating to display. If the value is null (no number) then you don't display anything.

Momerath

Senior Poster

3,730 posts since Aug 2010

Reputation Points: 1,336

Solved Threads: 624

Skill Endorsements: 13

2 Years Ago

Don't insert the () and - in the database, they are formating, not part of the actual data. When you pull them from the database, apply formating to display. If the value is null (no number) then you don't display anything.

can you give more details please

judithSampathwa

Posting Pro in Training

453 posts since May 2010

Reputation Points: 8

Solved Threads: 0

Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

You