MYSQL CRUD Using Custom Function In VB.Net (Part 3)

Step 2: Back - Create Function For Insert, Update And Delete Data

Step 3: Testing The Function in Form1

• Create Database exercise1

Create database on mysql. You can execute query below in your mysql management database :

CREATE DATABASE exercise1; USE exercise1; DROP TABLE IF EXISTS `t_teacher`; CREATE TABLE `t_teacher` ( `id` int(5) NOT NULL AUTO_INCREMENT, `full_name` varchar(20) NOT NULL, `sex` varchar(5) NOT NULL, `address` varchar(220) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

• Design Form1, Please design form like picture below:

• Copy And Paste code below to your form1 code:

Public Class Form1 Dim fullName As String Dim sex As String Dim address As String Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click fullName = TextBox1.Text sex = TextBox2.Text address = TextBox3.Text Dim fieldsArray As String = "full_name,sex,address" 'these are field name on t_teacher (separates by comma) Dim valuesArray As String = "'" & fullName & "','" & sex & "','" & address & "'" 'separetes by comma If bejoInsert("t_teacher", fieldsArray, valuesArray) Then MsgBox("Successfull Inserted", vbInformation) Else MsgBox(errorDescription, vbCritical) End If End Sub End Class

• Run your project by press F5
• You can test input and save data