• 發行項

PrepareQuery 方法

傳回資料集，其中包含由資料導向訂閱之傳遞查詢所擷取的欄位。

命名空間：  ReportService2005
組件：  ReportService2005 (在 ReportService2005.dll 中)

語法

'宣告
<SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/PrepareQuery", RequestNamespace := "https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices",  _
    ResponseNamespace := "https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices",  _
    Use := SoapBindingUse.Literal, ParameterStyle := SoapParameterStyle.Wrapped)> _
<SoapHeaderAttribute("ServerInfoHeaderValue", Direction := SoapHeaderDirection.Out)> _
<SoapHeaderAttribute("BatchHeaderValue")> _
Public Function PrepareQuery ( _
    DataSource As DataSource, _
    DataSet As DataSetDefinition, _
    <OutAttribute> ByRef Changed As Boolean, _
    <OutAttribute> ByRef ParameterNames As String() _
) As DataSetDefinition
'用途
Dim instance As ReportingService2005
Dim DataSource As DataSource
Dim DataSet As DataSetDefinition
Dim Changed As Boolean
Dim ParameterNames As String()
Dim returnValue As DataSetDefinition

returnValue = instance.PrepareQuery(DataSource, _
    DataSet, Changed, ParameterNames)

[SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/PrepareQuery", RequestNamespace = "https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    ResponseNamespace = "https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)]
[SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)]
[SoapHeaderAttribute("BatchHeaderValue")]
public DataSetDefinition PrepareQuery(
    DataSource DataSource,
    DataSetDefinition DataSet,
    out bool Changed,
    out string[] ParameterNames
)

[SoapDocumentMethodAttribute(L"https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/PrepareQuery", RequestNamespace = L"https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    ResponseNamespace = L"https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    Use = SoapBindingUse::Literal, ParameterStyle = SoapParameterStyle::Wrapped)]
[SoapHeaderAttribute(L"ServerInfoHeaderValue", Direction = SoapHeaderDirection::Out)]
[SoapHeaderAttribute(L"BatchHeaderValue")]
public:
DataSetDefinition^ PrepareQuery(
    DataSource^ DataSource, 
    DataSetDefinition^ DataSet, 
    [OutAttribute] bool% Changed, 
    [OutAttribute] array<String^>^% ParameterNames
)

[<SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/PrepareQuery", RequestNamespace = "https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    ResponseNamespace = "https://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", 
    Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)>]
[<SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)>]
[<SoapHeaderAttribute("BatchHeaderValue")>]
member PrepareQuery : 
        DataSource:DataSource * 
        DataSet:DataSetDefinition * 
        Changed:bool byref * 
        ParameterNames:string[] byref -> DataSetDefinition 

public function PrepareQuery(
    DataSource : DataSource, 
    DataSet : DataSetDefinition, 
    Changed : boolean, 
    ParameterNames : String[]
) : DataSetDefinition

參數

  • Changed
    型別：System. . :: . .Boolean%
    [out] Boolean 值，指出傳遞給方法的資料集與方法所傳回的資料集是否不同。使用這個屬性，以判斷輸入資料集是否與輸出資料集不同。
  • ParameterNames
    型別：array<System. . :: . .String> [] () [] []%
    [out] 基礎語意查詢中所使用的查詢參數名稱。只有在 DataSource 參考模型時，才使用這個 out 參數。

傳回值

型別：ReportService2005. . :: . .DataSetDefinition
DataSetDefinition 物件，其中包含從特定資料來源擷取的欄位和傳遞查詢。

備註

The table below shows header and permissions information on this operation.

SOAP Headers

(In) BatchHeaderValue

(Out) ServerInfoHeaderValue

Required Permissions

Depends on the item type:

Pass the DataSetDefinition object that is returned by the PrepareQuery method as input to the CreateDataDrivenSubscription and SetDataDrivenSubscriptionProperties methods.

The delivery query returns a set of fields that can be mapped to report parameter values and delivery extension settings for data-driven subscriptions. Each row in the result set contains values for a single recipient, such as an e-mail address to which the report is delivered.

The delivery query must be valid for one of the data processing extensions that are installed on the report server. For more information, see 資料處理延伸模組概觀.