获取订阅字段信息

Subscription 类提供 GetFieldNameGetFieldOrdinal 方法以获取对订阅字段信息的访问。

向其提供字段的序号,GetFieldName 方法可返回字段的名称。向其提供字段的名称,GetFieldOrdinal 方法可返回字段的序号。

下面的示例说明如何使用托管代码获取订阅字段信息以及如何使用 Microsoft Visual Basic Scripting Edition (VBScript) 说明 COM interop。

托管代码示例

该示例说明如何在托管代码中使用 Subscription 对象返回订阅字段名称信息。

string instanceName = "Tutorial";
string applicationName= "Weather";
string subscriptionClassName= "WeatherCity";
string fieldName = "City";
int ordinal = 2;

// Create the NSInstance object.
NSInstance testInstance = new NSInstance(instanceName);

// Create the NSApplication object.
NSApplication testApplication =
    new NSApplication(testInstance, applicationName);

// Create the Subscription object.
Subscription testSubscription =
    new Subscription(testApplication, subscriptionClassName);

// Use the GetFieldName method to return a field name
Console.WriteLine("Name of field " + ordinal.ToString() + ": " + 
    testSubscription.GetFieldName(ordinal));

// Use the GetFieldOrdinal to return a field ordinal
Console.WriteLine("Ordinal for the " + fieldName + " field: " +
    testSubscription.GetFieldOrdinal(fieldName));

COM Interop 示例

以下 VBScript 示例说明如何在非托管代码中使用 Subscription 对象返回订阅字段名称信息。

Dim testInstance, testApplication, testSubscription, _ 
    ordinal, fieldName

const instanceName = "Tutorial"
const applicationName = "Weather"
const subscriptionClassName = "WeatherCity"
ordinal = 2

' Create the NSInstance object.
set testInstance = WScript.CreateObject( _ 
    "Microsoft.SqlServer.NotificationServices.NSInstance")
testInstance.Initialize instanceName

' Create the NSApplication object.
set testApplication = WScript.CreateObject( _
    "Microsoft.SqlServer.NotificationServices.NSApplication")
testApplication.Initialize (testInstance), applicationName

' Create the Subscription object.
set testSubscription = WScript.CreateObject( _
    "Microsoft.SqlServer.NotificationServices.Subscription")
testSubscription.Initialize (testApplication), subscriptionClassName

' Get the name for a field identified by ordinal.
fieldName = testSubscription.GetFieldName(ordinal)
WScript.Echo "Field Name: ", fieldName 

' Get the field ordinal for the field.
fieldName = testSubscription.GetFieldOrdinal(fieldName)
WScript.Echo "Field Ordinal: ", fieldName 

请参阅

概念

创建订阅对象
添加订阅
更新订阅
删除订阅
填充订阅服务器区域设置列表
填充时区列表

其他资源

NS<SubscriptionClassName>View

帮助和信息

获取 SQL Server 2005 帮助