Adding and Saving Records to Access Database using VB.NET Tutorial

This is a continuation of my other tutorials entitled Search and Retrieve a Record from Access Database and VB.NET. But here, we will focus on adding and saving a record into an access database. Now, let's start this tutorial! 1. Create an access file with the table and entities like the image below. Name your access database as sample.mdb(2003 format). 2. Create a Windows Form Application in VB.NET for this tutorial by following the following steps in Microsoft Visual Studio: Go to File, click New Project, and choose Windows Application. 3. Next, add another Button for adding records (Assume that we are done with the search button here as you will open the link I have write above.) named btnAdd and labeled it as "Add". This will add and save the inputted texts in all our textboxes. Insert 4 textbox named txtSearch for the searching of student number as this is the primary key, txtName for Student Name, txtCourse for Student course, and txtSection for student section. You must design your interface like this: 4. Create a module in your project and named it, modConnection. Import Imports System.Data.OleDb library. This library package is for ms access database. In your module connection, initialize the following variables. Now, create a method named connection to have the connection string. This will locate the sample.mdb access database that we have created earlier. Full code of the modConnection module. 5. Back to our form, put this code for the form_load. We will call the connetion() method that we have created in our module. Because we all know that module is access throughout the entire program. 6. For the btnAdd as adding and saving records to database button, put this code below. We will first create a try and catch method to have the exception handling. Here, we will use the OleDbCommand with the method of connection, CommandType.Text, and CommandText, with the OleDbDataReader to execute the CommandText. Note: The sql syntax "INSERT INTO tblStudent (Snum,Sname,Scourse,Ssection) VALUES (@Snum,@Sname,@Scourse,@Ssection)" is for adding and saving of records to the database. Snum,Sname,Scourse, and Ssection are our entities and @Snum,@Sname,@Scourse,@Ssection are our parameters. Now, have your parameters hold the value inputted in your textboxes that you have created earlier in the interface. To run the command of our parameters put this code below. Execute the non query and have a message of "Record Saved" after execution. Clear all the textboxes after saving the records. And don't forget the Exit Sub command at the end of your Try method. This will terminate the sub process of trying to add again another record. Then to catch the error, put this in your catch method. Here is the full source code of our tutorial for adding and saving records with search also. Output: The database is located inside the Debug folder of Bin. Best Regards,

Engr. Lyndon R. Bermoy
IT Instructor/System Developer/Android Developer
Mobile: 09079373999
Telephone: 826-9296
E-mail:[email protected]

Visit and like my page on Facebook at: Bermz ISware Solutions

Subscribe at my YouTube Channel at: SerBermz