Click here to Skip to main content
15,936,633 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.

Share this answer
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:

Share this answer

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