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
CERTIFIED EXPERT
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.