07-Add Academic Year


Last time we have finished the “Year Level” module of the student. Now, we will add another module which is “Academic Year” in the settings. This module allows you to manage the “Academic Year” of the students that contain adding, updating,retrieving and removing. We are now going to focus on how to add the “Academic Year” in Ms Access Database using Visual Basic 2008.


Let’s begins:


Open the project that I have created previously which is “StudentInformation” and do the Form just like this.
After setting up the Form, double click the “Save” Button inside the “Academic Year” GroupBox and do this following code for saving the “Academic Year” inside the event handler of a Button. It will look like this.
[vbnet] Private Sub btnsySave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsySave.Click
‘opening the connection
‘store a query to a variable that you have declared.
query = “INSERT INTO tblsy (SY) VALUES (‘” & txtsy.Text & “‘)”
‘set a query and a connection string to a class that you have declared.
da = New OleDb.OleDbDataAdapter(query, con)
dt = New DataTable
‘Filling the data in the datatable

MsgBox(“New School Year has been saved.”)

Catch ex As Exception
‘catching error
End Try
End Sub


Readers might read also:



Facebook Comments


  1. Creative programs for example computer graphics, will
    need a portfolio of the best product, a meeting, official
    test scores, official transcripts, several recommendations, an application essay,
    and a credit application fee. Be it observational,
    communication, managerial skills, the methodologies teaching
    assist them to get a grip on the subject and stay a part of the industry.
    They are not time consuming, in addition they lower your expenses and most importantly labour
    and energy.

  2. Developing outline for essay writing makes a student write his essay faster and
    efficiently. While writing an essay, certain tips will assist you to allow it to be a fantastic one.
    You should also plan and outline how to show the point is
    tightly related to your thesis statement.

  3. Trust me, each business school around just isn’t trying to find a similar thing.
    The topic should also be one which provides the students enough to write on. This will
    allow that you uncover issues that others may have missed and definately will
    result in the means of writing that essay a whole
    lot of more fun.


Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.