To Generate autoIncrement sequence in c#.

Question

Hello everyone, I am trying to generate a sequence number only when inserting the data to the database the code is like (PROJ_2018_000001).where i am trying to generate this by local methods and some cancatination.but i am unable to increment the sequence from the last sequence instead i the sequence is getting generated from (PROJ_2018_000001) by (PROJ_2018_000002) iteself. how to generate the next sequence by previous sequence instead by always (PROJ_2018_000001). Thank you in advance.

Piyush Pansuriya · Answer

For that you have to get the total count from the database table year wise. if you want to reset to 1 when year change, it will helps you. As I say before in this function public int getthenumber() { int cnt = get the total count of records year wise> ; return cnt; } And you will get the result as you want.

Piyush Pansuriya · Answer

Hello, you can generate auto increment id into database directly when record will inserted. There is a Identity Specification column property to increment the value. Gothrough the below link https://www.mssqltips.com/sqlservertip/2784/understanding-column-properties-for-a-sql-server-table/

Piyush Pansuriya · Answer

Hello, public int getthenumber() { return 000001; } In this function, you have to get max value from the database and retruned it.

SWAMY YT · Answer

thsnk you sir, it clears my doubt and 1 more clarrification i needed, if the count is lessthan 10 ( then i go for string value = String.Format("{0:D5}", IncrementedNextSequence()); and if the result (000010) i have to go with string value = String.Format("{0:D4}", IncrementedNextSequence()); and if the result (000100) i have to go with string value = String.Format("{0:D3}", IncrementedNextSequence()); so on / any other way's are they??

SWAMY YT · Answer

You are right, but i have to increment the sequence has the string, the collumjn has followed by 'PROJ' + 'YEAR' + 000001 where i have to increment the 6 digit code only, i am facing the difficulties here only.

SWAMY YT · Answer

is there any inbuilt methods are there to create sequence number to generate instead of these long procedure?

SWAMY YT · Answer

You mean to say I have to save this number to database right?

SWAMY YT · Answer

here is my code what i wrote, where Program P1=new Program(); string Project_Code = P1.getSequence(); cmd.Parameters.AddWithValue("@strPROJECT_CODE", Project_Code ); public string getSequence() { string year=getDate(); string value = String.Format("{0:D5}", IncrementedNextSequence()); Console.Write("PROJ" + year + value); return "PROJ" + year + IncrementedNextSequence(); } public string getDate() { DateTime d1 = DateTime.Now; return d1.Year.ToString(); } public int getthenumber() { return 000001; } public int IncrementedNextSequence() { return getthenumber()+1; }

Laxmidhar Sahoo · Answer

define a custom method that retrive the max id then add i and concat

Piyush Pansuriya · Answer

Hello, Can you share the code for inserting into database? It will more clear to help you.