Need to get the current sql identity number or any number within a table and increment by one. I need this to be done during the OnLoad event of a form. basically it will autogenerate an id number incremented by one everytime a form is loaded. I am using Dreamweaver VB.Net. I am also using SQL 2005 Server. Please, I need your help ASAP. Thank You!!