Characters and year with Auto increment number.

Question

I want to make a unique ID code for example: TRSVDSI-16-0001.  TRSVDSI is permanent 16 is the last 2 digit of the current year and 0001 is the auto increment number. Whenever I add new client its client code should be TRSVDSI-16-0002 TRSVDSI-16-0003 TRSVDSI-16-0004 and so on... please give me some vb.net codes on your mind that can guide me making my unique id code. Thank you in advance.

Manas Mohapatra · Answer

Try like that: Private Sub GetClientNo() cmd = New MySqlCommand() cmd.Connection = conn Try sqL = SELECT CLientNo FROM Clients Order By ClientNo Desc ConnDB() cmd = New MySqlCommand(sqL conn) dr = cmd.ExecuteReader(CommandBehavior.CloseConnection) If dr.Read = True Then txtClientNo.Text = TRSVDSI- + DateTime.Now.Year.ToString().Substring(2 2) + - + (dr( ClientNO ) + 1).ToString().PadLeft(4 0 C) Else txtClientNo.Text = 0001 End If Catch ex As Exception MsgBox(ex.Message) Finally cmd.Dispose() conn.Close() End Try End Sub

Richard Ian · Answer

sirManas Mohapatrai have here the code on my sample but the result is 1234 and soon please tell me where i will insert your code. thank you Private Sub GetClientNo() cmd = New MySqlCommand() cmd.Connection = conn Try sqL = SELECT CLientNo FROM Clients Order By ClientNo Desc ConnDB() cmd = New MySqlCommand(sqL conn) dr = cmd.ExecuteReader(CommandBehavior.CloseConnection) If dr.Read = True Then txtClientNo.Text = dr(ClientNO) + 1 Else txtClientNo.Text = 0001 End If Catch ex As Exception MsgBox(ex.Message) Finally cmd.Dispose() conn.Close() End Try End Sub *the txtClientNo.Text is the field where the id will show up.

Manas Mohapatra · Answer

Try with below code: Let's say number an increment variable which is integer type. VB Dim number As Integer = 9 Dim temp As String = TRSVDSI- + DateTime.Now.Year.ToString().Substring(2 2) + - + number.ToString().PadLeft(4 0 C) C# int number = 9; string temp = TRSVDSI- + DateTime.Now.Year.ToString().Substring(2 2) + - + number.ToString().PadLeft(4 '0' );

Richard Ian · Answer

thank you so much for your help sir Manas Mohapatra!

Richard Ian · Answer

Thank you for your codes sir my only problem now is how to save the output to my database when I will try to view the info using another form it will show the basic one like 1234 and so on not my desired one.

Richard Ian · Answer

Based on my codes t he values showing in txtClientNo.Text is only 1234 and so on every time i add new client what I wanted sir is instead of 1 or 2 or 3 I wanted to change it toTRSVDSI-16-0001 next client will have the id code ofTRSVDSI-16-0002 and the next isTRSVDSI-16-0003 and so on. but for now the value show is txt.ClientNo.Text is only 1.

Manas Mohapatra · Answer

What are the values showing in txtClientNo.Text?? Give an example.