how to generate number in textbox or label

Question

3.00/5 (2 votes)

See more:

Invoice Number Automation i am doing computer shop management each and every time after selling a product the invoice number should change automatically like cs102 for one customer and another customer should get cs103 how to do it........i don't know basic for this please give coding or link in case you know ....don't ask show your coding....i don't know even a single line

Posted 21-Feb-12 19:53pm

morrish7

Add a Solution

Comments

Varun Sareen 22-Feb-12 1:59am

Who you are? a shopkeeper or a programmer?

4 solutions

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)

_Maxxx_ · Accepted Answer · 2012-02-21T20:04:00

You need the 'CSS' part and the numerical part to be separate - so store one as
Dim prefix as string = "CS"

And the number as an int,
Dim num as Integer = 103

Then you make up your invoice number as

Dim inv as string = prefix + num.ToString()

Of curse you probably need to store the invoice numbers to a db somewhere rather than hard coding e values as I have, but if you've any chance of doing what you wish, that should give you a start.

Oh I nearly forgot ... Then you need to

Num += 1

To lincrement the numerical part

Sarvesh Kumar Gupta · Accepted Answer · 2012-02-21T20:02:00

Solution 1

Hi, First fetch last inserted record value suppose that is 102. then increase this by 1 then it will be 103 and make a string and assign value to this "cs"+val.ToString() and show this string in text box. do this process for each time when you insert a new record or invoice.

Hopefully, it will help you.

Posted 21-Feb-12 20:02pm

Sarvesh Kumar Gupta

Comments

karthikh87 22-Feb-12 4:20am

hi i too have similar issue with C# so can u give me code for this and i tried with incrementing in database but issue is that it will re-write on previously entered value

Sarvesh Kumar Gupta 22-Feb-12 12:51pm

hi you also use above process, if any issue then you can tell me.

ProEnggSoft · Accepted Answer · 2012-02-21T21:26:00

Solution 4

Here

http://winform-net.blogspot.in/2011/06/auto-increment-invoice-number-for-vbnet.html[^]

is a sample to Auto Increment Invoice Number For Vb.Net, which may be helpful to you

PES

Posted 21-Feb-12 21:26pm

ProEnggSoft

Comments

[no name] 22-Feb-12 12:45pm

Thanks proEnggSoft dude..

ProEnggSoft 22-Feb-12 18:50pm

Thank you

psgviscom · Accepted Answer · 2012-02-21T20:38:00

Solution 3

Hi morrish7,
Use auto_increment in your database for invoice field.

Eg:
CREATE TABLE customer (
     Inv_no INT NOT NULL AUTO_INCREMENT, other fields like name,product,...
     PRIMARY KEY (Inv_no)
);

Posted 21-Feb-12 20:38pm

psgviscom

Comments

[no name] 22-Feb-12 12:44pm

Thanks vishnupriyaraju..by the way ms access anyway thanks

Sarvesh Kumar Gupta 22-Feb-12 12:53pm

There is alphanumeric field so you can't use this.

how to generate number in textbox or label

4 solutions

Solution 2

Solution 1

Solution 4

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us