Creating reports and dashboards | Stimulsoft community forum

Posted: **Wed Jan 15, 2014 10:22 am**

Hi,

I want to change the SQL Connection (that is already exists in the mrt file) dynamically by .Net code.

I tried:

report.Dictionary.DataSources.Clear();
report.Dictionary.DataSources.Add(new StiSqlSource("DBConnection", hhh.ConexaoAtiva.ConnectionString));

But not work.

Could you help-me?

Thanks
Rafael Mello

Posted: **Wed Jan 15, 2014 10:28 am**

Hello,

Please try to use the following code:

Code: Select all

((StiSqlDatabase)report.Dictionary.Databases["DBConnection"]).ConnectionString = hhh.ConexaoAtiva.ConnectionString);

or

Code: Select all

report.Dictionary.Databases.Clear();
report.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("DBConnection", hhh.ConexaoAtiva.ConnectionString));

Thank you.

Posted: **Wed Jan 15, 2014 11:02 am**

Thank you Aleksey, your code works fine!

best regards
Rafael Mello

Posted: **Wed Jan 15, 2014 11:10 am**

Hello,

We are always glad to help you!

Creating reports and dashboards | Stimulsoft community forum

Change SQL connection dynamically (data sources)

Change SQL connection dynamically (data sources)

Re: Change SQL connection dynamically (data sources)

Re: Change SQL connection dynamically (data sources)

Re: Change SQL connection dynamically (data sources)