How to automatically generate and record unique ID of user in database in asp.net

Question

2.65/5 (3 votes)

See more:

, +

SQL

Suppose I have unique ID kvk0001

where kvk is fixed 0001 is increment by one such as:
kvk0001,kvk0002,kvk0003.......

And unique ID kvk0001 is same id for each table of registration.

how to develop a code for above case in C# & ASP.NET ?

Posted 11-Sep-13 2:05am

k.vinodkumar

Updated 13-Mar-14 16:29pm

v4

Add a Solution

Comments

[no name] 13-Sep-13 10:45am

"code for above case in C#", if you are unable to add 1 to an integer and concatenate a string then you really should be picking a book on basic C# programming and working through it.

2 solutions

Solution 2

adding a prefix/suffix. Something like this should work:

1 - Add an IDENTITY field which will be auto-incremented
2 - Add a calculated field in the table with the definition of:

[InvoiceNo] AS ('AS' + RIGHT(('000000000' + CAST(idfield AS varchar(9))), 9) + 'FAK')

This will give you invoiceno in the format of:

AS000000001FAK
AS000000002FAK
...
AS000995481FAK

Posted 11-Sep-13 2:24am

Salman622

Add a Solution

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

Anuja Pawar Indore · Accepted Answer · 2013-09-11T02:21:00

Solution 1

Refer this best :
http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-server[^]

Posted 11-Sep-13 2:21am

Anuja Pawar Indore

Comments

Thanks7872 11-Sep-13 8:23am

Great one..! +5

Anuja Pawar Indore 12-Sep-13 3:03am

Thanks Rohan

Thanks7872 12-Sep-13 3:05am

I found approximately 7 to 8 similar type of questions in last 24 hours.

Anuja Pawar Indore 12-Sep-13 3:13am

Agree, its very common. But rather than searching everyone needs it to be served

Thanks7872 12-Sep-13 3:14am

:-)

How to automatically generate and record unique ID of user in database in asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to automatically generate and record unique ID of user in database in asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us