Member Avatar for judithSampathwa

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

  • 2 Contributors
  • 2 Replies
  • 155 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by judithSampathwa
Member Avatar for Momerath

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.

Member Avatar for judithSampathwa

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.