How to take database info while creating dll

Question

0.00/5 (No votes)

See more:

Hi all

Im creating dll for each screens in my project .I have a class which contains all database operations. when creating dll for this class im giving database info like this

string strconnection = "Data Source=CLIENT01;Initial Catalog=dbname;User ID=sa;Password=pawd.;";
iam referencing this dll in number of places
but when iam changing the connection info i have to again refer this dll in every where in my project as it is a common dll.
Is there any other methods giving database info in my project so that database class dll refer this location(like appconfig)
how to take value of database info while creating database class dll

Thanks in Advance

Posted 8-Mar-12 20:53pm

amritha444

Add a Solution

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)

Oshtri Deka · Accepted Answer · 2012-03-08T21:18:00

Yes, you can.
Store connection string in config file (or even project Settings) instead of hard coding it.

Read this if you are interested in using standard .Net configuration.

Alternatively you can store data you're interested in .txt or .xml file with format and complexity of your own choosing.

I hope this helps.

P.S.
If you feel nostalgic for good old days, you can always store your data in .ini file.