Student Database

Submitted by thuhChief on Tuesday, August 27, 2013 - 09:34.

Language

This source code will perform basic operation of a database like record navigation, add new, and delete record.

Imports System.Data.OleDb
 
Public Class frmStudentDB
 
    Private Sub frmStudentDB_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'UniversityDataSet.Student' table. You can move, or remove it, as needed.
        Me.StudentTableAdapter.Fill(Me.UniversityDataSet.Student)
 
    End Sub
 
    Private Sub btnPrevious_Click(sender As System.Object, e As System.EventArgs) Handles btnPrevious.Click
        'Moves to the previous record
        StudentBindingSource.MovePrevious()
    End Sub
 
    Private Sub btnNext_Click(sender As System.Object, e As System.EventArgs) Handles btnNext.Click
        'Moves to the next record
        StudentBindingSource.MoveNext()
    End Sub
 
    Private Sub btnAddNew_Click(sender As System.Object, e As System.EventArgs) Handles btnAddNew.Click
        'Adds a new record
        StudentBindingSource.AddNew()
    End Sub
 
    Private Sub btnSave_Click(sender As System.Object, e As System.EventArgs) Handles btnSave.Click
        'Saves the new record
        StudentBindingSource.EndEdit()
        StudentTableAdapter.Update(UniversityDataSet.Student)
    End Sub
 
    Private Sub btnDelete_Click(sender As System.Object, e As System.EventArgs) Handles btnDelete.Click
        'Deletes  the current record
        StudentBindingSource.RemoveCurrent()
    End Sub
 
    Private Sub btnExit_Click(sender As System.Object, e As System.EventArgs) Handles btnExit.Click
        'Exits the program
        Me.Close()
    End Sub
End Class

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Add new comment

127 views