Display auto generate 10 digit number in label

Question

1.00/5 (1 vote)

See more:

i have one field of serial number in database...but it's datatype is char(10)..from that how can i genrate 10 digit number and that number display in label

Posted 1-Jul-13 5:00am

hardikshah011

Add a Solution

Comments

Sergey Alexandrovich Kryukov 1-Jul-13 11:24am

Please start from http://www.whathaveyoutried.com.
—SA

Richard MacCutchan 1-Jul-13 11:39am

Easy, think of a number above 999,999,999, and convert it to a string.

Shibashish_Choudhury 1-Jul-13 12:11pm

please explain the need of doing this....

1 solution

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)

OriginalGriff · Answer 1 · 2013-07-01T05:44:00

Don't try.
If you are storing it as a text field, then leave it as a text field - a label can only display those, so converting the data to a numeric value just to convert it back to a string again to display it is wasteful.

But if it is always a numeric value, then why are you storing it in a text fields anyway? If it contains a single non-numeric digit then any conversion to a number will fail...

10 digit numbers are a minor problem to store: unless the number is below 4,294,967,296 if won't fit in even an unsigned 32 bit integer, so you would have to process it as a 64 bit number - a long in C# or a bigint in SQL server. But that's what I'd do. If it's a numeric value, store it as a numeric value - it's a lot easier (and smaller) to work with.