I really need some answer to resolve my problem. Here's the situation,
I wanted to create a student number using mysql database and vb.net in this form:
currentyear-(no. of student in record)
Student no. is auto generated.(the no. of student in record part)
I entered to school in the year 2006
I am student 141791
therefore my Student no. is 2006-141791.
Please let me know how to code it.
Tnx in advance.