ActiveReport_ReportStart绑定子报告脚本 [英] ActiveReport_ReportStart bind subreport script

问题描述

我正在使用Active Reports子报表工具，我希望通过连接Oracle将ActiveReport_ReportStart中的数据源绑定为脚本。我正在使用下面的脚本但是我遇到了这个错误：错误消息：[DBNETLIB] [Connection Open（Connect（））。] SQL Server不存在或访问被拒绝。无效的连接字符串属性。

  public   void  ActiveReport_ReportStart（）
 {
  string  connString =   Provider = SQLOleDB; User Id = XXX; Password = XX; Server = XXX; Service Name = XX; Direct = True; Persist Security Info = True< /跨度>; 
  string  sqlString =  @  sql query ; 
 DataDynamics.ActiveReports.DataSources.OleDBDataSource ds =  new  DataDynamics.ActiveReports.DataSources.OleDBDataSource（）; 
 ds.ConnectionString = connString; 
 ds.SQL = sqlString; 
 rpt.DataSource = ds; 
} 

它实际上是oracle连接，所以ı将连接字符串更改为：

Devart.Data.Oracle.OracleConnection con = new Devart.Data.Oracle.OracleConnection（）; con.ConnectionString =POOLING = FALSE; User Id = XX; Password = XX; Server = XX; Direct = True; Sid = XX; Persist Security Info = True;

DataTable dt = new DataTable（）;

Devart.Data.Oracle.OracleDataAdapter da = new Devart.Data.Oracle.OracleDataAdapter（sqlString，con）;

da.Fill（dt）;

sbrpt.DataSource = dt;



但这次我有无法找到类型或命名空间Devart！



我试过了;

arDesigner.Report.AddScriptReference（Devart.Data.Oracle.dll）;

但它不起作用！



提前谢谢...

解决方案

添加对Devart.Data.dll和Devart.Data.Oracle.dll的引用。如果这没有帮助，请创建一个小型测试项目并通过

发送给我们的支持团队 http://www.devart.com/company/contact.html 。

I''m using Active Reports Subreport tool, I want to bind data source in ActiveReport_ReportStart as script by connecting Oracle. I''m using the script below but I''m having this error: Error Message:[DBNETLIB][Connection Open (Connect()).]SQL Server does not exist or access denied. Invalid connection string attribute.

public void ActiveReport_ReportStart()
{
string connString = "Provider=SQLOleDB;User Id=XXX;Password=XX;Server=XXX;Service      Name=XX;Direct=True;Persist Security Info=True";
string sqlString = @"sql query";
DataDynamics.ActiveReports.DataSources.OleDBDataSource ds = new     DataDynamics.ActiveReports.DataSources.OleDBDataSource();
ds.ConnectionString = connString;
ds.SQL = sqlString;
rpt.DataSource = ds;
}

it is actually oracle connection, so ı changed the connection string to :
Devart.Data.Oracle.OracleConnection con = new Devart.Data.Oracle.OracleConnection(); con.ConnectionString = "POOLING=FALSE;User Id=XX;Password=XX;Server=XX;Direct=True;Sid=XX;Persist Security Info=True";
DataTable dt = new DataTable();
Devart.Data.Oracle.OracleDataAdapter da = new Devart.Data.Oracle.OracleDataAdapter(sqlString, con);
da.Fill(dt);
sbrpt.DataSource = dt;

But this time I''m having "Type or namespace Devart could not be found!"

I have tried ;
arDesigner.Report.AddScriptReference("Devart.Data.Oracle.dll");
but it does not work!

Thanks in advance...

解决方案

Add references to both Devart.Data.dll and Devart.Data.Oracle.dll. If this doesn''t help, please create a small test project and send it to our support team via
http://www.devart.com/company/contact.html.

这篇关于ActiveReport_ReportStart绑定子报告脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！