Metodo PrepareQuery
Restituisce un set di dati contenente i campi recuperati dalla query per il recapito per una sottoscrizione guidata dai dati.
Spazio dei nomi ReportService2005
Assembly: ReportService2005 (in ReportService2005.dll)
Sintassi
'Dichiarazione
<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
'Utilizzo
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
Parametri
- DataSource
Tipo: ReportService2005. . :: . .DataSource
Origine dati della query per il recapito.
- DataSet
Tipo: ReportService2005. . :: . .DataSetDefinition
Set di dati contenente la query per il recapito e i campi per una sottoscrizione guidata dai dati.
- Changed
Tipo: System. . :: . .Boolean%
[out] Valore booleano che indica se il set di dati passato al metodo è diverso da quello restituito dal metodo. Utilizzare questa proprietà per determinare se il set di dati di input è diverso dal set di dati di output.
- ParameterNames
Tipo: array<System. . :: . .String> [] () [] []%
[out] Nomi dei parametri di query utilizzati nella query semantica sottostante. Questo parametro out viene utilizzato solo quando DataSource fa riferimento a un modello.
Valore restituito
Tipo: ReportService2005. . :: . .DataSetDefinition
Oggetto DataSetDefinition contenente i campi e la query per il recapito recuperati dall'origine dati specificata.
Osservazioni
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 Cenni preliminari sulle estensioni per l'elaborazione dati.