how to generate number in textbox in asp.net c#

Question

0.00/5 (No votes)

See more:

Hi frnds,

I have a registration form in my project, when user open this page a code number must be generated automatically in textbox.
so we can understand, this is the code for this user.

The code must be generated as (UserDepartment-001)
Example
===========
UserIT-001
UserIT-002
UserIT-003

The code must be automatically generated in Textbox(TxtGeneratedCode) when the page loads.

Please can you help me how to do this.

Thanks in advance.

Posted 24-May-14 21:52pm

Software Engineer 892

Add a Solution

2 solutions

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 · 2014-05-24T22:07:00

No. Don't do it. Don't even try.

How many users do you think will be trying to register at the same time? One, or more than one?

If it's more than one - and it will be in the real world - and you "pre-generate" the user code, then all the current users will be given teh save value.

Only ever generate user ids and so forth when you insert them to the system: because only then can you be sure exactly what value they can have - think how much trouble you could get into with more than one person with the same value?

Then, exactly how to generate the code will depend on how you are storing it...

Thanks7872 · Answer 2 · 2014-05-24T23:18:00

Solution 2

Refer this : Custom Auto-Generated Sequences with SQL Server[^][I assume you are using SQL Server].

I am agree with what OG stated above and using this link you should generate the number at the time of insertion of record.

Posted 24-May-14 23:18pm

Thanks7872