How to do +1 bill No. Each and every time

Question

2.00/5 (1 vote)

See more:

Dear All
I am trying to create a project like billing software. in this form i have a text box for bill no. and now i want to +1 every time of last bill no.

i am tring a lot but at run time it is not refreshing every time

~~please help me ...................~~

Posted 29-Jan-12 23:12pm

Nand Kishor Upadhyay

Updated 29-Jan-12 23:20pm

Rajesh Anuhya

v2

Add a Solution

Comments

CRDave1988 30-Jan-12 5:14am

can you show your code?

Rajesh Anuhya 30-Jan-12 5:21am

Post your code what you tried.

4 solutions

Solution 6

Hi Use OriginalGriff answer after that set identity seed to 1. it will solve your problem.

Posted 30-Jan-12 2:45am

Sarvesh Kumar Gupta

Solution 1

If you are using a database table for the bill number, just set bill no to an identity column and then get the last bill number using @@identity(here[^]) and then add one to it.

Posted 29-Jan-12 23:19pm

Abhinav S

Comments

Dave Kreskowiak 30-Jan-12 10:31am

And if two clients run this at the exact same time?? You now have two client that are trying to use the same id number. You NEVER manually add an increment to an identity field to generate a new identity for this reason.

Abhinav S 30-Jan-12 10:51am

Worse case one insert will fail?

Solution 2

hello,

You can do this in two ways :
1. either set a auto-generated column in database table. because when you submit then each time it will insert unique number.
2. or get a integer field and when you submit that bill detail then first execute query to get max. bill no. and add 1 in that no. and then execute with details.

Hope this will help you.
And you can ask for more details. And don't forget to mark as answer if it helps. :)

Posted 29-Jan-12 23:21pm

Manish.Insan

Comments

Dave Kreskowiak 30-Jan-12 10:33am

Your second option sucks because if you have two clients running this code at nearly the same time, you get the same ID number being generated on two machines.

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 · Accepted Answer · 2012-01-29T23:24:00

The easiest way is to create the bill number field as an Identity field: that way SQL Server will take care of it for you. You then don't specifiy the field content, SQL server will assign it a new, incremented value when you use the INSERT command.
To do that:

In SQL server Management Studio, create your table.
Create the BillNo field, as an int.
In the Properties, expand "Identity Specification".
Change "(Is Identity)" to "Yes"

Done!

How to do +1 bill No. Each and every time

4 solutions

Solution 4

Solution 6

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us