NotificationFieldCollection.Add Method (NotificationField)

Adds a NotificationField at the end of the NotificationFieldCollection.

Espace de noms: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntaxe

'Déclaration
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
)

Paramètres

notificationField
The NotificationField to add to the collection.

Notes

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.

Exemple

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)

Sécurité des threads

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.