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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

MySqlConnection Class
MySqlConnection Members
ConnectionString Property
Database Property

Send Feedback