How to create unique auto increment id number in asp.net

Question

1.00/5 (1 vote)

See more:

i have two tables

1)taskheader
2)taskdetails

taskheader columns

sno,taskname

taskdetails columns

tasknumber,assignee

in the taskheader sno column is auto increment and in taskdetails tasknumber column has
to be sno of taskheader.

both tables have to be populated with single click.

my problem is how to get the tasknumber form taskheader table

Posted 15-Jul-15 4:20am

sunnykvinod

Add a Solution

Comments

F-ES Sitecore 15-Jul-15 10:27am

How can someone give you a solution when you haven't given any implementation details? Are you using ado.net? LinqtoSQL? Entity Framework? nHibernate? Something else? Are you looking to do this at a code level? At the database via a stored procedure?

PIEBALDconsult 15-Jul-15 10:28am

I assume you are using a database. The actual technique will depend on which particular database system you are using. Please use Improve question to add such detail and context so we can better serve you.

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)

OriginalGriff · Accepted Answer · 2015-07-15T04:34:00

Assuming you use a database, the best way is probably to write a stored procedure to do it - and enclose the whole operation in a transaction.
Then, within the transaction you can use @@IDENTITY[^] to fecth the value inserted in the first table, and insert it in the second.

But myself, I wouldn't use Identity values for this - I'd use a Guid value instead, and pass that through from the C# code.

Wendelius · Accepted Answer · 2015-07-15T04:38:00

There are several ways of getting the last inserted value for auto generated values such as identity or auto-increment. One simple is to requery the data using the natural key or to use function to get the latest value and so on.

However, I would prefer using OUTPUT clause[^]. This way you can do the INSERT and get the value easily in the same statement without extra roundtrips.

How to create unique auto increment id number in asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0