Visual Studio ASP.Net Using MySQL

If you using ASP.NET (.NET Framework)!

Simple way to connect to MySQL:

1. Add a new module (*if you are interested: using this method you can connect both MySQL and MSSQL databases at the same time.).

   Imports MySql.Data.MySqlClient
   

   Imports System.Data.SqlClient

   Module SQL
       Public Function GetConnectionMySQLServer() As MySqlConnection
           Dim conn As String = "server=xxx.xxx.xxx.xxx;
                                 user=xxx;
                                 database=xxx;
                                 port=xxxx;
                                 password=xxxx;"
           Return New MySqlConnection(conn)
       End Function
   
       Public Function GetConnectionSQLServer() As SqlConnection
           Dim conn As String = "server=xxx.xxx.xxx.xxx;
                                 User ID=xxx; 
                                 Password=xxx;
                                 Database=xxx"
           Return New SqlConnection(conn)
       End Function
   End Module
   

2. Exmaple of using:

   Imports MySql.Data.MySqlClient

   Public Class Page
       Inherits System.Web.UI.Page
   
   Protected Sub btnAplly(sender As Object, e As EventArgs) Handles btnAplly.Click
       Using con As MySqlConnection = GetConnectionMySQLServer()
           con.Open()
           Dim sql As String = "select count(*) as cnt from users"
           Dim cmd As New SqlCommand(sql, con)
           Dim read As MySqlDataReader = cmd.ExecuteReader()
           read.Read()
           label1.Text = "exist " & read.Item("cnt") & " users"
           con.Close()
       End Using
   End Sub
   End Class
   

if you using c# you can use: https://converter.telerik.com/