Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
im developing a winform and i store my connection in App.config
<add key="CS" value="Server=localhost;User ID=root;Password=123456;Persist Security Info=True;Database=dbMember"/>
 
and this is how i call the connectionString from C#
string CS = System.Configuration.ConfigurationManager.AppSettings.Get("CS");
 
yes, it can run smoothly at my machine, how it show error msg: "the connection property has not been set or is null", when i try to run it at another PC.
 
but it working at another PC if i manually code the connectionstring like this:
string CS= "Server=localhost;User ID=root;Password=123456;Persist Security Info=True;Database=dbMember";
 
any advice? i already install the same version of sql at both PC
Posted 22-Jan-13 22:33pm
Comments
Amol_B at 23-Jan-13 4:48am
   
"the connection property has not been set or is null" is indication of non initialization of connection. You are reading string from config file, but are you using it in connection?

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You shouldn't store and access your connection strings this way.
Do it as suggested by Microsoft: http://msdn.microsoft.com/en-us/library/ms254494(v=vs.80).aspx[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,107
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,382


Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 23 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100