generating random numbers in texbox and then submit to database. code should check if the generated number already exist in database before submiting to database.
View 1 Replieshow to start/formulate codes on this.I want that in every form load, textbox1 will generate autonumber and random number for textbox 2.
View 2 Repliesis it possible to make an online form generate a random reference number unique to that form?
I'm using C# and .net 3.5
Recently, I am working on the website where I am generating random number and storing it in database as the primary key. So, this key would be foreign key for many table, now how would I generate the random number and check if random number does not have duplication? Is there any function to check if number is not duplicate?
View 1 RepliesI want to generate a unique random number everytime a user submits a form. As the form is submited the data of the form should be placed in a database and a unique random number should be generated so that the user can later use this unique random number to reterieve his details from the database that refer to his unique random id. The unique random number should be atleast 9 digits long.
View 3 RepliesI want to generate a 16 digit random account number that should be unique in database for every new user of my website. kindly guide me how can i generate a 16 digit unique number.obviouly i understand that i would have to check that number in my database table for uniqueness and if that generated number already exist then i would have to generate it again.
View 11 RepliesI would like to create a confirmation number using both letters and digits just like when you book your flights, the confirmation number looks like '9Z3RG6R'
View 7 RepliesI'm trying to implement a code that will generate a fix lenth alphanumeric code; number from 0...9 and capital letters A...Z. I want the code to be formated as this: XXX-XXX (where X representes a random character between 0...9 and A...Z). It doesn't matter if the letters and/or the numbers repete. But it will be great if the don't. I'm using VB.Net. How can I do this?
View 4 RepliesI have a feedback form in my website. After submitting the feedback (using Submit button), form's Reference number should generate and showed to the user (with successful message) in a "Pop up" as below:
i.e, your feedback is submitted successfully. Your refrence number is 'xyz10'
This refrence number should be unique for every user who fills the feedback form.
I need to generate a random number which starts fro 750000 and should increment one by one for generating other number.
ex: 750000
second it shoul dbe 750001
I want to generate simple random number in webpage ... like remain one button,when I clicked show a random number.
View 6 RepliesI need to generate random number in oracle.i need to get always 3 digit random number(100 to 999)
View 5 RepliesHow can I generate a 7-digit random number and special character string in a textbox on a button click event, in VB.Net?
View 2 RepliesI've web page with 1 textbox.
If I open that page I want to display a random number between 0-9 in that text box, how?
I'd like to generate an OId number in a specific textbox on a specific page which comes out of date and time, for example if today is may 27th 2010, 9:45 am,it will generate the number 270520100930
date: 27
month: 05
year:2010
time: 0930
How do I generate a unique number in c# without the database? (max 17 digits). EDIT: digits only.
View 2 RepliesI am a beginner in ASP.NET using VB Code. I want to generate a Unique reference no by concortinating three column fields.Example:
Column unique reference no (System Generated) - 10
Column with Product Code (User Entry) - APPLE
Column with Product Title (User Entry) - FRUITS
Unique ref No = FRUITS/APPLE/10
I want to concatenate this three fields to the column Unique Ref No.
I want to generate a unique random number everytime a user submits a form. As the form is submited the data of the form should be placed in a database and a unique random number should be generated so that the user can later use this unique random number to reterieve his details from the database that refer to his unique random id. The unique random number should be atleast 9 digits long.
View 5 Repliesi want to generate random URL for the users who want to download my file which is located in my server (http://servername/book/book.pdf) after he bought from us. and that URL should expire after few days lets say (1 week) .
View 2 RepliesI am generating a unique Ref number using this sql statement: SELECT REPLACE(STR(CAST(CAST(NEWID() AS binary(5)) AS bigint),12),0,0) as REF Subsequently, I need to insert this REF into sql database table in stored procedure. Here is what I did in my stored procedure:
USE [iBankRecords]
GO
/****** Object: StoredProcedure [dbo].[stp_addPayee] Script Date: 07/05/2010 21:57:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[stp_addPayee]
(
@CUSTID char(10),
@PAYEEACCNUM nvarchar(20),
@PAYEEACCTYPE char(10) ,
@PAYEENAME char(20),
@PAYERINITIAL char(20),
)
AS
DECLARE
@ReturnValue int
INSERT INTO PAYEE (CUSTID, PAYEEACCNUM,PAYEEACCTYPE,PAYEENAME,PAYERINITIAL, REF)
VALUES (@CUSTID,@PAYEEACCNUM,@PAYEEACCTYPE,@PAYEENAME,@PAYERINITIAL, REF)
IF @@ERROR<>0
BEGIN
PRINT 'ERROR'
SET @ReturnValue=1
RETURN @RETURNVALUE
END
ELSE
BEGIN
SET @ReturnValue=0
RETURN @RETURNVALUE
END
May I know how do I have generating a unique ref num and inserting the REF into the above statement?
a control or some code I can use to generate a random testimonial from a selection of testimonials.
I want a random testimonial to appear each time a page is loaded.
This site does not currently use a database so a solution that uses a text file or spreadsheet is preferred.
How to generate a employee code in textbox automatically while in run time in web application.......when i run the page it will check the employee code in the database and it automatically shows the next value in the textbox how?
View 1 RepliesRandom rand = new Random((int)DateTime.Now.Ticks);
int numIterations = 0;
numIterations = rand.Next(1, 50);
Response.Write(numIterations.ToString());
Response.Write(' ');
numIterations = rand.Next(1, 50);
Response.Write(numIterations.ToString());
Response.Write(' ');
numIterations = rand.Next(1, 100);
Response.Write(numIterations.ToString());
Response.Write(' ');
numIterations = rand.Next(50, 100);
Response.Write(numIterations.ToString());
[Code]....
This is what i have so far. first 2 number gives 1-50, then 1-100, then last two give 50-100
now i need to make the first 2 numbers give even or odd numbers. how can i do this?
i will set a random number for uploading files. how could i do that?
is it possible to set a random name with 20-50 characters?
Not sure if I'm approaching this correctly but this is what I've got and what I'm trying to do
I have a table with 10 Labels in it (Labels Id A1 thru A10)
I'm trying to have each label assigned a random number using 0-9
Need to have each labels number value different from the other
Code Below:
Randomize()
A1.Text = Int(Rnd() * 10)
A2.Text = Int(Rnd() * 10)
A3.Text = Int(Rnd() * 10)
A4.Text = Int(Rnd() * 10)
A5.Text = Int(Rnd() * 10)
A6.Text = Int(Rnd() * 10)
A7.Text = Int(Rnd() * 10)
A8.Text = Int(Rnd() * 10)
A9.Text = Int(Rnd() * 10)
A10.Text = Int(Rnd() * 10)