ReportingService2006.SetDataSourceContents Method

Artigo
12/03/2008

Sets the connection properties associated with a DataSource.

Namespace: ReportService2006
Assembly: ReportService2006 (in reportservice2006.dll)

Syntax

'Declaration
Public Sub SetDataSourceContents ( _
    DataSource As String, _
    Definition As DataSourceDefinition _
)

public void SetDataSourceContents (
    string DataSource,
    DataSourceDefinition Definition
)

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

public void SetDataSourceContents (
    String DataSource, 
    DataSourceDefinition Definition
)

public function SetDataSourceContents (
    DataSource : String, 
    Definition : DataSourceDefinition
)

Parameters

DataSource
The fully qualified URL for the data source including the file name and .rsds file name extension.

Definition
A DataSourceDefinition object that contains the definition for the data source.

Remarks

To remove properties that are part of the data source definition, set the values of those properties to null (Nothing in Visual Basic).

If you set the CredentialRetrieval property of the data source definition to Integrated or Prompt, do not supply values for UserName or Password. Doing so causes a SOAP exception with the error code rsInvalidElementCombination.

If you set the CredentialRetrieval property of the data source definition to Integrated or Store, any value that you supply for the Prompt property is not saved.

With subscriptions, you may have to store credentials in the report server database so that the subscriptions can run unattended.

Setting the ConnectString property of the data source definition to null (Nothing in Visual Basic) causes a SOAP exception with the error code rsInvalidXML. If you do not want to supply a value for ConnectString, set its value to an empty string ("").

This method does not support changing Office Data Connections or files that have the .odc file name extension. Doing so causes an rsNotSupported error. For data sources with extensions other than .rsds or .odc, an rsWrongType error is returned.

Example

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)
    {
        ReportingService2006 rs = new ReportingService2006();
        rs.Url = "http://<Server Name>/_vti_bin/ReportServer/" +
            "ReportService2006.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 ReportingService2006()
        rs.Url = "http://<Server Name>/_vti_bin/ReportServer/" + _
            "ReportService2006.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

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

Windows 98, Windows 2000, Windows 2000 Server, Windows CE, Windows Server 2008, Windows 98 Second Edition, Pocket PC, Smart Phone, Windows Server 2003, Windows XP Professional with Service Pack 2 (SP2), Windows 2000 Professional, Windows 2000 Advanced Server, Windows XP Home Edition, For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005., Windows Vista, Windows Mobile 5.0, Windows Mobile 2003 for Pocket PC, Windows CE 5.0

Partilhar via