As you have mentioned that the auto id is not the integer which should be generated automatically from the database side.
You need to make it as string in the Database.If you still want it to be integer then you need to store only the second part of your auto generated id i.e. 000001 or 000002 something like that.And then the other column should have the first part which looks like the current date and can be stored in the database as date column.
When retrieving, you just get the last part of the id, incremented by 1 and then append the current date and display to the user.
While saving, you just need to second part and store the current date in the second column which was date column.
by this way,you should be able to achieve your result.
Also I am not sure if you know that you will be storing only 1,2,3...and not 0000001,000002,000003 etc in the database. This is formatted string which you need to get in your .net code by formatting of ToString function.
Hope it will be helpful to you.Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator