Host Property (MySqlConnection)

In This Topic

Gets or sets name or IP address of host of MySQL database to which to connect.

Syntax

Visual Basic
C#

'Declaration
 
Public Property Host As String

public string Host {get; set;}

Property Value

The name or IP address of host of MySQL database to which to connect. The default value is an empty string ("").

Remarks

When a value is assigned to this property, the MySqlConnection is closed.

Example

The following example creates a MySqlConnection and displays the host name.

csharp

public void CreateMySqlConnection()
{
  string myConnString = "User Id=test; Host=localhost; Port=3306; Database=test";
  MySqlConnection myConnection = new MySqlConnection(myConnString);
  myConnection.Open();
  MessageBox.Show("Host: " + myConnection.Host);
  myConnection.Close();
}

Visual Basic

Public Sub CreateMySqlConnection()
  Dim myConnString As String = _
    "User Id=test; Host=localhost; Port=3306; Database=test"
  Dim myConnection As New MySqlConnection(myConnString)
  myConnection.Open()
  MessageBox.Show("Host: " + myConnection.Host)
  myConnection.Close()
End Sub

Reference

MySqlConnection Class
MySqlConnection Members
ConnectionString Property
Database Property

Send Feedback