You must Sign In to post a response.
  • Category: Visual Studio

    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.
  • #754718
    Sir pls find the attachment


    Delete Attachment

  • #755299

    in query side filter the query by course,branch,year,regno

    if the query is found contains more records further filter with @@identity

    this is used to generate last inserted value.

    the regno is generated by substring of branch,year,course etc

  • Sign In to post your comments