Autogenerate number in asp.net page

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

HI...

i want to generate a sequence number in quotation page (i.e. in Quotation ID).... how to generate this number programmatically and store the details including the auto generate in sql database....

Have to show the auto generate number in asp.net page....

Posted 7-Jul-11 22:07pm

nithibs

Updated 7-Jul-11 23:29pm

v2

Add a Solution

2 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)

Christian Graus · Answer 1 · 2011-07-07T22:11:00

Solution 1

Use an index in the DB and just show the number from that.

Posted 7-Jul-11 22:11pm

Christian Graus

OriginalGriff · Answer 2 · 2011-07-07T22:21:00

The easiest way is to set up an int field in the database, and change it's "Identity" propetry to "True".
I don't have SQL 2005 at the moment, but it is very similar to teh procedure for SQL 2008. In the SQL Sever management tool:
1) Create your table and edit it, either by select "New Table" from the context menu when you right click "Tables" under your database name, or via the "Design" from the context menu when you right click the table name.
2) Select the empty row at the bottom, and give the field a sensible number: "quoteId" is good.
3) Under DateType, select "int"
4) Deselect "Allow nulls"
5) In the "Column Properties" pane, find "Identity Specification". Expand it, via the "+" sign to it's left.
6) Change "Is identity" to "Yes"
7) Done - the database will now keep that field updated for you, and will increment it by one each time you insret a new row.