connection string retrivation

Question

0.00/5 (No votes)

See more:

hello.
i have some problem with retriving connection string from aapcofig file.
please help me.
i m giving codes below.

<in config="" file="">

XML

<?xml version="1.0" encoding="utf-8" ?>
<configuration>

  <connectionStrings>

    <add name="con" connectionString="Server=.;Database=prince;Integrated Security=true"/>

  </connectionStrings>

</configuration>

(Code Behind)

string connection = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
but its not working.
i have also used

C#

using System.Configuration;
using System.Data.SqlClient;

please help me
regards
dibyaranjan

Posted 21-Feb-13 23:25pm

dibyaaryan007

Updated 21-Feb-13 23:28pm

v2

Add a Solution

Comments

Om Prakash Pant 22-Feb-13 6:01am

try this:
ConfigurationManager.ConnectionStrings["con"].ToString();

José Amílcar Casimiro 22-Feb-13 6:03am

Are you getting any error ?

Orcun Iyigun 22-Feb-13 6:07am

What is the error?

Shubh Agrahari 22-Feb-13 7:40am

this is basically in window application guys......1st understand the exactly need of code seeker....

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)

Shubh Agrahari · Answer 1 · 2013-02-22T01:39:00

Hi all

1st of all i want two share that web.config and app.config is two different files that use different different role 1st one for web application and 2nd one is for window application ....

there is two way to achieve connection string by Integrated Security ="true" or by setting User ID and Password...

you have to try this one

XML

<configuration>
  <appsettings>
    <add key="con" value="server=.;User Id=root;password=password;database=prince;" />
  </appsettings>
</configuration>

happy to help.

CShubham · Answer 2 · 2013-02-22T00:00:00

Solution 1

here is the way to give connection string

<appsettings>
<connectionstrings>

XML

<configuration>
<pre lang="HTML">
 <add name="mmisConnectionString" connectionString="server=localhost;User Id=root;password=password;database=mmis" providerName="MySql.Data.MySqlClient" />

</connectionStrings>

</configuration>

Posted 22-Feb-13 0:00am

CShubham

Updated 22-Feb-13 0:04am

v2

Comments

Orcun Iyigun 22-Feb-13 6:18am

the provider name is not a necessity.

[no name] 22-Feb-13 6:22am

ya but also no any error issue at all with provider name.....

Ksh_Sr · Answer 3 · 2013-02-24T20:31:00

Solution 5

If for all above solution your code is still not working then

You need to add referece to reference folder in solution explorer for System.Configuration

Posted 24-Feb-13 20:31pm

Ksh_Sr

Anele Ngqandu · Answer 4 · 2013-02-22T01:10:00

Solution 2

HI

XML

<connectionstrings>
    <add name="con" connectionstring="Data Source=localhost;Initial Catalog=DataBaseName;Integrated Security=True;" providername="System.Data.SqlClient" />
  </connectionstrings>

localhost or your computername

Posted 22-Feb-13 1:10am

Anele Ngqandu

Sisir Patro · Answer 5 · 2013-02-22T01:54:00

HI,

Use the following code in your webconfig file :

C#

<configuration>
  <appsettings>
    <add key="conn" value="connection string here" />    
  </appsettings>
  </configuration>

From the code behind you can able to access that like the following code.

myConnection = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["conn"]);

Thanks