how to access connection string from webconfig using DBConnection method

Question

0.00/5 (No votes)

See more:

using web application
in Appcode->DAL-> class DBbridge.cs

C#

public static string DBConnection()
       {
           try
           {
               return System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];

           }
           catch (Exception ce)
           {

              throw new ApplicationException("Unable to get DB Connection string from Config File. Contact Administrator" + ce);
           }
       }

while in web.config

XML

<connectionStrings>
    <add name="ConnectionString" connectionString="Data Source=.;Integrated Security=true;Initial Catalog=szicExam" providerName="System.Data.SqlClient"/>
  </connectionStrings>

but i am getting this error
Value cannot be null.
Parameter name: connectionString

C#

Line 490:        public static DataSet ExecuteDataset(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
Line 491:        {
Line 492:            if (connectionString == null || connectionString.Length == 0) throw new ArgumentNullException("connectionString");
Line 493:
Line 494:            // Create & open a SqlConnection, and dispose of it after we are done

Source File: f:\My Final Project with Data\MCQs Test System\MCQs Test System\App_Code\DAL\SQLHelper.cs    Line: 492

Posted 8-Sep-13 21:23pm

Muhamad Faizan Khan

Add a Solution

6 solutions

Solution 3

Try this

string conStr = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

Posted 9-Sep-13 0:01am

Gitanjali Singh

Solution 2

http://stackoverflow.com/questions/6134359/read-connection-string-from-web-config[^]

http://msdn.microsoft.com/en-us/library/ms178411.aspx[^]

Click here for more

regards...:)

Posted 8-Sep-13 22:31pm

Dholakiya Ankit

Solution 4

sqlconnection con=new sqlconnection(system.configuraton.configurationmanager.appsetting["ConnectionString"].tostring());

try this.........

Posted 9-Sep-13 0:39am

Kunal_Patel

Solution 5

For accessing connection string or database with reference to connection string mentioned in web.config file you can make use of SqlConnectionstringBuilder class.

Refer below links..

stBring[^]

Posted 20-Apr-14 22:50pm

RajeshwarReddy@.Net

Solution 6

string conn = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString

Posted 20-Apr-14 22:55pm

oliver grace

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)

liveoffedge · Accepted Answer · 2013-09-08T22:24:00

Solution 1

use this

System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"];

in place of

System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];

Posted 8-Sep-13 22:24pm

liveoffedge

Comments

Muhamad Faizan Khan 26-Apr-14 5:07am

also add toString();