[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1690
  • Last Modified:

Setting connection string of the report viewer

I am using Visual Studio 2010 as the IDE,Microsoft SQL Server 2005 database as the backend database and the report viewer control to build reports. The report viewer currently reads the connection strings from the web.config file. I would like to encrypt the connection string in the web.config file and set the connection string of the report viewer dynamically. How can I go about doing this.

Thanks,
Aditya
0
pmac38CDS
Asked:
pmac38CDS
  • 3
1 Solution
 
SAMIR BHOGAYTAFreelancer and IT ConsultantCommented:
Hi, you have to use the dataset.xsd for retrieving the data from database into your report file. And at the time of creating dataset you have to define the connection string.
0
 
pmac38CDSAuthor Commented:
Can you give more specific examples? So for example I have an encrypted connection string in the web.config. How do I set the connection string of the report viewer(remember I am using the report viewer control in Visual Studio 2010) dynamically.
0
 
pmac38CDSAuthor Commented:
Nevermind I figured it out. The designer.cs file was missing in the solution. Once I added that I was able to set it.

Thanks for all your help,
Aditya
0
 
pmac38CDSAuthor Commented:
Nevermind I figured it out. The designer.cs file was missing in the solution. Once I added that I was able to set it.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now