hi all,

how do i genere this serial in this format automaticcally? any workaround?

the format is (Prefix)(dd)(m)(yy)(001)

take a look at today generate serial number : MM04707002, MM04707003, MM047070042, MM04707005

thanks

 You can use this method, although you will have to work out your own procedure for incrementing the autonumber (perhaps use an IDENTITY field in your database):

        Dim autoNumber As Integer = 1
        Dim sbSerialNumber As New StringBuilder
        sbSerialNumber.Append("MM")
        sbSerialNumber.Append(System.DateTime.Now.ToString("dd"))
        sbSerialNumber.Append(System.DateTime.Now.Month)
        sbSerialNumber.Append(System.DateTime.Now.ToString("yy"))
        sbSerialNumber.Append(autoNumber.ToString.PadLeft(3, "0"))
        Response.Write(sbSerialNumber.ToString)

Yeah i'd do the same as above, however with that serial number, i would "SELECT Serial FROM dbtable" which gives you

MM010307002

MM010307003 

then run a function to grab the last 3 digits, then gra the biggest one..

Or, if you want a cleaner way of storing this serial number, maybe store the parts to the serial number in different coloumns, Say...

Code   Date   AutoNum

MM   100107   0001

MM 101010 0002

Then to get the next number use SQL : "SELECT MAX(AutoNum) FROM dbtable" (then add one to it....

for creating auto number in code , you can use below code instead of from database

DataColumn workColumn = workTable.Columns.Add( "CustomerID", typeof(Int32)); workColumn.AutoIncrement = true; workColumn.AutoIncrementSeed = 200; workColumn.AutoIncrementStep = 3;

thanks guys.. it works