Need Help in connection string

Question

<connectionStrings>
  <add name="mycollegeproject" connectionString="Data Source=mssql2.gear.host;Initial Catalog=mycollegeproject;Persist Security Info=True;User ID=mycollegeproject;Password=*******" />
</connectionStrings>

public static string strcon = ConfigurationManager.ConnectionStrings["mycollegeproject"].ConnectionString;

And the error

System.NullReferenceException: Object reference not set to an instance of an object.

Do you have connection string "mycollegeproject" in `app.config`/`web.config`? Name of connection string is case sensitive — Alexey Nis, Aug 02 '15 at 14:15
possible duplicate of [What is a NullReferenceException and how do I fix it?](http://stackoverflow.com/questions/4660142/what-is-a-nullreferenceexception-and-how-do-i-fix-it) — Bjørn-Roger Kringsjå, Aug 02 '15 at 14:21
Refer this link [enter link description here][1] [1]: http://stackoverflow.com/questions/18431147/how-to-write-connection-string-in-web-config-file-and-read-from-it This should solve your problem — user2632608, Aug 02 '15 at 14:38

Rahul · Answer 1 · 2015-08-02T14:28:54.463

0

If not wrong, mostly you have no connection string defined in your App.config named mycollegeproject (OR) you are using a different key name in your code rather than using mycollegeproject and so the below code line returns NULL resulting in NRE.

ConfigurationManager.ConnectionStrings["mycollegeproject"]

edited Aug 02 '15 at 14:28

answered Aug 02 '15 at 14:22

Rahul

71,392
13
57
105

Need Help in connection string

1 Answers1