MVC项目中 AcctiveReport 报表如何切换ConnectionString

收藏

本帖最后由防水的泡泡于 2016-8-24 11:06 编辑

如题

<DataSources>
<DataSource Name="Best">
<ConnectionProperties>
<ConnectString>initial catalog=Best;password=landa;user id=sa;data source=192.168.0.111\sql2008;</ConnectString>
<DataProvider>SQL</DataProvider>
</ConnectionProperties>
</DataSource>
</DataSources>

复制代码

Lenka.Guo · Lenka.Guo

是要通过后台代码切换数据库连接，在生成报表对象时，修改DataSources属性；

         DataSource dataSource = new DataSource();
         dataSource.Name = "Reels Database";
         dataSource.ConnectionProperties.DataProvider = "OLEDB";
         dataSource.ConnectionProperties.ConnectString = ExpressionInfo.FromString(“initial catalog=Best;password=landa;user id=sa;data source=192.168.0.111\sql2008”);

         DataSet dataSet = new DataSet();
         Query query = new Query();
         dataSet.Name = "Sample DataSet";
         query.DataSourceName = "Reels Database";

         query.CommandType = QueryCommandType.Text;
         query.CommandText = ExpressionInfo.FromString(Constants.cmdText);
         dataSet.Query = query;
         String[] fieldsList = new String[] { "MoviedID", "Title", "YearReleased", "MPAA" };
         foreach (string fieldName in fieldsList)
         {
            Field field = new Field(fieldName, fieldName, null);
            dataSet.Fields.Add(field);
         }

         report.Report.DataSources.Add(dataSource);
         report.Report.DataSets.Add(dataSet);

防水的泡泡 · 防水的泡泡

Lenka.Guo 发表于 2016-8-24 10:44
是要通过后台代码切换数据库连接，在生成报表对象时，修改DataSources属性；

DataSource da ...

/// <summary>
/// ActiveReportService 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消注释以下行。
[System.Web.Script.Services.ScriptService]
public class ActiveReportService : GrapeCity.ActiveReports.Web.ReportService
{
protected override object OnCreateReportHandler(string reportPath)
{
var instance = base.OnCreateReportHandler(reportPath);
var pageReport = instance as PageReport;
if (pageReport != null)
{
pageReport.Document.LocateDataSource += Document_LocateDataSource;
}
return instance;
}
void Document_LocateDataSource(object sender, LocateDataSourceEventArgs args)
{
}
}

复制代码

Lenka.Guo · Lenka.Guo

如电话沟通，通过 definition1.Report.DataSources[0]来修改连接字符串

		自动登录	找回密码
密码			立即注册

[已处理] MVC项目中 AcctiveReport 报表如何切换ConnectionString

3 个回复

微信认证勋章

活字格认证

讲师达人

悬赏达人

元老葡萄