Gets the name of the current database or the database to be used after a connection is opened.
Namespace: MySql.Data.MySqlClient
Assembly: MySql.Data (in MySql.Data.dll) Version: 6.8.4.0
Syntax
C# |
---|
public override string Database { get; } |
Visual Basic |
---|
Public Overrides ReadOnly Property Database As String
Get |
Visual C++ |
---|
public:
virtual property String^ Database {
String^ get () override;
} |
Return Value
The name of the current database or the name of the database to be used after a connection is opened. The default value is an empty string.
Implements
IDbConnection..::..Database
Remarks
Examples
The following example creates a
MySqlConnection and displays
some of its read-only properties.
Visual Basic | Copy |
---|
Public Sub CreateMySqlConnection()
Dim myConnString As String = _
"Persist Security Info=False;database=test;server=localhost;user id=joeuser;pwd=pass"
Dim myConnection As New MySqlConnection( myConnString )
myConnection.Open()
MessageBox.Show( "Server Version: " + myConnection.ServerVersion _
+ ControlChars.NewLine + "Database: " + myConnection.Database )
myConnection.ChangeDatabase( "test2" )
MessageBox.Show( "ServerVersion: " + myConnection.ServerVersion _
+ ControlChars.NewLine + "Database: " + myConnection.Database )
myConnection.Close()
End Sub |
C# | Copy |
---|
public void CreateMySqlConnection()
{
string myConnString =
"Persist Security Info=False;database=test;server=localhost;user id=joeuser;pwd=pass";
MySqlConnection myConnection = new MySqlConnection( myConnString );
myConnection.Open();
MessageBox.Show( "Server Version: " + myConnection.ServerVersion
+ "\nDatabase: " + myConnection.Database );
myConnection.ChangeDatabase( "test2" );
MessageBox.Show( "ServerVersion: " + myConnection.ServerVersion
+ "\nDatabase: " + myConnection.Database );
myConnection.Close();
} |
See Also