OleDbConnection.ChangeDatabase(String) 方法

定义

命名空间:
System.Data.OleDb
程序集:
System.Data.OleDb.dll
程序集:
System.Data.dll
包:
System.Data.OleDb v11.0.0-preview.4.26230.115
Source:
OleDbConnection.cs
Source:
OleDbConnection.cs
Source:
OleDbConnection.cs
Source:
OleDbConnection.cs

更改打开 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)

参数

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 参数不能包含空值、空字符串或仅包含空白字符的字符串。

适用于

另请参阅