Generate sequence of numbers prefix with an alphabet

Question

I would like to generate a sequence of numbers as "A0000"(ie.. an alphabet followed by 4numbers not randomly generated numbers).

I have gone through this article which is done with Sql Server similarly how can I achieve it in VB.Net.

Here is the code for SQL Server:

create function CustomerNumber (@id int) 
returns char(5) 
as 
begin 
return 'C' + right('0000' + convert(varchar(10), @id), 4) 
end

Any suggestions are welcome.

How do you plan to create it in VB.Net and prevent duplicate ID's? — mellamokb
– mellamokb, Commented Jan 30, 2013 at 16:33
I want the user ID to be generated automatically on the form load event not accepting any duplicates by checking it with the previously entered values in database. — coder
– coder, Commented Jan 30, 2013 at 16:35
Is the application used by only a single user at a time? What if user A loads the form, gets an ID, then user B loads the page as well before user A finishes submitting the form and gets the same ID? — mellamokb
– mellamokb, Commented Jan 30, 2013 at 16:42

Antonio · Accepted Answer · 2013-01-30 17:02:29Z

4

The same function in VB.NET:

Function CustomerNumber(id As Integer) As String
    return "C" & id.ToString("0000")
End Function

edited Jan 30, 2013 at 17:02

answered Jan 30, 2013 at 16:38

Antonio

9,89215 gold badges63 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tim Schmelter · Accepted Answer · 2013-01-30 16:46:32Z

2

This should do the same:

"C" & id.ToString("d4")

Demo

answered Jan 30, 2013 at 16:46

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

6 Comments

Scott Selby Over a year ago

this will be "C456456" if input id is 456456, I'm not sure what OP was asking for , but this isn't 4 digits

coder Over a year ago

Thanks tim for your time..:)

Antonio Over a year ago

I aswered a lot of time before and my answer is the same! T_T

Tim Schmelter Over a year ago

@SysDragon: Yes, but your answer results in a compiler error. ideone.com/hLKiCY You've probably meant .ToString("0000").

Tim Schmelter Over a year ago

@SysDragon: 1. this was the first working solution 2. i'm not the one who accepts 3. ToString(0000) is not the same as ToString("d4") 4. upvoted your answer because it works too (it's not fair to downvote competitive answers btw)

|

Collectives™ on Stack Overflow

Generate sequence of numbers prefix with an alphabet

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related