Select random number without duplicate.

Question

1.00/5 (2 votes)

See more:

Now i want to select the 1 random Number from database records 1-10000 in the given range.And also check the random number is already exist are not if exist means select new number.

Posted 18-Jun-15 23:28pm

venkatesh@India

Updated 19-Jun-15 19:31pm

v4

Add a Solution

Comments

F-ES Sitecore 19-Jun-15 5:46am

What have you tried so far? Is there a specific part of this task you are stuck at? The way you have worded it, it seems to be a request for someone else to do your work for you.

venkatesh@India 19-Jun-15 5:59am

Generated random number adding in arraylist check already exist not.Working fine .But i want alternate way to do this.

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)

CPallini · Answer 1 · 2015-06-18T23:38:00

Solution 1

I would insert then numbers 1..1000 in a container (e.g. a List<int>) then remove all the ones already recorded in the database and eventually randomly choose among the remining ones.

Posted 18-Jun-15 23:38pm

CPallini

Comments

Maciej Los 19-Jun-15 5:53am

Very good advice!

CPallini 20-Jun-15 11:58am

Thank you, Maciej.

venkatesh@India 19-Jun-15 6:02am

If i remove the records.But more number no users will do same action means getting error.

Philippe Mori 22-Jun-15 12:43pm

Not clear!

jaideepsinh · Answer 2 · 2015-06-19T01:49:00

---Create Below function to generate Random Number

CREATE FUNCTION dbo.RandomNumber()
RETURNS INT
AS
BEGIN
DECLARE @Result INT

SET @Result = CRYPT_GEN_RANDOM(2)

RETURN CASE
WHEN @Result < 60000
OR @@NESTLEVEL = 32 THEN @Result % 10000
ELSE dbo.RandomNumber()
END
END

---Use function to insert generated Random Number

DECLARE @Number INT
GenerateNumber:
select @Number=dbo.RandomNumber()
If Exists(select * from [Table] where number=@Number)
GOTO GenerateNumber;
Else
Insert @Number

Lucifier Rocks · Answer 3 · 2015-06-22T02:19:00

Solution 3

C#

do
  {
      number = random.Next();
  } while (randomNumbers.Contains(number));

try this

Posted 22-Jun-15 2:19am

Lucifier Rocks

Comments

Philippe Mori 22-Jun-15 12:42pm

This will eventually cause an infinite loop or major slowdown when the list is becoming empty.

Select random number without duplicate.

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us