OPRAG-OPREG

Dear everyone. hey there. herewith i would share again about VB.Net knowledge during my experiences developing system and using many data. at one day i need to make an auto increment number but it need to have year, day and month. i was thinking a moment at the time, how the way i do that ??? after juggling with several coding herewith which i can share with you today.. One: make a simple table to make it sure this code and meaning will be working well.  my table : TesIdOtomatis field : IdOtomatis Two : make a simple stored procedure to save your entity data. my stored procedure : INPUT_IdOto Three : make a new entity class my Entity Class : Public Class IdOtomatisEntity     Private _IdOtomatis As String     Public Overridable Sub DataOtomatis(ByVal IdOtomatis As String)         _IdOtomatis = IdOtomatis     End Sub     Public Property IdOtomatis() As String         Get             Return _IdOtomatis         End Get         Set(ByVal value As Stri