Geeks' Lounge is not the place to be asking your code/project related questions (last I checked)
You're developing a project for what purpose?
You're using MS SQL and VB.Net and it never occurred to you to allow the DataBase to do the id auto-generation for you as part of it's own ID column management?
Geeks' Lounge is not the place to be asking your code/project related questions
Posting to try to be helpful as opposed to just neg-voting (which I came very close to doing) and hoping a MOD just pops this thread into the right place instead of deleting it for being in the completely wrong place.
I hope I'm in the proper Forum for posting the following solution. :icon_eek:
Dim myChars() As Char = "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890"
Dim idString As String = ""
For idLength As Integer = 0 To 9 '// this will return a 10 character ID number.
Dim i As Integer = Rnd() * (myChars.Length - 1)
idString &= myChars(i)