Change connection string using VB.Net Code

[James Wong]

Sometimes the Access database location is change. I want the user to specify the new location of this database and have the new location set in the connection string. How do I use VB.Net code to change the connection string before viewing the report?


Thanks.

[Alex K.]

Hello,

You can use the following code:

Code: Select all

DirectCast(report.Dictionary.Databases("Connection"), StiSqlDatabase).ConnectionString = "New connection string"

Thank you.

[ainaz]

Hello

I have the same question


Can you explain more where should I use this code

Is there a file like C# (app.config)

Please enter the code again to C #

Thank you

[Alex K.]

Hello,

You can use the following code:

Code: Select all

((StiSqlDatabase)report.Dictionary.Databases["Connection"]).ConnectionString = "New connection string";

Thank you.