SETHA SITE INFORMATION

  • Increase font size
  • Default font size
  • Decrease font size

INSERT, DELETE, UPDATE AND SELECT Data in MS-Access with VB 2008

E-mail Print PDF

This article shows you how to write Visual Basic code using ADO.Net to manipulate data with Microsoft Access 2003 format. From this article you will know how to:

  • Use DataGridView control to get data from database
  • Use ADO.Net to Insert, Delete, Update, and Select data in MS-Access Database
  • Use SQL Statement for Inserting, Deleting, Modifying, and Selecting Data


Download Sample Code Here
  • Create Visual Basic 2008 Project: VB-Access
  • Assume that, we have a database file named data.mdb
  • Place the data.mdb file into ..\bin\Debug\ folder
    (Where the project executable file (.exe) is placed)
  • In data.mdb, there is a table named: student which consists of the following fields
    FieldData TypeDescription
    stdidNumberStudent's ID
    stdnameTextStudent's name
    genderTextGender
    phoneTextStudent's phone number
    addressTextStudent's address
  • Create New Form: frmStudent (as in image above)
  • Write code (Download Sample Code Here)

See video below
Part 1:

Part 2: