I need auto generated id in C#

Question

1.00/5 (2 votes)

See more:

this is my code for auto generated id i want my auto id to get the datetime and year for my id. it will generate like 050-2018-0001 in the textbox like this format im new in C#. sorry for the bad english

C#

private void GenerateID()
        {
           
            con.Open();
            cmd = new MySqlCommand("Select Max(StudID)+1 from student_registration", con);
            dr = cmd.ExecuteReader();
            if (dr.HasRows)
            {

                while (dr.Read())
                {
                    txtStudID.Text = dr[0].ToString();
                    if (txtStudID.Text == "")
                    {
                        txtStudID.Text = "1";

                    }
                }
            }
            else
            {
                txtStudID.Text = "1";
                return;
            }
            con.Close();
        }

What I have tried:

i need auto generated id in C#

Posted 2-May-18 20:50pm

Member 13809257

Updated 5-Aug-18 21:53pm

RickZeeland

v3

Add a Solution

Comments

OriginalGriff 3-May-18 3:33am

And?
What have you tried?
Where are you stuck?
What help do you need?
What does "DateTime" have to do with that ID?

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.
Use the "Improve question" widget to edit your question and provide better information.

3 solutions

Solution 2

You need to parse you StudId because is it string

try like this

private void GenerateID()
{
	
	con.Open();
	cmd = new MySqlCommand("Select Max(StudID) from student_registration", con);
	dr = cmd.ExecuteReader();            
	string newId = string.Format("050-{0}-0001", DateTime.Now.Year);
	if (dr.HasRows)
	{
		string prefix = string.Format("050-{0}", DateTime.Now.Year);
		while (dr.Read())
		{
			
			string maxId= dr[0].ToString();
			if (!string.IsNullOrWhiteSpace(maxId) && maxId.StartsWith(prefix))                  
			{                        
				int count = Convert.ToInt32(maxId.Split('-')[2]);
				newId = string.Format("050-{0}-{1:0000}", DateTime.Now.Year, count+1);
			}                    
		}
	}
	txtStudID.Text = newId;
	con.Close();
}

Posted 3-May-18 3:37am

jekin77

Updated 3-May-18 3:48am

v3

Comments

nurjimar adam 16-Jun-18 8:25am

sir jekin77 i wanted auto geneated id like 000000000001 000000000002 000000000003 i'm using auto increment.

jekin77 16-Jun-18 8:38am

It's already autogenarated .. try to understand the code-snippet.
at least run the code and debug it to see the output

nurjimar adam 16-Jun-18 8:49am

yah but i need like 00000000001 0000000002 generated id can u help me with it

jekin77 16-Jun-18 8:53am

you wrote in the fist post "i want my auto id to get the datetime and year for my id. it will generate like 050-2018-0001" , so the examle from do that.

Now you will somthing else ...

If you undestand the code below , you can do it yourself ...JUST TRY IT !

nurjimar adam 16-Jun-18 8:59am

i'm new in programming

nurjimar adam 16-Jun-18 9:19am

can u help me improve my skill in c# ??

jekin77 16-Jun-18 9:31am

learning by doing is the best way to improve your skills

Solution 3

The best of way of having Auto Generated Id in C# code is below.

public class Employee
{
public Guid Id { get; private set; } = Guid.NewGuid();
public string EmployeeName { get; set; }
public string Address { get; set; }
}

So whenever you create an object of Employee class it will assign an Unique GUID to ID property so no need to do anything else.

Posted 5-Aug-18 21:54pm

Laxman Singh Digari

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

RickZeeland · Accepted Answer · 2018-05-02T22:48:00

Solution 1

Your question is not very clear, but maybe you mean something like this:

txtStudID.Text = "050-" + DateTime.Now.Year + "-" + dr[0].ToString().PadLeft(4, '0');

Posted 2-May-18 22:48pm

RickZeeland

Updated 2-May-18 22:52pm

v2

Comments

Member 13809257 3-May-18 4:48am

when i run the code and saved it. result is 050-2018-0050 not 050-2018-0001