My doubt is that is it possible to create incrementing bill no. such as ABC00,ABC01,ABC02,ABC03,ABC04... etc. in ascending list
I already know how to increment with numerical numbers like 0,1,2,3,4,...in ascending list
I tried concatenation of numerical part with string part.But it works only once;further run leads to error because compiler cannot select maximum from alphanumeric numbers.
This is my code for numerical incrementation
Public Sub AutoEmployeeIDNo()
Dim strselect As String
Dim cmd As New OdbcCommand
Dim conn As OdbcConnection = ConnectionClass.confun
strselect = "Select cuscode from customerdet order by cuscode desc limit 1"
cmd.CommandText = strselect
cmd.CommandType = CommandType.Text
cmd.Connection = conn
Dim value = cmd.ExecuteScalar()
If (value = Nothing) Then
cuscode = 1
cuscode = value + 1
cusRegcode.Text = String.Concat(cuscode)
Can anybody help me ..