How to generate a sequential ID V0001 and A0001

Question

1.00/5 (1 vote)

See more:

ASP.NET

SQL

C#3.5

Any one guide how to create a sequential ID For VacancyId like V0001 and Applicant ID like A0001

thanks.

Posted 18-Jan-16 20:19pm

Member 11151453

Add a Solution

Comments

_Asif_ 19-Jan-16 2:42am

What have you tried?

Member 11151453 19-Jan-16 2:52am

create a recruitment process system
I need Vancay Id which is started from V0001 to V5000 sequentially.

Can you help me create this ID using C# or SQL

_Asif_ 19-Jan-16 2:53am

you now have a Solution

3 solutions

Solution 3

I ususally advise to just use the built-in IDENTITY column on each table (you *do* have separate tables for Applicants and Vacancies don't you?)

The only time you need to format the id is at the point of presentation to the user.
It also helps with the situation where you end up with more than 9999 vacancies and have to reformat the number e.g. V09999 - you're not changing any data, just the way it is displayed

Posted 19-Jan-16 4:22am

CHill60

Solution 2

you can have a look at this and use it to your advantage:
http://raresql.com/2013/06/21/sql-server-2012-how-to-generate-a-varchar-sequence-number-using-sequence-object/

Posted 19-Jan-16 3:45am

Kats2512

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)

CPallini · Accepted Answer · 2016-01-18T20:46:00

Solution 1

That's pretty simple: you need to permanently store the current value, e.g. using a file or a database (I would store only the integer part, of course) and increment it when needed.

Posted 18-Jan-16 20:46pm

CPallini

Comments

Member 11151453 19-Jan-16 5:24am

Kindly give some code for idea how ill do it.

Kats2512 19-Jan-16 9:44am

sound like this is homework, nothing comes for free. did you even check on google???

CHill60 19-Jan-16 10:19am

Would this be advisable in a multi-user environment? What's wrong with using the SQL IDENTITY column?