07-Add Academic Year

19
429

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.
addingsy_form1
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
Try
‘opening the connection
con.Open()
‘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
da.Fill(dt)

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

Catch ex As Exception
‘catching error
MsgBox(ex.Message)
End Try
con.Close()
End Sub
[/vbnet]

 

Readers might read also:

 

 

Facebook Comments

19 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.

  4. Keeping places of learning safe for students
    has become a effort that everyone must contribute to. If you attend a residential area college
    or tech school this can easily cover your classes and texts books,
    bringing you absolutely nothing to pay. Over many years, the
    primary reason for an One Year Executive MBA is usually to equip
    students with varied knowledge in general management, management,
    finance, marketing, logistics, hours and production.

  5. A few phrases to use sparingly and an eye out for in your own writing:.
    Stay away from spelling mistakes in blog writing – see the posts prior to
    deciding to post them on the blog to ensure there aren’t any typo errors.
    Generally, feedback through the panelists are given for the
    student(s) during or following the thesis proposal defense and final defense.

  6. They might even be coming from a more adult, as opposed to a secondary school student, perspective.

    Tarantino, the splendid scriptwriter, said,
    the point is for making little presents to yourself every day.
    Warning – always overestimate enough time it may need to accomplish a project.

  7. While you can feasibly create an essay containing a similar way of your school,
    the chances are not as likely you will probably have a robust essay without weaknesses
    with no professional to check it over. Conventional Wisdom says, “Essays defy standardization, so obviously fat loss to produce writing them easy. They are looking for one to allow us ideas and then communicate these ideas quickly along with your personal voice.

  8. When you happen to be including facts, it is essential to reference them based on the guidelines of the
    writing format your professor assigns. Showing a love for life along
    with the things you have accomplished should be the main focus from a admission essay.
    During this process, several other academics who’re experts in the field will read and assess a
    novel or article to make a decision whether it is of publishable standard.

  9. If you are planning to apply for a scholarship, it is vital that you just start early.
    Make use of images, sub-headings, lists, tables, colors and bold letters to spotlight the important areas within the
    blog. For example, it’s instead of it can be, can’t instead of cannot, isn’t instead of is not.

  10. Don’t be way too hard on yourself-the entire academic community hasn’t
    seen what I’m about to tell you, and they have been wrestling using this type of problem
    no less than since 1580, when Michele de Montaigne
    published his two volume work, Essais (French for English word,
    Essays; along with the meaning of the word is the same in both languages:
    to attempt, to attempt). The suspense elements that derail
    Oedipa from her activities as being a housewife starts at the beginning of the novel when she learns of Iverarity’s death and her
    subsequent journey to execute Inverarity’s will. If your essay rejects a commonly accepted opinion you need sub-ideas that may prove
    your point.

  11. ‘Commonplace’ is usually a translation through the Latin phrase ‘locus
    communis’, which suggests a sort or possibly style regarding using information, comparable to an argument of knowledge.
    Above all attempt to keep your dissertation topic is interesting to both you and your reader.
    Writing an analytical essay just isn’t a straightforward job and it demands performing a lot of homework.

  12. Aim for no less than 2 possibly at most 3, although in rare instances you could possibly only have one advantage that you just discuss in length.
    Their only objective is usually to cleanse your academic compilation, spruce up and create
    a mark for the team evaluating the essay. During secondary school, students are drilled
    in writing structured essays and taught the way to present
    their matter with clarity and conciseness so they are rewarded with grades of excellence.

  13. Excellent blog! Do you have any tips for aspiring writers?

    I’m planning to start my own website soon but I’m a little lost on everything.
    Would you recommend starting with a free platform like WordPress or go for a paid
    option? There are so many options out there that I’m
    completely confused .. Any ideas? Thanks!

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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