Format when entering data into sql server

Question

0.00/5 (No votes)

See more:

I have a database with phone number nvarchar, and a cell as numeric.

I formatted both as ###-###-####.

I have two question.

Question 1.

When a employee enter the number how to make except the format?

Question 2.

when a employee go to save it gives an error message can't save with the dashes.

Tried both neither works.

Is this a asp.net /c# problem
or database issues.

So I will know what to research.

Posted 6-Dec-10 6:04am

postonoh

Updated 6-Dec-10 6:07am

v2

Add a Solution

Comments

fjdiewornncalwe 6-Dec-10 12:19pm

What do you mean by "phone number nvarchar, and cell as numeric"?
Is "phone number" an input parameter or something like that, or is it the field in the table?
What is the "cell"?

postonoh 6-Dec-10 12:40pm

I am trying both types in the database to see which saves with the dashes and cell is cell phone my mistake thanks.

3 solutions

Solution 1

Just Google or use CodeProject search for Masked textbox!

Posted 6-Dec-10 6:42am

Sandeep Mewara

Solution 2

Well, we could help you more if you actually gave us useful information. You say it gave you an error message... what was the exact error message? Also, post the code you're using and the sample data so we know exactly what you're trying to do.

My guess is you are trying to insert a string value into a numeric field. You'd have to remove the dashes, parse the string (perhaps as Decimal?), then insert that value into the numeric field. Without more information, that's the best guess I can give you.

Like another poster mentioned, use a masked textbox, or you can create multiple textboxes and put a validator on each of them to ensure they are in the right format. Personally, I'd probably put a regular expression validator on a single textbox and allow the user to enter multiple formats for their phone number.

Posted 6-Dec-10 7:02am

AspDotNetDev

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

tarun_j200 · Accepted Answer · 2010-12-06T19:59:00

Solution 3

I think you can handle this on your presentation layer. Instead of having one textbox for phone number, try with 3 textboxes separated by "-" with character limits of 3, 3 and 4 respectively.

Posted 6-Dec-10 19:59pm

tarun_j200