Solved

Setting connection string of the report viewer

Posted on 2011-03-10
5
1,585 Views
Last Modified: 2012-06-21
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
Comment
Question by:pmac38CDS
  • 3
5 Comments
 
LVL 11

Expert Comment

by:SAMIR BHOGAYTA
ID: 35096310
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
 
LVL 13

Expert Comment

by:agarwalrahul
ID: 35096465
0
 
LVL 1

Author Comment

by:pmac38CDS
ID: 35097349
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
 
LVL 1

Accepted Solution

by:
pmac38CDS earned 0 total points
ID: 35273942
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
 
LVL 1

Author Closing Comment

by:pmac38CDS
ID: 35312691
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question