Web Forms :: Generate Random Number In TextBox And Then Save To Database Using C#
May 7, 2015
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.
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?
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.
I 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.
I 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'
I'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?
I 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'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
I 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.
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) .
I 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?
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?