asked on ASP.NET : Generate Unique Number of length 4 alphanumeric length where first character always start with alphabet
Hi EE,
I need help in generating the Unique Number of 4 character length.
Criteria is as follows :
Example
A001, A999, ZD01, DA9P, SXS8 etc...
I need to write a logic for the same in my ASP.NET (VB.NET) based web application.
Please provide a direction.
Regards,
D Patel
I need help in generating the Unique Number of 4 character length.
Criteria is as follows :
- String will always start with alphabet
- Another 3 characters will be a combination of alphabets (A-Z) and digits (0-9)
- Once the number generated it could not be repeat
Example
A001, A999, ZD01, DA9P, SXS8 etc...
I need to write a logic for the same in my ASP.NET (VB.NET) based web application.
Please provide a direction.
Regards,
D Patel
ASP.NETVisual Basic.NETMySQL Server
Last Comment
D Patel
Once the number generated it could not be repeat are you storing the generated number some where?
ASKER
Yes in MySQL table
thinking to have a stored procedure for data insertion and then build the logic for your field accordingly there?
then in your VB.NET program, you can call that stored procedure for data insertion.
then in your VB.NET program, you can call that stored procedure for data insertion.
ASKER
Can you please brief about it more Ryan Chong?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for your support.