Define crystal report datasource in app.config

Question

0.00/5 (No votes)

See more:

Hi

How can i configure Crystal report datasource in app config?
so that every time the server change, i can easily change the report data source on app.config like changing the connection, do you have a tutorial or sample code that is similar tom problem? thanks in advance

Posted 1-Jun-14 20:44pm

Cuculala

Add a Solution

Comments

DamithSL 2-Jun-14 2:55am

it depend on how you set the report data source. can you update the question with the related code?
for example if you set the data source as from DataSet by code, you can get read the connection string from app config and load the data set at run time

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*Abhishek Pant* · Answer 1 · 2014-06-01T20:46:00

Solution 1

How to get Connection String from App.Config in C#[^]

How to Store and Retrieve a ConnectionString from a Web.Config or App.Settings File[^]

Crystal Reports ConnectionString and sql Commands[^]

Using Application Configuration Files in .NET[^]

----
about crystal reports connection string[^]

Posted 1-Jun-14 20:46pm

Abhishek Pant

Updated 1-Jun-14 20:53pm

v3

Comments

Cuculala 2-Jun-14 2:50am

I dont have a problem on the connection string,
Is that possible to add my report source on the app config?

Abhishek Pant 2-Jun-14 2:53am

check out the last link updated

Cuculala 2-Jun-14 3:46am

i have this connection on my app.config
<add name="ConMe" connectionstring="Data Source=myDSource;Initial Catalog=db_sample;Integrated Security=True; ">

Can i use "ConMe" on the report.DataSourceConnections[0].SetConnection(strServer, strDatabase, strUserID, strPwd) instead?