Change SQL connection dynamically (data sources)

[mellorafael]

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

[Alex K.]

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.

[mellorafael]

Thank you Aleksey, your code works fine!

best regards
Rafael Mello

[Alex K.]

Hello,

We are always glad to help you!