ReportingService.CreateDataSource创建数据源方法

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
-----------------------------------------------------------------------

ConnectString	连接字符串 String.
CredentialRetrieval	枚举值,获取数据源的凭证 Prompt：运行该报表的用户提供的凭据 Store：安全存储在报表服务器中的凭据 Integrated：Windows NT 集成安全性 None：不需要提供凭据
Enabled	数据源是否可用. Boolean.
EnabledSpecified	显示指定Enabled属性值。Boolean
Extension	扩展数据源: SQL, OLEDB, ODBC, 或自定义扩展. String.
ImpersonateUser	用户使用尝试是否使用“安全存储在报表服务器中的凭据”建立数据源. Boolean.
ImpersonateUserSpecified	显示指定 ImpersonateUser 属性值.
Password	密码. String.
Prompt	当需输入凭据的时候报表服务器呈现给用户的提示. String.
UserName	用户名. String.
WindowsCredentials	Windows NT 集成安全性Boolean.

 

转载于:https://www.cnblogs.com/battler/archive/2005/05/09/151802.html