using System;
using System.Web.Services.Protocols;
class Sample
{
public static void Main()
{
ReportingService rs = new ReportingService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
string name = "AdventureWorks";
string parent ="/";
// 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());
}
}
}
说明:还可以设置parent 为/aaa
-----------------------------------------------------------------------
连接字符串 String. |
|
枚举值,获取数据源的凭证 Prompt:运行该报表的用户提供的凭据 Store:安全存储在报表服务器中的凭据 Integrated:Windows NT 集成安全性 None:不需要提供凭据 |
|
数据源是否可用. Boolean. |
|
显示指定Enabled属性值。Boolean |
|
扩展数据源: SQL, OLEDB, ODBC, 或自定义扩展. String. |
|
用户使用尝试是否使用“安全存储在报表服务器中的凭据”建立数据源. Boolean. |
|
显示指定 ImpersonateUser 属性值. |
|
密码. String. |
|
当需输入凭据的时候报表服务器呈现给用户的提示. String. |
|
用户名. String. |
|
Windows NT 集成安全性Boolean. |