TableNotEnabledForNotificationException 類別

定義

命名空間:

System.Web.Caching

組件:

System.Web.dll

當類別被用於未啟用變更通知的資料庫資料表時，會拋 SqlCacheDependency 出例外。

public ref class TableNotEnabledForNotificationException sealed : SystemException

[System.Serializable]
public sealed class TableNotEnabledForNotificationException : SystemException

[<System.Serializable>]
type TableNotEnabledForNotificationException = class
    inherit SystemException

Public NotInheritable Class TableNotEnabledForNotificationException
Inherits SystemException

繼承

Object

Exception

SystemException

TableNotEnabledForNotificationException

屬性

SerializableAttribute

範例

以下程式碼範例嘗試建立一個SqlCacheDependency物件，並將一個物件相依Cache的項目加入SqlCacheDependency其中。 若SQL Server資料庫資料表未啟用相依通知，TableNotEnabledForNotificationException 會拋出，並透過呼叫 SqlCacheDependencyAdmin.EnableTableForNotifications 方法處理。

public void Page_Load(object Src, EventArgs E) 
{ 
    // Declare the SqlCacheDependency instance, SqlDep. 
    SqlCacheDependency SqlDep = null; 
    
    // Check the Cache for the SqlSource key. 
    // If it isn't there, create it with a dependency 
    // on a SQL Server table using the SqlCacheDependency class. 
    if (Cache["SqlSource"] == null) { 
        
        // Because of possible exceptions thrown when this 
        // code runs, use Try...Catch...Finally syntax. 
        try { 
            // Instantiate SqlDep using the SqlCacheDependency constructor. 
            SqlDep = new SqlCacheDependency("Northwind", "Categories"); 
        } 
        
        // Handle the DatabaseNotEnabledForNotificationException with 
        // a call to the SqlCacheDependencyAdmin.EnableNotifications method. 
        catch (DatabaseNotEnabledForNotificationException exDBDis) { 
            try { 
                SqlCacheDependencyAdmin.EnableNotifications("Northwind"); 
            } 
            
            // If the database does not have permissions set for creating tables, 
            // the UnauthorizedAccessException is thrown. Handle it by redirecting 
            // to an error page. 
            catch (UnauthorizedAccessException exPerm) { 
                Response.Redirect(".\\ErrorPage.htm"); 
            } 
        } 
        
        // Handle the TableNotEnabledForNotificationException with 
        // a call to the SqlCacheDependencyAdmin.EnableTableForNotifications method. 
        catch (TableNotEnabledForNotificationException exTabDis) { 
            try { 
                SqlCacheDependencyAdmin.EnableTableForNotifications("Northwind", "Categories"); 
            } 
            
            // If a SqlException is thrown, redirect to an error page. 
            catch (SqlException exc) { 
                Response.Redirect(".\\ErrorPage.htm"); 
            } 
        } 
        
        // If all the other code is successful, add MySource to the Cache 
        // with a dependency on SqlDep. If the Categories table changes, 
        // MySource will be removed from the Cache. Then generate a message 
        // that the data is newly created and added to the cache. 
        finally { 
            Cache.Insert("SqlSource", Source1, SqlDep); 
            CacheMsg.Text = "The data object was created explicitly."; 
            
        } 
    } 
    
    else { 
        CacheMsg.Text = "The data was retrieved from the Cache."; 
    } 
} 

