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 431
1 Afzaal Ahmad Zeeshan 184
2 /\jmot 176
3 Sergey Alexandrovich Kryukov 175
4 Marcin Kozub 175
0 OriginalGriff 8,344
1 Sergey Alexandrovich Kryukov 7,407
2 DamithSL 5,634
3 Maciej Los 5,024
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.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