Connection String

[Surya]

We have an ASP.NET AJAX application that uses Telerik Components including Telerik Reporting. We have three distinct environments viz., Development, Staging and Production. We currently have connection strings for each of these environments in Web.Config and have a setting that indicates which environment we are currently in. Depending on the environment setting, we use the appropriate connection strings.

When it comes to Telerik Reporting, we are setting the connection string of the report designer to use the application connection string of a specific environment. However, when moving the application to a different environment say for example 'Production' we have to go into each of the those reports and point all the datasources to use the connection string pertaining to 'Production'.

Is there any better way to handle this instead of changing it in every single report and for every deployment to a different environment?

Appreciate your input and help...

[IvanY]

Hello Surya,

In your case it seems that you can easily use named connection strings and for each environment to have the same named connection string with a different value. Whenever you change the option from Staging to Production for example in the solution configurations drop down, the connection string will be automatically picked from your Web.Production.config file.

If for some reason you cannot do this you can assign the connection string of each datasource using a parameter, like this:

this.sqlDataSource1.ConnectionString = "Data Source=" + myDataSource + ";Initial Catalog=AdventureWorks;Integrated Security=SSPI";

It will be best if you place this code snippet in the constructor of your report.

Regards,
IvanY
the Telerik team