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 3 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 5 RepliesI have a form and I want each form to have a unique number when it is filled out so it will go into the database. How can I set this up so when the page loads in the label it will say 1 then the second time it loads it will say 2?
View 1 RepliesI have an ID field where I need to insert unique ID's
the ID should be like -
S- (YY)(MM)9999. where, (YY) is year, (MM) is month and 9999(is a four digit random number)
for example - S-11030001
is 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 Repliesgenerating 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 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 RepliesI need to generate a Unique Reference number that has 7 digits.
It should be formatted in the following way:
1st: B (Ball), G (Gift), C (Cat)
2nd: represents year of booking A(2010), B(2011),C(2012), etc
3rd: represents the month of booking J(Jan),F(Feb),M(Mar),A(Apr),Y(May), U(Jun), L(Jul),G(Aug), S(Sep),O(Oct),N(Nov),D(Dec)
4th: days of booking A(1st) - Z(26th), 1(27th) - 5(31st)
5,6,7th: These are counters for the number issues each day. Each can be A-Z,0-9 giving a total of 46,656 combinations. So 0 is first, then 1, 2, 3, 4, 5, 6, 7, 8, 9, A-Z, then 00 to 0Z, then 10 to 1Z, then 20 to 2Z, etc
Now , the 1st Digit is a Character that I generate based on a condition and that shouldn't be a problem.
How can I generate unique numbers in JQuery? I use the unique numbers for the Shopping Cart ID.
View 6 RepliesHow do I generate a unique number in c# without the database? (max 17 digits). EDIT: digits only.
View 2 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 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?
I was able to find examples throughout the internet that more or less accomplished what I needed to be done, but now I have run into some problems. I need to be emailed the form data when the users submits it and then the user needs to be redirected to a thank you page, in this case "thanks.asp". I have been unable to get the form to redirect users to the thanks page, and in my efforts I think I might have messed the email process up as well.
[Code]....
i have a form which has two textboxes and a submit button.on entering data and submitting data gets stored in the database.but if i again refresh the page the same data again gets stored.How should this be prevented?
View 3 RepliesHow generate the unique no. 1,2,3 and so on .... on button click of each new user ..
the code mentioned below is a readwrite coding in vb.net ...
but the problem is it generate the same id for different users on button click event... but i want the no. of times button clicked the new ids will be generated
[code]....
how to pull a RANDOM item from the database when using LINQ. There seems to be a couple of differnet ways to handle this. What I need to do though is pull a RANDOM item from the database that the user has not seen before.
The data I am pulling from the database is very small. Is there any way I can just hit the database once for 1000 records and then randomly scroll through those?
Should I put a cookie on the users system recording the IDs of which items they have seen, pull a random record, check to see if it is seen and if so, pull from the database again? That seems like performance issues just waiting to happen.
i 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 Replies