Advertisement
binjeeclick

mod

Nov 30th, 2018
218
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 0.72 KB | None | 0 0
  1. Imports MySql.Data.MySqlClient
  2. Module Example
  3.     Sub Main()
  4.         Dim cs As String = "Database=testdb;Data Source=localhost;" _
  5.             & "User Id=testuser;Password=test623"
  6.         Dim stm As String = "SELECT VERSION()"
  7.         Dim version As String
  8.         Dim conn As MySqlConnection
  9.              Try
  10.             conn = New MySqlConnection(cs)
  11.             conn.Open()    
  12.             Dim cmd As MySqlCommand = New MySqlCommand(stm, conn)
  13.             version = Convert.ToString(cmd.ExecuteScalar())
  14.             Console.WriteLine("MySQL version: {0}", version)
  15.         Catch ex As MySqlException
  16.             Console.WriteLine("Error: " & ex.ToString())
  17.         Finally
  18.             conn.Close()
  19.         End Try
  20.    End Sub
  21. End Module
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement