Solved

Setting connection string of the report viewer

Posted on 2011-03-10
5
1,595 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Find unused columns in a table 12 67
How can I find this data? 3 23
create dataset from text files to go on winforms gridview 3 24
Need help with another query 10 34
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

685 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