How to access the registration number from the database
Sir i will attach my project below. Actully i m working on a project in which 3 combo boxes that is branch name, Course,and year after that 2 text boxes that is enrolment id and registration number sir i want that when the user selected the value of comboboxes then enrollment id is generated automatically like this (Branch Name/Course/Year/Registration number of last student according to particuler selected course) sir all things have been done but i can not generate the last registered student number according to the course he is selected in Course combo box. Sir Please provide the sql code in my attached project.And one more solution that i want is the registration number is also generated like this(Branch name/Last registerd student) this registration number should be the last registered student number.