ReportingService2010.CreateDataSource(String, String, Boolean, DataSourceDefinition, Property[]) Method
Definition
在 Report Server 数据库或 SharePoint 库中创建新的数据源。Creates a new data source in a report server database or SharePoint library.
public:
ReportService2010::CatalogItem ^ CreateDataSource(System::String ^ DataSource, System::String ^ Parent, bool Overwrite, ReportService2010::DataSourceDefinition ^ Definition, cli::array <ReportService2010::Property ^> ^ Properties);
[System.Web.Services.Protocols.SoapDocumentMethod("http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/CreateDataSource", 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("TrustedUserHeaderValue")]
[System.Web.Services.Protocols.SoapHeader("ServerInfoHeaderValue", Direction=System.Web.Services.Protocols.SoapHeaderDirection.Out)]
public ReportService2010.CatalogItem CreateDataSource (string DataSource, string Parent, bool Overwrite, ReportService2010.DataSourceDefinition Definition, ReportService2010.Property[] Properties);
[<System.Web.Services.Protocols.SoapDocumentMethod("http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/CreateDataSource", 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("TrustedUserHeaderValue")>]
[<System.Web.Services.Protocols.SoapHeader("ServerInfoHeaderValue", Direction=System.Web.Services.Protocols.SoapHeaderDirection.Out)>]
member this.CreateDataSource : string * string * bool * ReportService2010.DataSourceDefinition * ReportService2010.Property[] -> ReportService2010.CatalogItem
Public Function CreateDataSource (DataSource As String, Parent As String, Overwrite As Boolean, Definition As DataSourceDefinition, Properties As Property()) As CatalogItem
Parameters
- DataSource
- String
数据源的名称,其中包括文件名,在 SharePoint 模式下还包括扩展名 (.rsds)。The name for the data source including the file name and, in SharePoint mode, the extension (.rsds).
- Parent
- String
将包含数据源的父文件夹的完全限定 URL。The fully qualified URL for the parent folder that will contain the data source.
- Overwrite
- Boolean
一个Boolean
表达式,该表达式指示是否应该覆盖指定位置中同名的现有数据源。A Boolean
expression that indicates whether an existing data source with the same name in the location specified should be overwritten.
- Definition
- DataSourceDefinition
一个描述数据源的连接属性的 DataSourceDefinition 对象。A DataSourceDefinition object that describes the connection properties for the data source.
- Properties
- Property[]
Property 对象的数组,它定义要为数据源设置的属性名和属性值。An array of Property objects that defines the property names and values to set for the data source.
Returns
一个用于新创建的数据源的 CatalogItem 对象。A CatalogItem object for the newly created data source.
- Attributes
Examples
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;
string name = "AdventureWorks.rsds";
string parent = "http://<Server Name>/Docs/Documents/";
// Define the data source definition.
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.ImpersonateUserSpecified = false;
//Use the default prompt string.
definition.Prompt = null;
definition.WindowsCredentials = false;
try
{
rs.CreateDataSource(name, parent, false,
definition, null);
}
catch (SoapException e)
{
Console.WriteLine(e.Detail.InnerXml.ToString());
}
}
}
Imports System
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 name As String = "AdventureWorks.rsds"
Dim parent As String = "http://<Server Name>/Docs/Documents/"
' Define the data source definition.
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.ImpersonateUserSpecified = False
'Use the default prompt string.
definition.Prompt = Nothing
definition.WindowsCredentials = False
Try
rs.CreateDataSource(name, parent, False, _
definition, Nothing)
Catch e As SoapException
Console.WriteLine(e.Detail.InnerXml.ToString())
End Try
End Sub
End Class
Remarks
下表显示了有关此操作的标头和权限信息。The table below shows header and permissions information on this operation.
SOAP 标头用法SOAP Header Usage | (In) TrustedUserHeaderValue(In) TrustedUserHeaderValue (Out) ServerInfoHeaderValue(Out) ServerInfoHeaderValue |
纯模式所需的权限Native Mode Required Permissions | 创建新数据源: CreateDatasource 开启 Parent Creating a new data source: CreateDatasource on Parent 更新现有数据源: UpdateContent 开启 DataSource Updating an existing data source: UpdateContent on DataSource 更新数据源属性: UpdateContent 和 UpdateProperties DataSource Updating data source properties: UpdateContent AND UpdateProperties on DataSource |
SharePoint 模式所需的权限SharePoint Mode Required Permissions | 创建新数据源: AddListItems 开启 Parent Creating a new data source: AddListItems on Parent 更新现有数据源: EditListItems 开启 DataSource Updating an existing data source: EditListItems on DataSource |
如果从数据源名称中排除 .rsds 扩展名, rsFileExtensionRequired
将返回错误。If the .rsds extension is excluded from the data source name, an rsFileExtensionRequired
error will be returned. 如果提供了 .odc 扩展名, rsNotSupported
则返回错误。If an .odc extension is given, an rsNotSupported
error is returned.
如果发生错误,则不会创建数据源。If errors occur, the data source is not created.
参数的长度 Parent
不能超过260个字符; 否则,将引发带有错误代码 RSITEMLENGTHEXCEEDED 的 SOAP 异常。The length of the Parent
parameter cannot exceed 260 characters; otherwise, a SOAP exception is thrown with the error code rsItemLengthExceeded.
Parent
参数不能为 null 或为空,也不能包含以下保留字符: : ? ; @ & = + $ , \ * > < | . "
。The Parent
parameter cannot be null or empty or contain the following reserved characters: : ? ; @ & = + $ , \ * > < | . "
. 您可以使用正斜杠 (/) 来分隔文件夹的完整路径名中的项,但不能在文件夹名称的末尾使用。You can use the forward slash character (/) to separate items in the full path name of the folder, but you cannot use it at the end of the folder name.