connection string in win forms

Question

0.00/5 (No votes)

See more:

hello all,

i am creating a windows application. in which i want to use sql database...for this i want to place connection string in a file (as like web.cinfig in web application).

but dont know where to place. Can any one suggest me the best ways to do that....??

Posted 14-Apr-13 21:54pm

abhishekagrwl25

Add a Solution

5 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)

Naz_Firdouse · Answer 1 · 2013-04-14T23:34:00

Solution 4

Assuming that you already have a config file with the connection string value set,

C#

SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings      ["MyConnectionString"].ToString();
DataTable dt2 = new DataTable();
SqlCommand cmd = new SqlCommand("dbo.SP_GetData", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);

adapter.Fill(dt2);

Now dt2 contains the data from the Db.

Your config file shouldbe like this

XML

<configuration>
  <connectionStrings>
    <add name="MyConnectionString" connectionString="Data Source=xxxx;Initial Catalog=xxxxx;Integrated Security=True;";/>
  </connectionStrings>
</configuration>

Posted 14-Apr-13 23:34pm

Naz_Firdouse

Comments

abhishekagrwl25 15-Apr-13 5:37am

i am using this code but still haveing an exception tha t "Object reference not set to an instance of an object.".

Naz_Firdouse 15-Apr-13 5:40am

Debug your code and see where it throws that exception..
It mainly happens when you are assigning some value to an object before initializing it

abhishekagrwl25 15-Apr-13 5:51am

SqlConnection con = new SqlConnection();
ConfigurationManager.RefreshSection("connectionstring");
con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStr"].ToString();

when compiling the last line...it showing error

this is my code....

Naz_Firdouse 15-Apr-13 5:54am

are you sure that the name in the config file is "ConnStr"

abhishekagrwl25 15-Apr-13 6:01am

<connectionstrings>
<add name="ConnStr" connectionstring="Data Source=SUSHIL\ABHISHEKSQLDB;Initial Catalog=test;User ID=sa;Password=hpbose@123;Pooling=False">

this is the code for app.config..

Naz_Firdouse 15-Apr-13 6:02am

where is the code?

abhishekagrwl25 15-Apr-13 6:07am

it is not showing code...i dont know why.....but name in the app.config is ConnStr

Naz_Firdouse 15-Apr-13 6:13am

the second line in your code should be
ConfigurationManager.RefreshSection("connectionStrings");
Not ConfigurationManager.RefreshSection("connectionstring");
you can even comment that line...

abhishekagrwl25 15-Apr-13 6:14am

i even tried commenting that line.....error is still tha same

Naz_Firdouse 15-Apr-13 6:16am

please check that the error may throw at some other point...
it works fine for me...

V. · Answer 2 · 2013-04-14T21:57:00

Solution 2

App.config has similar support like web.config, but for winforms.
Look here[^]

Posted 14-Apr-13 21:57pm

V.

Sergey Alexandrovich Kryukov · Answer 3 · 2013-04-14T21:56:00

Solution 1

Normally, you put it in a standard configuration file of the application. Please read this: http://msdn.microsoft.com/en-us/library/ms254494.aspx[^].

Good luck,

—SA

Posted 14-Apr-13 21:56pm

Sergey Alexandrovich Kryukov

Naz_Firdouse · Answer 4 · 2013-04-14T22:00:00

Solution 3

check this
http://www.c-sharpcorner.com/UploadFile/1a81c5/configuring-connection-string-in-app-config-file-during-runt/[^]

Posted 14-Apr-13 22:00pm

Naz_Firdouse

Comments

abhishekagrwl25 15-Apr-13 5:17am

i have created connection string in app.config file...but now when i write code to use conenction string, i am getting "object reference set to null exception."

my code is..:

SqlConnection con = new SqlConnection();
ConfigurationManager.RefreshSection("connectionstring");
con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStr"].ToString();

suggest me the solution..

babu saravanan · Answer 5 · 2013-04-15T01:44:00

Solution 5

add app.config file in your application

Posted 15-Apr-13 1:44am

babu saravanan