How to generate serial no with sequence for barcode C# insert in datagridview

Question

0.00/5 (No votes)

See more:

im new in this world i want to generate serial no like 000001 to 000010 from user input when i click generate btn generate no in insert to datagridview and when i click save btn then save this datagridview data in table like id,barcodeNO,ColorName,size

1 000001 pink 39 2 000002 pink 40 3 000003 pink 41

im successful to generate range from user input with color and size now problem in generate only serial no.

here is my code

What I have tried:

C#

private void button1_Click(object sender, EventArgs e) {

for (int a = int.Parse(textBox1.Text); a < int.Parse(textBox2.Text);           a = a + 1)
        {
            int row=0;
            dataGridView1.Rows.Add();
            row=dataGridView1.Rows.Count -2;
            dataGridView1["color", row].Value = textBox3.Text;
            dataGridView1["Size", row].Value = a;
            //[enter image description here][1]dataGridView1["Barcode", row].Value = dt.ToString();

        }
    }

Posted 27-Dec-16 22:20pm

Member 12861580

Updated 28-Dec-16 2:36am

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)

OriginalGriff · Answer 1 · 2016-12-27T22:31:00

Solution 1

Don't.
Never try to "pregenerate" sequential numbers - only ever create them when you actually add data to the "backing storage" such as a database. (And all databases have a mechanism for creating them for you automatically at that point)
The user doesn't need it until it becomes "permanent" and having them displayed implies permanence. If you rely on it before that, then you can get enormous problems later when some values either don't get stored - because the user changed his mind for example - or get stored against the wrong ID value (because a different user also gets the same numbers).

Posted 27-Dec-16 22:31pm

OriginalGriff

Comments

Member 12861580 28-Dec-16 5:00am

database max value 000009 store
now how can i generate number when user give pink color size 36 to 41 software generate Pink 36 000010
pink 37 000011
pink 38 000012
pink 39 000013
pink 40 000014
pink 41 000015

OriginalGriff 28-Dec-16 5:06am

Don't. Let the DB handle that by making the serial number an IDENTITY field - the DB will then assign unique sequential numbers when you INSERT your rows.

Member 12861580 28-Dec-16 5:24am

then how can i solve this problem sir?

OriginalGriff 28-Dec-16 5:26am

Very simple: let the DB take care of it. Anything else is just asking for problems!

Member 12861580 28-Dec-16 5:58am

can you please write example or code for me ?