CreateDataSource 方法
在報表伺服器資料庫或 SharePoint 文件庫中建立新的資料來源。
命名空間: ReportService2010
組件: ReportService2010 (在 ReportService2010.dll 中)
語法
'宣告
<SoapHeaderAttribute("TrustedUserHeaderValue")> _
<SoapHeaderAttribute("ServerInfoHeaderValue", Direction := SoapHeaderDirection.Out)> _
<SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/CreateDataSource", RequestNamespace := "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", _
ResponseNamespace := "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer", _
Use := SoapBindingUse.Literal, ParameterStyle := SoapParameterStyle.Wrapped)> _
Public Function CreateDataSource ( _
DataSource As String, _
Parent As String, _
Overwrite As Boolean, _
Definition As DataSourceDefinition, _
Properties As Property() _
) As CatalogItem
'用途
Dim instance As ReportingService2010
Dim DataSource As String
Dim Parent As String
Dim Overwrite As Boolean
Dim Definition As DataSourceDefinition
Dim Properties As Property()
Dim returnValue As CatalogItem
returnValue = instance.CreateDataSource(DataSource, _
Parent, Overwrite, Definition, Properties)
[SoapHeaderAttribute("TrustedUserHeaderValue")]
[SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)]
[SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/CreateDataSource", RequestNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
ResponseNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)]
public CatalogItem CreateDataSource(
string DataSource,
string Parent,
bool Overwrite,
DataSourceDefinition Definition,
Property[] Properties
)
[SoapHeaderAttribute(L"TrustedUserHeaderValue")]
[SoapHeaderAttribute(L"ServerInfoHeaderValue", Direction = SoapHeaderDirection::Out)]
[SoapDocumentMethodAttribute(L"https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/CreateDataSource", RequestNamespace = L"https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
ResponseNamespace = L"https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
Use = SoapBindingUse::Literal, ParameterStyle = SoapParameterStyle::Wrapped)]
public:
CatalogItem^ CreateDataSource(
String^ DataSource,
String^ Parent,
bool Overwrite,
DataSourceDefinition^ Definition,
array<Property^>^ Properties
)
[<SoapHeaderAttribute("TrustedUserHeaderValue")>]
[<SoapHeaderAttribute("ServerInfoHeaderValue", Direction = SoapHeaderDirection.Out)>]
[<SoapDocumentMethodAttribute("https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/CreateDataSource", RequestNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
ResponseNamespace = "https://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",
Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)>]
member CreateDataSource :
DataSource:string *
Parent:string *
Overwrite:bool *
Definition:DataSourceDefinition *
Properties:Property[] -> CatalogItem
public function CreateDataSource(
DataSource : String,
Parent : String,
Overwrite : boolean,
Definition : DataSourceDefinition,
Properties : Property[]
) : CatalogItem
參數
- DataSource
型別:System. . :: . .String
資料來源的名稱,包括檔名以及 SharePoint 模式下的副檔名 (.rsds)。
- Parent
型別:System. . :: . .String
將包含資料來源之父資料夾的完整 URL。
- Overwrite
型別:System. . :: . .Boolean
Boolean 運算式,指出是否應該覆寫在指定位置中名稱相同的現有資料來源。
- Definition
型別:ReportService2010. . :: . .DataSourceDefinition
DataSourceDefinition 物件,描述資料來源的連接屬性。
- Properties
型別:array<ReportService2010. . :: . .Property> [] () [] []
Property 物件的陣列,定義要為資料來源設定的屬性名稱和值。
傳回值
型別:ReportService2010. . :: . .CatalogItem
新建立之資料來源的 CatalogItem 物件。
備註
The table below shows header and permissions information on this operation.
SOAP Header Usage |
(Out) ServerInfoHeaderValue |
Native Mode Required Permissions |
Creating a new data source: CreateDatasource on Parent Updating an existing data source: UpdateContent on DataSource Updating data source properties: UpdateContent AND UpdateProperties on DataSource |
SharePoint Mode Required Permissions |
Creating a new data source: AddListItems()()()() on Parent Updating an existing data source: EditListItems()()()() on DataSource |
If the .rsds extension is excluded from the data source name, an rsFileExtensionRequired error will be returned. If an .odc extension is given, an rsNotSupported error is returned.
If errors occur, the data source is not created.
The length of the Parent parameter cannot exceed 260 characters; otherwise, a SOAP exception is thrown with the error code rsItemLengthExceeded.
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.
範例
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