auto generate number c#

Question

0.00/5 (No votes)

See more:

Hi All,

I need some help from u people.My senario like this

I am inserting multiple records at the same time users are hitting the same time. But here i found Running number from front end(Get the max number from database and adding 1 to that number) and adding this number in each and every row and forming insert query.

So before executing insert query if others are also getting the same number so how to handle this one.

Thanks & Regards,

Posted 13-Jul-10 22:58pm

kumarramchennai

Add a Solution

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

#realJSOP · Answer 1 · 2010-07-14T00:15:00

Solution 1

Just add an integer ID field to the table that auto-increments.

Posted 14-Jul-10 0:15am

#realJSOP

v2

Dylan Morley · Answer 2 · 2010-07-14T00:25:00

Yes, as John says let you database generate this number, if you need to use the number in the front end then just have your procedure return it after the insert has completed.

Something like...

SQL

CREATE PROCEDURE  example_procedure

	(
		@SomeVariable	INT,
		@AnoherVariable	INT,
		@UniqueFieldID	INT OUTPUT

	)

AS

SET NOCOUNT ON

INSERT INTO
	TheTable (Field1, Field2)
VALUES
	(@SomeVariable, @AnoherVariable)

--Return the new identity
SET @UniqueFieldID  =  SCOPE_IDENTITY()

-- Return any error codes \ Reset the NOCOUNT property.
RETURN @@ERROR
SET NOCOUNT OFF
GO

ashu2188 · Answer 3 · 2010-07-14T03:32:00

You can either turn the auto number on or you can also generate RANDOM NUMBER everytime as a primary key which will be diffrent for all the users.

No need to fetch the last record and add 1 in its id, instead just insert random number for all records which will be diffrent for all the users even if it wil be having entry in DB at same time.

(Random depends on the algorithm that you write)

Ashutosh Jain.

auto generate number c#

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0