automatc id genaration

Question

hi friends ...............
        i need automatic id generation code .....there is a registration form.when ever a customer press the add button then immediately generation id (like 001) and store the details with id in database ..... i am using microsoft visual studio 2008 and sql database...