To Generate autoIncrement sequence in c#.

SWAMY YT

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.

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Piyush Pansuriya7y ago
Accepted 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.
SWAMY YT7y ago
thsnk you sir, it clears my doubt and 1 more clarrification i needed,
if the count is lessthan 10 (<10) (000001)
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 YT7y ago
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.
Piyush Pansuriya7y ago
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/
SWAMY YT7y ago
is there any inbuilt methods are there to create sequence number to generate instead of these long procedure?
SWAMY YT7y ago
You mean to say I have to save this number to database right?
Piyush Pansuriya7y ago
Hello,

public int getthenumber()
{
return 000001;
}

In this function, you have to get max value from the database and retruned it.
SWAMY YT7y ago
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 Sahoo7y ago
define a custom method that retrive the max id then add i and concat
Piyush Pansuriya7y ago
Hello,
Can you share the code for inserting into database?
It will more clear to help you.