SqlExecutionException 類別

定義

System.Web.Management 命名空間中定義 SQL 執行例外狀況的類別。Defines a class for SQL execution exceptions in the System.Web.Management namespace.

public ref class SqlExecutionException sealed : SystemException
[System.Serializable]
public sealed class SqlExecutionException : SystemException
type SqlExecutionException = class
    inherit SystemException
Public NotInheritable Class SqlExecutionException
Inherits SystemException
繼承
SqlExecutionException
屬性

範例

下列程式碼範例顯示如何使用SqlExecutionException例外狀況類型。The following code example shows how to use the SqlExecutionException exception type. 這個程式碼範例是針對SqlServices類別提供之較大範例的一部分。This code example is part of a larger example provided for the SqlServices class.

Console.WriteLine(
    "An SQL execution exception occurred.");
Console.WriteLine();
Console.WriteLine("  Message: {0}",
    sqlExecutionException.Message);
Console.WriteLine("  Server: {0}",
    sqlExecutionException.Server);
Console.WriteLine("  Database: {0}",
    sqlExecutionException.Database);
Console.WriteLine("  Commands: {0}",
    sqlExecutionException.Commands);
Console.WriteLine("  SqlFile: {0}",
    sqlExecutionException.SqlFile);
Console.WriteLine("  Inner Exception: {0}",
    sqlExecutionException.Exception);
Console.WriteLine( _
    "An SQL execution exception occurred.")
Console.WriteLine()
Console.WriteLine("  Message: {0}", _
    sqlExecutionException.Message)
Console.WriteLine("  Server: {0}", _
    sqlExecutionException.Server)
Console.WriteLine("  Database: {0}", _
    sqlExecutionException.Database)
Console.WriteLine("  Commands: {0}", _
    sqlExecutionException.Commands)
Console.WriteLine("  SqlFile: {0}", _
    sqlExecutionException.SqlFile)
Console.WriteLine("  Inner Exception: {0}", _
    sqlExecutionException.Exception)

備註

這個類別是提供來區分 SQL 執行例外狀況與其他應用程式例外狀況的方法。This class is provided as a means to differentiate SQL execution exceptions from other application exceptions.

建構函式

SqlExecutionException()

使用預設值,初始化 SqlExecutionException 類別的新執行個體。Initializes a new instance of the SqlExecutionException class using default values.

SqlExecutionException(String)

使用傳入的訊息來初始化 SqlExecutionException 類別的新執行個體。Initializes a new instance of the SqlExecutionException class using the passed message.

SqlExecutionException(String, Exception)

使用傳入的訊息和例外狀況,初始化 SqlExecutionException 類別的新執行個體。Initializes a new instance of the SqlExecutionException class using the passed message and exception.

SqlExecutionException(String, String, String, String, String, SqlException)

初始化 SqlExecutionException 類別的新執行個體。Initializes a new instance of the SqlExecutionException class.

屬性

Commands

取得例外狀況發生時所執行的 SQL 命令。Gets the SQL commands being run when the exception occurred.

Data

取得提供例外狀況之其他使用者定義相關資訊的索引鍵/值組集合。Gets a collection of key/value pairs that provide additional user-defined information about the exception.

(繼承來源 Exception)
Database

取得例外狀況發生時所存取的資料庫名稱。Gets the name of the database being accessed when the exception occurred.

Exception

取得處理 SQL 命令時發生的例外狀況。Gets the exception encountered when processing the SQL commands.

HelpLink

取得或設定與這個例外狀況相關聯的說明檔連結。Gets or sets a link to the help file associated with this exception.

(繼承來源 Exception)
HResult

取得或設定 HRESULT,它是指派給特定例外狀況的編碼數值。Gets or sets HRESULT, a coded numerical value that is assigned to a specific exception.

(繼承來源 Exception)
InnerException

取得造成目前例外狀況的 Exception 執行個體。Gets the Exception instance that caused the current exception.

(繼承來源 Exception)
Message

取得描述目前例外狀況的訊息。Gets a message that describes the current exception.

(繼承來源 Exception)
Server

取得例外狀況發生時所存取的 SQL Server 執行個體。Gets the SQL Server instance being accessed when the exception occurred.

Source

取得或設定造成錯誤的應用程式或物件的名稱。Gets or sets the name of the application or the object that causes the error.

(繼承來源 Exception)
SqlFile

取得檔案的路徑和名稱,該檔案包含例外狀況發生時所執行的 SQL 命令。Gets the path and name of the file containing the SQL commands being run when the exception occurred.

StackTrace

取得呼叫堆疊上即時運算框架的字串表示。Gets a string representation of the immediate frames on the call stack.

(繼承來源 Exception)
TargetSite

取得擲回目前例外狀況的方法。Gets the method that throws the current exception.

(繼承來源 Exception)

方法

Equals(Object)

判斷指定的物件是否等於目前的物件。Determines whether the specified object is equal to the current object.

(繼承來源 Object)
GetBaseException()

在衍生類別中覆寫時,傳回一或多個後續的例外狀況的根本原因 ExceptionWhen overridden in a derived class, returns the Exception that is the root cause of one or more subsequent exceptions.

(繼承來源 Exception)
GetHashCode()

做為預設雜湊函式。Serves as the default hash function.

(繼承來源 Object)
GetObjectData(SerializationInfo, StreamingContext)

允許序列化例外狀況。Allows the exception to be serialized.

GetType()

取得目前執行個體的執行階段類型。Gets the runtime type of the current instance.

(繼承來源 Exception)
MemberwiseClone()

建立目前 Object 的淺層複製。Creates a shallow copy of the current Object.

(繼承來源 Object)
ToString()

建立並傳回目前例外狀況的字串表示。Creates and returns a string representation of the current exception.

(繼承來源 Exception)

事件

SerializeObjectState

當例外狀況序列化,以建立包含例外狀況相關序列化資料的例外狀況狀態物件時,就會發生此事件。Occurs when an exception is serialized to create an exception state object that contains serialized data about the exception.

(繼承來源 Exception)

適用於

另請參閱