SqlException.ToString 方法

定義

回傳一個代表當前 SqlException 物件的字串,並包含用戶端連線 ID(更多資訊請參見 ClientConnectionId)。

public:
 override System::String ^ ToString();
public override string ToString();
override this.ToString : unit -> string
Public Overrides Function ToString () As String

傳回

一個代表當前SqlException物件的字串......String

範例

以下 C# 範例展示了嘗試連接有效伺服器但資料庫不存在時,如何產生 SqlException包含用戶端連線 ID 的 。

using System.Data.SqlClient;
using System;

public class A {
   public static void Main() {
      SqlConnection connection = new SqlConnection();
      connection.ConnectionString = "Data Source=a_valid_server;Initial Catalog=Northwinda;Integrated Security=true";
      try {
         connection.Open();
      }
      catch (SqlException p) {
         Console.WriteLine("{0}", p.ClientConnectionId);
         Console.WriteLine("{0}", p.ToString());
      }
      connection.Close();
   }
}

以下 Visual Basic 範例在功能上等同於前述的 (C#) 範例:

Imports System.Data.SqlClient
Imports System

Module Module1

    Sub Main()
        Dim connection As New SqlConnection()
        connection.ConnectionString = "Data Source=a_valid_server;Initial Catalog=Northwinda;Integrated Security=true"
        Try
            connection.Open()
        Catch p As SqlException
            Console.WriteLine("{0}", p.ClientConnectionId)
            Console.WriteLine("{0}", p.ToString())
        End Try
        connection.Close()
    End Sub

End Module

適用於