HowToDeveloptheAutoIncrementvalues inpageload using asp.net

Question

Hi Every Buddy Hope you all r Good. I faced small Problem Please Give Suggestions . i need How to develop the Autoincrement Job Ids .Ex:Jd101+CurrentDate . when Page Load Display The textBox Automatically IDs in my Form please Help me...

Venkat Kumar · Answer

hai please check this. It may helps you. Random random = new Random(); for(int i=0; i { s=random.Next(10200); //To specify the range for random numbers } refno = Convert.Toint32(DateTime.Now.ToString(ddMMyyyy))+s;

Abhay Shanker · Answer

Hi you can achieve this by setting an auto increment column in table. Get the latest value of the column and concatenate the today's date on page load.