code for generating numbers according to primary key

Question

0.00/5 (No votes)

See more:

Hi all

I want to generate auto number corresponding to primary keys

like

if pk is 1 the no will be 000001

if pk is 10 :000010

if 100: 000100

the total digits in a number should be same..how to code for it in c#?

Thanks in advance

Posted 25-Feb-11 22:14pm

amritha444

Add a Solution

3 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 · 2011-02-25T22:24:00

Solution 1

All you need to do is add formatting information to your ToString call:

C#

int i = 100;
Console.WriteLine(i.ToString("D6"));

Alternatively, you could do it with String.Format:

C#

int i = 100;
Console.WriteLine(string.Format("{0:D6}", i));

Posted 25-Feb-11 22:24pm

OriginalGriff

Abhinav S · Answer 2 · 2011-02-25T22:51:00

Solution 2

Which database are you using? You might want to check if you can do something similar in the database directly.

Posted 25-Feb-11 22:51pm

Abhinav S

Espen Harlinn · Answer 3 · 2011-02-26T04:00:00

Some rdbms engines like MS SQL use IDENTITY[^]

While others use sequences[^]

It's usually a good idea to let the rdbms generate the key for you to avoid concurrency issues because many users access and change data in a relational database, the database manager must be able both to allow users to make these changes and to ensure that data integrity is preserved.

Concurrency refers to the sharing of resources by multiple interactive users or application programs at the same time.

Regards
Espen Harlinn