How to create unique serial number in C# with data type number using DB MS-access

Question

1.00/5 (1 vote)

See more:

hello, i'm newbie in c#. I need help for generate unique number for invoice.
I want to display the number like "SSL/06/XI/2018" but the type value in db still in number.

What I have tried:

void NewInvoice()
        {
            try
            {
                OleDbDataAdapter da = new OleDbDataAdapter("Select [Invoice] from [Purchase] order by [Invoice] desc", conn);
                DataSet ds = new DataSet();
                da.Fill(ds);
                //Row value +1 for increment
                if (ds.Tables[0].Rows.Count > 0)
                {
                    Invoice_tx.Text = (int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1).ToString();
                }
                else
                { Invoice_tx.Text = "1"; }
            }
            catch (Exception x)
            {
                MetroFramework.MetroMessageBox.Show(this, "Error" + x, "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop);
            }
        }

I try for display just number(like "1","2") it works. When I try create like "SSL/06/XI/2019" still error. Please Help me

Posted 21-Jan-19 20:51pm

Member 13921023

Updated 21-Jan-19 22:24pm

Add a Solution

1 solution

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)

lmoelleb · Accepted Answer · 2019-01-21T22:24:00

1) Debug so you understand where the error is. It can help to split long lines into multiple lines so a single step in the debugger only does as little as possible. I know debugging might seem like an advanced topic you can learn later. It is not. It is the first skill you need to learn. It makes things simpler, not harder.

2) Error messages try to tell you what is wrong. Read them and take time to understand them. Google the error text will often give hints. And if you still can't find out, at least include the error message when you ask for help.

3) What do you expect

int.Parse("SSL/06/XI/2019")

to return? You first need to read the string, then split it up in parts, then increment the part you want, then reassemble the string. Look into the Split() method on strings. There are other (arguable better) ways to do it, but Split() is very simple conceptually.

This also gives you a good place to detect if the previous invoice was from last year so you need to reset the count.

An alternative approach is to store each part of your invoice number in it's own column in the database and assemble the string as it needs to be printed or displayed.