ReportingService2010.SetDataSourceContents 方法

定義

命名空間:: ReportService2010

組件:: ReportService2010.dll

重要

部分資訊涉及發行前產品，在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊，不做任何明確或隱含的瑕疵擔保。

設定與 DataSource相關聯的連接屬性。

public:
 void SetDataSourceContents(System::String ^ DataSource, ReportService2010::DataSourceDefinition ^ Definition);

[System.Web.Services.Protocols.SoapDocumentMethod("http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetDataSourceContents", ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Wrapped, RequestNamespace="http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", ResponseNamespace="http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", Use=System.Web.Services.Description.SoapBindingUse.Literal)]
[System.Web.Services.Protocols.SoapHeader("ServerInfoHeaderValue", Direction=System.Web.Services.Protocols.SoapHeaderDirection.Out)]
[System.Web.Services.Protocols.SoapHeader("TrustedUserHeaderValue")]
public void SetDataSourceContents(string DataSource, ReportService2010.DataSourceDefinition Definition);

[<System.Web.Services.Protocols.SoapDocumentMethod("http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetDataSourceContents", ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Wrapped, RequestNamespace="http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", ResponseNamespace="http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", Use=System.Web.Services.Description.SoapBindingUse.Literal)>]
[<System.Web.Services.Protocols.SoapHeader("ServerInfoHeaderValue", Direction=System.Web.Services.Protocols.SoapHeaderDirection.Out)>]
[<System.Web.Services.Protocols.SoapHeader("TrustedUserHeaderValue")>]
member this.SetDataSourceContents : string * ReportService2010.DataSourceDefinition -> unit

Public Sub SetDataSourceContents (DataSource As String, Definition As DataSourceDefinition)

參數

DataSource: String

資料來源的完整限定網址，包括檔名與 .rsds 檔名副檔名。

Definition: DataSourceDefinition

一個 DataSourceDefinition 包含資料來源定義的物件。

屬性: SoapDocumentMethodAttribute SoapHeaderAttribute

範例

using System;  
using System.Collections.Generic;  
using System.IO;  
using System.Text;  
using System.Web;  
using System.Web.Services;  
using System.Web.Services.Protocols;  

class Sample  
{  
    static void Main(string[] args)  
    {  
        ReportingService2010 rs = new ReportingService2010();  
        rs.Url = "http://<Server Name>/_vti_bin/ReportServer/" +  
            "ReportService2010.asmx";  
        rs.Credentials =   
          System.Net.CredentialCache.DefaultCredentials;  

        DataSourceDefinition definition =   
            new DataSourceDefinition();  
        definition.CredentialRetrieval =   
            CredentialRetrievalEnum.Integrated;  
        definition.ConnectString =   
            "data source=(local);initial catalog=AdventureWorks";  
        definition.Enabled = true;  
        definition.EnabledSpecified = true;  
        definition.Extension = "SQL";  
        definition.ImpersonateUser = false;  
        definition.ImpersonateUserSpecified = true;  
        definition.Prompt = null;  
        definition.WindowsCredentials = true;  

        try  
        {  
            rs.SetDataSourceContents("http://<Server Name>" +  
                "/Docs/Documents/Data Sources/AdventureWorks.rsds",   
                definition);  
        }  

        catch (SoapException e)  
        {  
            Console.WriteLine(e.Detail.OuterXml);  
        }  
    }  
}

Imports System  
Imports System.IO  
Imports System.Text  
Imports System.Web.Services  
Imports System.Web.Services.Protocols  

Class Sample  

    Public Shared Sub Main()  

        Dim rs As New ReportingService2010()  
        rs.Url = "http://<Server Name>/_vti_bin/ReportServer/" + _  
            "ReportService2010.asmx"  
        rs.Credentials = _  
            System.Net.CredentialCache.DefaultCredentials  

        Dim definition As New DataSourceDefinition()  
        definition.CredentialRetrieval = _  
            CredentialRetrievalEnum.Integrated  
        definition.ConnectString = _  
            "data source=(local);initial catalog=AdventureWorks"  
        definition.Enabled = True  
        definition.EnabledSpecified = True  
        definition.Extension = "SQL"  
        definition.ImpersonateUser = False  
        definition.ImpersonateUserSpecified = True  
        definition.Prompt = Nothing  
        definition.WindowsCredentials = False  

        Try  
            rs.SetDataSourceContents("http://<Server Name>" + _  
                "/Docs/Documents/Data Sources/AdventureWorks.rsds", _  
                definition)  

        Catch e As SoapException  
            Console.WriteLine(e.Detail.OuterXml)  
        End Try  

    End Sub  

End Class

備註

下表顯示此操作的標頭與權限資訊。


SOAP 標頭的使用	（在） TrustedUserHeaderValue （出局） ServerInfoHeaderValue
原生模式所需權限	UpdateContent
SharePoint 模式必要權限	<xref:Microsoft.SharePoint.SPBasePermissions.EditListItems>

要移除資料來源定義中的屬性，請在 Visual Basic 中將這些屬性的值設為 null （Nothing）。

如果你將資料來源定義的屬性設CredentialRetrieval為Integrated或Prompt，請不要提供或 UserName Password 的值。這樣做會產生帶有錯誤代碼 rsInvalidElementCombination的 SOAP 例外。

如果你將資料來源定義的屬性設 CredentialRetrieval 為 Integrated 或 Store，你為該屬性提供 Prompt 的任何值都不會被儲存。

訂閱制可能需要將憑證存入報告伺服器資料庫，讓訂閱能無人值守執行。

將資料來源定義的屬性設ConnectString為null（Nothing在 Visual Basic 中）會產生帶有錯誤代碼rsInvalidXML的 SOAP 例外。如果你不想為提供值 ConnectString，請將其值設為空字串（“”）。

此方法不支援更改 Office 資料連線或具有 .odc 副檔名的檔案。這樣做會導致 rsNotSupported 錯誤。對於副檔名非 .rsds 或 .odc 的資料來源， rsWrongType 則會回傳錯誤。

適用於