I trying to add my text box data to ms access database using vb2010, i connected my database with vb using connection wizard. In your module connection, initialize the following variables. This library package is for ms access database. Create a module in your project and named it, modConnection. You must design your interface like this:Ĥ. 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. This will add and save the inputted texts in all our textboxes. 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'. 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.ģ. Name your access database as sample.mdb(2003 format).Ģ. Create an access file with the table and entities like the image below.
But here, we will focus on adding and saving a record into an access database.ġ.
This is a continuation of my other tutorials entitled Search and Retrieve a Record from Access Database and VB.NET.
