MySqlConnection.ChangeDatabase Method

MySQL Connector/Net

previous page next page
MySqlConnectionChangeDatabase Method
Changes the current database for an open MySqlConnection.

Namespace: MySql.Data.MySqlClient
Assembly: MySql.Data (in MySql.Data.dll) Version: 6.9.9
Syntax
Copy
public override void ChangeDatabase(
	string databaseName
)
Public Overrides Sub ChangeDatabase ( 
	databaseName As String
)
public:
virtual void ChangeDatabase(
	String^ databaseName
) override
abstract ChangeDatabase : 
        databaseName : string -> unit 
override ChangeDatabase : 
        databaseName : string -> unit

Parameters

databaseName
Type: SystemString
The name of the database to use.

Implements

IDbConnectionChangeDatabase(String)
Exceptions
ExceptionCondition
ArgumentExceptionThe database name is not valid.
InvalidOperationExceptionThe connection is not open.
MySqlExceptionCannot change the database.
Remarks

The value supplied in the database parameter must be a valid database name. The database parameter cannot contain a null value, an empty string, or a string with only blank characters.

When you are using connection pooling against MySQL, and you close the connection, it is returned to the connection pool. The next time the connection is retrieved from the pool, the reset connection request executes before the user performs any operations.

Examples
The following example creates a MySqlConnection and displays some of its read-only properties.
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();
}
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

No code example is currently available or this language may not be supported.

No code example is currently available or this language may not be supported.

See Also
previous page start next page