How to autogenerate ticket number?

Question

0.00/5 (No votes)

See more:

How to autogenerate Ticket number and save into database?
This question regarding help desk ticket creation into any project.

Posted 13-Mar-13 1:46am

Abhijit Ranjan

Updated 13-Mar-13 2:23am

Mike Meinz

v2

Add a Solution

Comments

ZurdoDev 13-Mar-13 7:50am

Write the SQL to do it, or use an identity field. Then write code in ASP.Net. What do you actually need help with?

[no name] 13-Mar-13 8:41am

How do you expect us to know what you think your "ticket number" looks like?

Anuja Pawar Indore 13-Mar-13 9:09am

Are you looking for Capcha? or Simple number....

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)

CHill60 · Answer 1 · 2013-03-13T02:15:00

In your database schema have one column set up to use the IDENTITY property
e.g.

SQL

create table myTable(
TicketID int not null IDENTITY(1,1)
-- other columns ...
)

This will automatically create a TicketID starting at 1 (1,1) and incrementing by 1 each time a row is added (1,1). It will automatically handle any rows that are deleted from the table ensuring that the TicketID is always unique.

See this link[^] for the documentation

Mike Meinz · Answer 2 · 2013-03-13T02:22:00

Let SQL Server do the work for you.

1. Declare a Primary Key column (TicketNumber) in the "Ticket" table of INT or BIGINT Data Type with Column Properties Identity Specification IsIdentity set to Yes, Identity Increment set to 1 and Identity Seed set to 1.

SQL

CREATE TABLE YourTableName (
TicketNumber INT NOT NULL IDENTITY(1,1),

-- ...
-- The remainder of your table's columns go here
-- ...

)

or

SQL

CREATE TABLE YourTableName (
TicketNumber BIGINT NOT NULL IDENTITY(1,1),

-- ...
-- The remainder of your table's columns go here
-- ...

)

2. After an INSERT of a new "Ticket" row, use the SCOPE_IDENTITY function to get the Primary Key of the inserted row. That value is the "Ticket Number".

* See Retrieving Identity or Autonumber Values (ADO.NET)[^].
* See example of retrieving SCOPE_IDENTITY at Obtaining a Single Value from a Database[^].

How to autogenerate ticket number?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0