1

I want to connect to sql DB, and I have in my Sharepoint project an App.config (with properties : Build "None", Copy to Output directory"Copy always"), I added a reference to System.Configuration.dll (Version 2), and my app.config is like that :

<connectionStrings>   
    <add name="ExchangeRate" connectionString="Data Source=CH-SQL;Initial Catalog=COMMON;User ID=_cb;Password=***" />
  </connectionStrings>

I call the connection string in my code :

using System;
using System.Configuration;
...
 exchangeRate = System.Configuration.ConfigurationManager.ConnectionStrings["ExchangeRate"].ConnectionString;

in my project.exe.config , I can see connectionString

I have the following error :

Object reference not set to an instance of an object

Maybe my app.config is not working correctly

Help please

Thanks

1 Answer 1

0

This is how you define your connection in web.config

<connectionStrings>
      <add name="MyConnectionString" 
         connectionString ="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\PUBS.MDF; 
                            Integrated Security=True;User Instance=True" />
    </connectionStrings>

And to use the connection string, use the below code.

private SqlConnection con = null;
con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);
8
  • I tried your solution but it still same error , PS : when I use a string instead of connectionString it connects me
    – BKChedlia
    Commented Aug 17, 2016 at 9:45
  • Are you able to connect with DB now ?
    – Muskan
    Commented Aug 17, 2016 at 9:53
  • When I put string (and not read from app.config) I am able : string connstr = "Data Source=CH-SQLD;Initial Catalog=LOGS;User ID=***;Password=***"; DataProviderUtility.ExecuteStoredProcedureToSqlDatabase(sqlParam, StoredProcedures.CREATELOG, connstr)
    – BKChedlia
    Commented Aug 17, 2016 at 9:55
  • 1
    Have you added this connection string in STS and Central admin web.config file as well, if not pls try that
    – Muskan
    Commented Aug 17, 2016 at 10:00
  • could you please give me further details, sorry for the dumb questions : what's STS? I cannot find web.config (it's a solution developed by another person, I am just making few changes)
    – BKChedlia
    Commented Aug 17, 2016 at 10:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.