Click here to Skip to main content
15,062,859 members
Please Sign up or sign in to vote.
2.65/5 (3 votes)
See more: , +
Suppose I have unique ID kvk0001

where kvk is fixed 0001 is increment by one such as:

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

how to develop a code for above case in C# & ASP.NET ?
Updated 13-Mar-14 16:29pm
[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.

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
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:


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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900