OleDbConnection.ChangeDatabase(String) 方法

定义

命名空间:

System.Data.OleDb

程序集:

System.Data.OleDb.dll

包:

System.Data.OleDb v9.0.0-rc.2.24473.5

Source:

OleDbConnection.cs

更改已打开的 OleDbConnection 的当前数据库。

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

public override void ChangeDatabase (string value);

override this.ChangeDatabase : string -> unit

Public Overrides Sub ChangeDatabase (value As String)

参数

value

String

数据库名称。

实现

ChangeDatabase(String)

例外

ArgumentException

数据库名称无效。

InvalidOperationException

连接未打开。

OleDbException

不能更改数据库。

示例

以下示例创建 并 OleDbConnection 显示其一些只读属性。

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

注解

参数中 database 提供的值必须是有效的数据库名称。 参数 database 不能包含空值、空字符串或仅包含空字符的字符串。

另请参阅

• 连接到数据源