Remarque
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de vous connecter ou de modifier des répertoires.
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de modifier des répertoires.
Adds a NotificationField object to the NotificationFieldCollection before a named notification field.
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, _
insertAtColumnName As String _
)
public void Add (
NotificationField notificationField,
string insertAtColumnName
)
public:
void Add (
NotificationField^ notificationField,
String^ insertAtColumnName
)
public void Add (
NotificationField notificationField,
String insertAtColumnName
)
public function Add (
notificationField : NotificationField,
insertAtColumnName : String
)
Paramètres
- notificationField
The NotificationField to add to the collection.
- insertAtColumnName
A String that specifies the name of the notification field before which to insert the new notification field.
Notes
This method allows you to insert a notification field at a specific position in the notification field list. Each notification field becomes a column in a table. Depending on how you submit notification data, the order of the columns can be important.
If you add NotificationField objects after deploying the instance, you must Update the instance to apply the changes.
Exemple
The following examples show how to add a notification field before the Price field in the collection of notification fields for a notification class:
// Define a GoingTo field and add it before the Price field
NotificationField notificationDestination =
new NotificationField(flightNotifications, "GoingTo");
notificationDestination.Type = "nvarchar(6)";
flightNotifications.NotificationFields.Add(
notificationDestination, "Price");
' Define a GoingTo field and add it before the Price field.
Dim notificationDestination As NotificationField = _
New NotificationField(flightNotifications, "GoingTo")
notificationDestination.Type = "nvarchar(6)"
flightNotifications.NotificationFields.Add( _
notificationDestination, "Price")
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.
Plateformes
Plateformes de développement
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Plateformes cibles
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Voir aussi
Référence
NotificationFieldCollection Class
NotificationFieldCollection Members
Microsoft.SqlServer.Management.Nmo Namespace
Instance.Update Method
Autres ressources
Définition du schéma de notification
Field Element for Schema/Fields (ADF)