ASP.Net MySql: Check connection status of multiple databases in VB.Net

Question

HelloIm trying to check if i have succsessfully make connection to both databases but it always returns me falseWhat i want to do is i have 2 databases  test1 test2I want with the code to check if the information is correct and connects to both databases and if its ok show me resultPublic Function CheckMySqlConnectionAll As Boolean    Try        Dim serverName As String  DataSettingsMySQLServerHost        Dim userName As String  DataSettingsMySQLServerUser        Dim port As String

dharmendr · Accepted Answer

In If condition check the DatabasesExampleProtected Sub OnSubmitByVal sender As Object ByVal e As EventArgs Handles btnSubmitClick    If CheckMySqlConnectionAllDataSettingsAuthDatabase AndAlso CheckMySqlConnectionAllDataSettingsWorldDatabase Then        39 Do your task    End IfEnd SubPublic Function CheckMySqlConnectionAlldbName As String As Boolean    Try        Dim serverName As String  DataSettingsMySQLServerHost        Dim userName As String  DataSettingsMySQLServerUser        Dim port As String  DataSettingsMySQLServerPort        Dim password As String  DataSettingsMySQLServerPassword        Dim conStr As String  34server34  serverName  34user34  userName  34database34  dbName  34port34  port  34password34  password  3434        Using con  New MySqlConnectionconStr            Using cmd  New MySqlCommand34Select Case 134 con                conOpen                cmdExecuteScal

ASP.Net MySql: Check connection status of multiple databases in VB.Net

Company

Explore

Follow us

Contact Us