I have a system that generates a invoice in the form of a pdf document. I just want to know, what is the correct way to generate a reference number for the invoice. Preferebly I want something in the line of D100001, D100002 etc. The "D" stand for the kids school grade "D", "E","F" etc.
View 4 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
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 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.
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 was thinking of formatting it like this
TYYYYMMDDNNNNNNNNNNX
(1 character + 19 digits)
Where
T is type
YYYY is year
MM is month
DD is day
N is sequencial number
X is check digit
The problem is, how do I generate the sequencial number? since my primary key is not an auto increment integer value, if it was i would use that, but its not.
EDIT can I have the sequencial number resets itself after 1 day (24hours).
P201012080000000001X <-- first
transaction of 2010/12/08
P2010120810000000002X <--- second
transaction of 2010/12/08
P201012090000000001X <--- First
transaction of 2010/12/09
(X is the check digit)
I am trying to add a web reference to an ASP.NET 2.0 application in Visual Studio 2008.However, the generated proxy classes do not include BeginXXXX and EndXXXX methods.Hcan I get these to be generated? Do I need to manually use wsdl.exe?(Incidentally in ASP.NET 3.5 apps, there is an option in the Add Service Reference box which lets me specify that Async methods should be generated. However, I am limited to ASP.NET 2.0 implementation).
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 RepliesHow 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 RepliesI need to generate sequential number for my new Users. For every user i need to show sequential number for their ID. it should be dynamic one.once they they click register i need to show this sequential number in Label.
View 3 RepliesI 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've scouted around and found partial answers to my question. If I insert a row into an orcle 9i db, what is the syntax in both the insert statement and then the .net code to get the id value so I can use it elsewhere?
View 2 RepliesI'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
public string ACtivationKey()
{
string allowedChars = "";
allowedChars = "a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,";
allowedChars += "A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,";
allowedChars += "1,2,3,4,5,6,7,8,9,0";
[Code] ....
I am generating a new order reference id in a class Called GeneratePdf.cs
I use it as
GeneratePdf gp = new GeneratePdf();
string orderunique = "ORD-" + gp.ACtivationKey();
var uniqness = db.OrdersMasters.Where(x => x.OrderRefNumber == orderunique).Select(x => x.OrderRefNumber).Count();
I want to run a check if the reference number is not present in database. if its present generate new ...
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 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?
how i can generate a gridview with a fixed number of rows that is entered from a textbox
my gridview has a column with dropdownlists the others contains textboxes?
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 Replies