How to use connection string in desktop application for connectivity

Question

0.00/5 (No votes)

See more:

.NET3.5

i am making desktop application....i have made form inwhich i made 4 buttons ADD,SAVE,UPDATE,DELETE .I am using SQL SERVER 2008 database.i am able to connect data with SQL.Now the problem is for each button's coding i have to write the following coding again and again

SqlConnection con = new SqlConnection("Data Source=SW-PC-20;Initial Catalog=PSM;Integrated Security=True");

and when i copy the project from one system to another,I have change the data source every time for all forms which become time consuming........
can i have concept of connection string and how to use.
thanx in advance
regards

Posted 14-May-11 21:45pm

shivani 2013

Add a Solution

4 solutions

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)

Kim Togo · Answer 1 · 2011-05-14T21:56:00

Solution 2

You can save the connection string in Application Settings[^] (See CP How To Use the Settings Class in C#[^])

In your code you can the do:

// Properties.Settings.Default.DatabaseSettings - Contains your connection string.
SqlConnection con = new SqlConnection(Properties.Settings.Default.DatabaseSettings);

This way, you have one connection string saved in the file "MyProgram.exe.config".

Posted 14-May-11 21:56pm

Kim Togo

Updated 14-May-11 21:57pm

v2

Comments

yesotaso 15-May-11 6:36am

5 + "Properties.Settings.Default.DatabaseSettings" is almost as long as the connection string itself :).

Kim Togo 15-May-11 7:46am

Thanks :-) By the way. What is the longest variable the you can declare in C# ?

sabindas k s · Answer 2 · 2011-05-14T22:57:00

You can use the connections string property in app.config file;

XML

<configuration>
         <connectionStrings>
        <add name="studentConnectionString" connectionString=" Data Source=SW-PC-20;Initial Catalog=PSM;Integrated Security=True;Integrated Security=True;  providerName="System.Data.SqlClient"/>
    </connectionStrings>
</configuration>

In code behind, you can call this connection string using the code ,

XML

SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["studentConnectionString"].ConnectionString);

After that you need to change the connection string part only. becouse you are refering using name only.

hop you got the idea. if you need more clarification,
please ping me.

Abhinav S · Answer 3 · 2011-05-14T21:48:00

Solution 1

Check out http://www.connectionstrings.com[^] for detailed explanation on using connection strings with various technologies.

Posted 14-May-11 21:48pm

Abhinav S

YOGESH DHAGE · Answer 4 · 2011-05-15T19:19:00

Solution 4

Better way to do that you can make a single class for database connectivity.With the help of class object you can connect with the database.So the redundancy will be reduce.........

Posted 15-May-11 19:19pm

YOGESH DHAGE