Sub Page_Load(Src As Object, E As EventArgs)
   ' Declare the SqlCacheDependency instance, SqlDep.
   Dim SqlDep As SqlCacheDependency

   ' Check the Cache for the SqlSource key.
   ' If it isn't there, create it with a dependency
   ' on a SQL Server table using the SqlCacheDependency class.
   If Cache("SqlSource") Is Nothing

      ' Because of possible exceptions thrown when this
      ' code runs, use Try...Catch...Finally syntax.
      Try
         ' Instantiate SqlDep using the SqlCacheDependency constructor.
         SqlDep = New SqlCacheDependency("Northwind", "Categories")

      ' Handle the DatabaseNotEnabledForNotificationException with
      ' a call to the SqlCacheDependencyAdmin.EnableNotifications method.
      Catch exDBDis As DatabaseNotEnabledForNotificationException
         Try
            SqlCacheDependencyAdmin.EnableNotifications("Northwind")

         ' If the database does not have permissions set for creating tables,
         ' the UnauthorizedAccessException is thrown. Handle it by redirecting
         ' to an error page.
         Catch exPerm As UnauthorizedAccessException
             Response.Redirect(".\ErrorPage.htm")
         End Try

      ' Handle the TableNotEnabledForNotificationException with
            ' a call to the SqlCacheDependencyAdmin.EnableTableForNotifications method.
      Catch exTabDis As TableNotEnabledForNotificationException
         Try
            SqlCacheDependencyAdmin.EnableTableForNotifications( _
             "Northwind", "Categories")

         ' If a SqlException is thrown, redirect to an error page.
         Catch exc As SqlException
             Response.Redirect(".\ErrorPage.htm")
         End Try

      ' If all the other code is successful, add MySource to the Cache
      ' with a dependency on SqlDep. If the Categories table changes,
      ' MySource will be removed from the Cache. Then generate a message
            ' that the data is newly created and added to the cache.
      Finally
         Cache.Insert("SqlSource", Source1, SqlDep)
            CacheMsg.Text = "The data object was created explicitly."

      End Try

    Else
       CacheMsg.Text = "The data was retrieved from the Cache."
    End If
End Sub

建構函式

名稱	Description
TableNotEnabledForNotificationException()	初始化 TableNotEnabledForNotificationException 類別的新執行個體。
TableNotEnabledForNotificationException(String, Exception)	初始化類別的新實例 TableNotEnabledForNotificationException ，並附上指定的錯誤訊息及導致該異常的內部例外的參考。
TableNotEnabledForNotificationException(String)	初始化該類別的新實例 TableNotEnabledForNotificationException ，並以指定的錯誤訊息。

屬性

名稱	Description
Data	取得一組鍵值對，提供關於例外的額外使用者定義資訊。 (繼承來源 Exception)
HelpLink	取得或設定與此例外相關的說明檔案連結。 (繼承來源 Exception)
HResult	取得或設定 HRESULT，一個編碼的數值，指派給特定例外。 (繼承來源 Exception)
InnerException	會取得 Exception 造成目前例外的實例。 (繼承來源 Exception)
Message	取得描述目前例外狀況的訊息。 (繼承來源 Exception)
Source	取得或設定造成錯誤之應用程式或物件的名稱。 (繼承來源 Exception)
StackTrace	會取得呼叫堆疊上即時框架的字串表示。 (繼承來源 Exception)
TargetSite	會取得拋出當前例外的方法。 (繼承來源 Exception)

方法

名稱	Description
Equals(Object)	判斷指定的物件是否等於目前的物件。 (繼承來源 Object)
GetBaseException()	當在派生類別中被覆寫時，回傳 Exception 是一個或多個後續例外的根因。 (繼承來源 Exception)
GetHashCode()	做為預設哈希函式。 (繼承來源 Object)
GetObjectData(SerializationInfo, StreamingContext)	在衍生類別中覆寫時，使用例外狀況的相關信息來設定 SerializationInfo。 (繼承來源 Exception)
GetType()	取得目前實例的執行時型態。 (繼承來源 Exception)
MemberwiseClone()	建立目前 Object的淺層複本。 (繼承來源 Object)
ToString()	建立並回傳當前例外的字串表示。 (繼承來源 Exception)

事件

名稱	Description
SerializeObjectState	當例外被序列化以建立包含該例外序列化資料的例外狀態物件時，會發生這種情況。 (繼承來源 Exception)