If all you want to do is create a unique ID for a record, the auto_increment feature in MySQL will do the job nicely. Sometimes, however, you need more functionality. Unfortunately, unlike Oracle or PostgreSQL, MySQL doesn't have native support for the nextval() function, so creating real sequences is a little more challenging. First, we need to define what we want the nextval() function to achieve. We want to be able to begin the sequence with any number, and auto increment in multiples of any number, not just 1, including negative integers (-1 for example).

This is a simple database application. Using vb.net 2010, ms access 2007, crystal report 2008. The many options in this application such as: Insert, Update, Delete, Search, Navigation, DataGridView filteration, Patient code auto genration, Print Report etc etc... This tutorial for beginners only, like me.. I hope this application is very helpfull for any type of database application development in vb.net... So "Happy Programming"