NotificationFieldCollection.Add Method (NotificationField)

Artikkeli
12/03/2008

Adds a NotificationField at the end of the NotificationFieldCollection.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Sub Add ( _
    notificationField As NotificationField _
)

public void Add (
    NotificationField notificationField
)

public:
void Add (
    NotificationField^ notificationField
)

public void Add (
    NotificationField notificationField
)

public function Add (
    notificationField : NotificationField
)

Parameters

notificationField
The NotificationField to add to the collection.

Remarks

If you add fields to a deployed application, updating the instance deletes and re-creates the notification class to which it corresponds. This includes dropping and re-creating the tables and views used by this notification class. All data in the existing Microsoft SQL Server tables is permanently deleted.

Use the Update method to update the instance.

Example

The following examples show how to add a notification field to the end of the collection of notification fields for a notification class:

// Define a LeavingFrom notification field and use it for grouping 
// digest messages. Add it to the end of the field collection
NotificationField notificationOrgin = 
    new NotificationField(flightNotifications, "LeavingFrom");
notificationOrgin.Type = "nvarchar(6)";
notificationOrgin.DigestGrouping = true;
flightNotifications.NotificationFields.Add(notificationOrgin);

' Define a LeavingFrom field and use it for grouping
' digest messages. Add it to the end of the collection.
Dim notificationOrgin As NotificationField = _
    New NotificationField(flightNotifications, "LeavingFrom")
notificationOrgin.Type = "nvarchar(6)"
notificationOrgin.DigestGrouping = True
flightNotifications.NotificationFields.Add(notificationOrgin)

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms