Make CRUD Form in Visual Studio using Visual Basic and MS Access

Make CRUD Form in Visual Studio using Visual Basic and MS Access

Hello guys, today in this tutorial I will teach you how to we can make CRUD application form in a visual studio just using visual basic and Microsoft access.

Before you start this tutorial, there are some requirements.

  • Visual Studio with Visual Basic package
  • Microsoft Access

The complete application looks like this.

To make it easier, I have divided this tutorial into four parts.

  1. Creating a database in MS Access
  2. Connect that database to visual studio
  3. Design application
  4. Write some coding so that our form can function

Creating a database in MS Access

  • First, open your MS Access then choose “Blank desktop database”
  • Click on the folder icon to choose a location where you want to save your database.
  • Give a name “StudentData” and Save as “2002-2003 format” then click on “Create”

After this, click on “View” and give a table name “StudentTable” then fill fields along with their Data Type.

Then fill up the “Field Name” along with their “Data Type” and Save

After that to save data on a database, just double click on “StudentTable” which you find on the left side. Then fill some data and save

Connect this database to visual studio

  • Open Visual Studio then creates a new project by clicking on “New Project”
  • Choose a template “Visual Basic”, give a name for your project “StudentForm”
  • Browse a location where you want to save your project then click on “ok” to save

To connect a database, go to “view” (on the top bar) > “Other Windows” > “Data Source” then data source window will appear.

connecting database

  • Click on “Add New Data Source”, choose “Database” > “Dataset”
  • “New Connection” > “Microsoft Access Database File” > Browse to a location of a recently created database file.
  • Test the connection then click ok

 

connect database

  • After you click the “Next” button then message window pop-up.
  • If you click on “Yes” then it will create a copy of database file on your project folder.
  • But if you choose “No” then the project will use an actual database file.
  • At this time continue with No
  • Next > Select “Tables” > Finish
  • By default, it was in “DataViewGrid” but this time we are going to use “Details”

Select “StudentTable”, drag it and drop it on the form.

drag dropSelect all then change the font size to 12. And make a suitable space between elements.

Search for “RadioButton” on toolbox then drag it and drop it on the form along with “Gender” for two times. Then change their Text and Name.

  • RadioButton1: Text = Male and Name = radMale
  • RadioButton2: Text = Female and Name = radFemale

And also change their font size to 12.

Now select GenderTextBox and make it ReadOnly: True

To display a cross-ponding text on a GenderTextBox after a user clicks on a radio button. First, just double click on the Male radio button. Then write the following code.

If radMale.Checked Then
   GenderTextBox.Text = radMale.Text
End If

Also, do the same thing for Female radio button.

If radFemale.Checked Then
    GenderTextBox.Text = radFemale.Text
End If

You can check whether your application is working or not by clicking on the “Start” button on the top bar.

run projectThen you will get a window like this.

first viewAfter you run the application, you notice that Text on a GenderTextBox changes when you switch between Male and Female radio buttons. But changes did not reflect on these radio buttons if you go to Previous or Next record.

Now, to solve this issue. Just double click on “StudentTableBindingNavagitor”

fixing issueThen write the following code.

If GenderTextBox.Text = radMale.Text Then
   radMale.Checked = True
   ranFemale.Checked = False
ElseIf GenderTextBox.Text = radFemale.Text Then
   radFemale.Checked = True
   radMale.Checked = False
End If

Now if you run the application, that problem did not occur.

Creating buttons for Save, Delete, Add Next, Next and Previous operation

So go to a toolbox, search for a button and drag it on the form for 5 times. Then change their text and name.

  • Previous = Text: <<<, Name: PreBnt
  • Save = Text: Save Data, Name: SaveBnt
  • Delete = Text: Delete, Name: DeleteBnt
  • Add New = Text: Add New, Name: AddBnt
  • Next = Text: >>>, Name: NextBnt

Select all these buttons and arrange them.

formatingThen write a code for a Previous button.

StudentTableBindingSource.MovePrevious()

After that code for the Next button.

StudentTableBindingSource.MoveNext()

Code for Save data button

Try
   StudentTableBindingSource.EndEdit()
   TableAdapterManager.UpdateAll(StudentDataDataSet)
   MsgBox("Sucess")
Catch ex As Exception
   MsgBox("Error occur, Please recheck the fields and try again.")
End Try

Code for the Delete button

StudentTableBindingSource.RemoveCurrent()
TableAdapterManager.UpdateAll(StudentDataDataSet)
MsgBox("Current Record Deleted")

Last code for Add New button

StudentTableBindingSource.AddNew()
radMale.Checked = True
GenderTextBox.Text = radMale.Text

And this is one of the ways to make CRUD windows application form in Visual Studio using Visual Basic and Microsoft Access.

You may also like to make a registration form using MySQL and PHP.

Also, check out a video of this tutorial.

Share this post