OleDbConnection.ChangeDatabase(String) Method

Reference

Definition

Namespace:: System.Data.OleDb

Assembly:: System.Data.OleDb.dll

Assembly:: System.Data.dll

Package:: System.Data.OleDb v9.0.0

Source:: OleDbConnection.cs

Source:: OleDbConnection.cs

Source:: OleDbConnection.cs

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Changes the current database for an open OleDbConnection.

public:
 override void ChangeDatabase(System::String ^ value);

public:
 virtual void ChangeDatabase(System::String ^ value);

public override void ChangeDatabase (string value);

public void ChangeDatabase (string value);

override this.ChangeDatabase : string -> unit

abstract member ChangeDatabase : string -> unit
override this.ChangeDatabase : string -> unit

Public Overrides Sub ChangeDatabase (value As String)

Public Sub ChangeDatabase (value As String)

Parameters

value: String

The database name.

Implements

ChangeDatabase(String)

Exceptions

ArgumentException

The database name is not valid.

InvalidOperationException

The connection is not open.

OleDbException

Cannot change the database.

Examples

The following example creates an OleDbConnection and displays some of its read-only properties.

static void ChangeDatabaseConnection(string connectionString)
{
   using (OleDbConnection connection = new OleDbConnection(connectionString))
   {
      try
      {
         connection.Open();
         Console.WriteLine("ServerVersion: {0} \nDatabase: {1}",
             connection.ServerVersion, connection.Database);

         connection.ChangeDatabase("Northwind");
         Console.WriteLine("ServerVersion: {0} \nDatabase: {1}",
            connection.ServerVersion, connection.Database);
      }
      catch (Exception ex)
      {
         Console.WriteLine(ex.Message);
      }
      // The connection is automatically closed when the
      // code exits the using block.
   }
}

Public Sub ChangeDatabaseConnection(ByVal connectionString As String)

   Using connection As New OleDbConnection(connectionString)
      Try
         connection.Open()
         Console.WriteLine("Server Version: {0} Database: {1}", _
             connection.ServerVersion, connection.Database)
         connection.ChangeDatabase("Northwind")
         Console.WriteLine("Server Version: {0} Database: {1}", _
            connection.ServerVersion, connection.Database)

      Catch ex As Exception
         Console.WriteLine(ex.Message)
      End Try
      ' The connection is automatically closed when the
      ' code exits the Using block.
   End Using
End Sub

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.

Applies to

Delen via