HOW TO CREATE COMMON ID NUMBER IN VB.NET

FUNCTION FOR CREATE COMMON ID NUMBER
-------------------------------------------------------------------------------------
Public Sub idno() '
Dim dt As New DataTable
Dim cal As String = "select staff_id_no from tb_staff order by staff_id desc"
dt = obj.call1(cal)
If dt.Rows.Count > 0 Then
Dim idno As String = dt.Rows(0)("staff_id_no").ToString
Dim length As Integer = idno.LastIndexOf("/")
Dim length1 As Integer = length + 1
Dim totlength As Integer = idno.Length
Dim totlength1 As Integer = totlength - length1
idno = idno.Substring(length1, totlength1)
Dim idno1 As Decimal = Convert.ToDecimal(idno)
Dim idno2 As Decimal = idno1 + 1
Lblidno.Text = "ANU/09/" + idno2.ToString
Else
Lblidno.Text = "ANU/09/1001"
End If
End Sub
-------------------------------------------------------------------------------------

1 comment:

Anonymous said...

UaWcNLATfY Vegas Casino cM5hn6Qdk Ameristar Casino bUSFrXBIEc Online Casino Gambling HOC7Ny0vRb Mystic Lake Casino uj3BIGQ9Z Agua Caliente Casino MRYryQTvj Casino 99 f5PjkhrKp Mandalay Bay Casino PBH6e7dUvF Free Casino Slots