MYSQL CRUD Using Custom Function In VB.Net

In this article I will share my way to Mysql CRUD using vb.net by creating custom functions. Why custom function, because this function I created itself to simplify and shorten the program to CRUD data from the database by calling the function. So we no longer need to type the insert, update and delete commands in the sql query.

Step 1: Create Function For Connect To Database

• Open Visual Basic .Net
• Create New Project
• Add New Module (Right click on Project Name at Solution Explorer - Add - Module)
• Let its name Module1.vb
• Add to Reference : MySql.Data.Dll

Type codes below to Module1:

Imports MySql.Data.MySqlClient Module Module1 Public conn As New MySqlConnection Public errorDescription As String Public server As String = "127.0.0.1" 'based on your server Public username As String = "root" 'default user in mysql Public password As String = "12345678" 'on my server i give this password Public database_name As String = "exercise1" 'for testing i create exercise1 dbname Public Function bejoDBConnect() As String If Not conn Is Nothing Then conn.Close() conn.ConnectionString = String.Format("server={0}; user id={1}; password={2}; database={3}; pooling=false; Convert Zero Datetime=True", server, username, password, database_name) Try conn.Open() Return "OK" Catch ex As Exception errorDescription = ex.Message Return ex.Message End Try End Function End Module1

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