SubscriptionClass.FieldOrdinal Method

Article
12/03/2008

Gets the ordinal of a field in the subscription class.

Namespace: Microsoft.SqlServer.NotificationServices
Assembly: Microsoft.SqlServer.NotificationServices (in microsoft.sqlserver.notificationservices.dll)

Syntax

'Declaration
Public Function FieldOrdinal ( _
    fieldName As String _
) As Integer

public int FieldOrdinal (
    string fieldName
)

public:
virtual int FieldOrdinal (
    String^ fieldName
) sealed

public final int FieldOrdinal (
    String fieldName
)

public final function FieldOrdinal (
    fieldName : String
) : int

Parameters

fieldName
The name of a developer-defined field in the subscription class.

Return Value

An integer representing the zero-based field ordinal.

Example

The following examples show how to use the FieldOrdinal method to get the ordinal of a subscription field by providing the field name:

Dim instanceName As String = "MyInstanceName"
Dim applicationName As String = "MyApplicationName"
Dim subscriptionClassName As String = "MySubscriptionClassName"
Dim fieldName As String = "MySubscriptionFieldName"

'Create an NSInstance object.
Dim myInstance As New NSInstance(instanceName)

'Create an NSApplication object.
Dim myApplication As New NSApplication(myInstance, applicationName)

'Create a SubscriptionClassEnumeration object.
Dim mySubscriptionClassEnumeration As _
    New SubscriptionClassEnumeration(myApplication)

'Use the SubscriptionClassEnumeration.Item 
'to return a SubscriptionClass object.
Dim mySubscriptionClass As SubscriptionClass = _
    mySubscriptionClassEnumeration(subscriptionClassName)

'Use the FieldOrdinal method to get a field ordinal.
Dim fieldOrdinal As Integer = _
    mySubscriptionClass.FieldOrdinal(fieldName)

string instanceName = "MyInstanceName";
string applicationName = "MyApplicationName";
string subscriptionClassName = "MySubscriptionClassName";
string fieldName = "MySubscriptionFieldName";

//Create an NSInstance object.
NSInstance myInstance = new NSInstance(instanceName);

//Create an NSApplication object.
NSApplication myApplication = 
    new NSApplication(myInstance, applicationName);

//Create a SubscriptionClassEnumeration object.
SubscriptionClassEnumeration mySubscriptionClassEnumeration = 
    new SubscriptionClassEnumeration(myApplication);

//Use the SubscriptionClassEnumeration.Item 
//to return a SubscriptionClass object.
SubscriptionClass mySubscriptionClass = 
    mySubscriptionClassEnumeration[subscriptionClassName];

//Use the FieldOrdinal method to get a field ordinal.
int fieldOrdinal  = mySubscriptionClass.FieldOrdinal(fieldName);

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