Why is there a ConnectionString not initialized error

Question

Content page:

protected void Page_Load(object sender, EventArgs e) { string gs = ConfigurationManager.ConnectionStrings["ging"].ConnectionString; if (Master.showCheck(s)) { //do something... } }

MasterPage:

string gs = ""; protected void Page_Load(object sender, EventArgs e) { gs = ConfigurationManager.ConnectionStrings["ging"].ConnectionString; } public bool showCheck(string strID) { string strCheckIfParentExist = @""; using (SqlConnection scConn = new SqlConnection(gs)) { scConn.Open(); //throws an error: 'The ConnectionString property has not been initialized' } }

Why do I receive the following error: The ConnectionString property has not been initialized

I suspect because your connection string is empty, so gs has no value. Some debugging would be able to check that. — vcsjones
– vcsjones, Commented Mar 27, 2015 at 20:02
I have the gs set in the page load for the MasterPage. Do I need to add another one inside the showCheck() function? — SearchForKnowledge
– SearchForKnowledge, Commented Mar 27, 2015 at 20:03
do you have the ConnectionStrings tag setted in web.config file? — lem2802
– lem2802, Commented Mar 27, 2015 at 20:05
Shouldn't that "gs" be a class member not a local variable? the code as posted does not seem to be compilable. — Ismail Hawayel
– Ismail Hawayel, Commented Mar 27, 2015 at 20:14

RandomUs1r · Accepted Answer · 2015-03-27 20:16:14Z

change

protected void Page_Load(object sender, EventArgs e) { string gs = ConfigurationManager.ConnectionStrings["ging"].ConnectionString; } public bool showCheck(string strID) { string strCheckIfParentExist = @""; using (SqlConnection scConn = new SqlConnection(gs)) { scConn.Open(); //throws an error: 'The ConnectionString property has not been initialized' } }

To

private string gs = ""; protected void Page_Load(object sender, EventArgs e) { gs = ConfigurationManager.ConnectionStrings["ging"].ConnectionString; } public bool showCheck(string strID) { string strCheckIfParentExist = @""; using (SqlConnection scConn = new SqlConnection(gs)) { scConn.Open(); //throws an error: 'The ConnectionString property has not been initialized' } }

Basically your variable is getting declared in a different method from where you're calling it, so you just need to increase it's scope to the class.

If he is really going to go that route, he should declare it as a private readonly that he can inject throughout the page life cycle.
@SearchForKnowledge You should do: private readonly string dbConnection = ConfigurationManager.ConnectionStrings["..."].ConnectionString; Then you can simply utilize dbConnection. Also, I recommend not storing a connection for a master page.
Greg agreed, that's how I typically do it. SearchForKnowledge then why are you declaring it again in your page load? + that wouldn't compile.

Ismail Hawayel · Accepted Answer · 2015-03-27 20:41:42Z

If you have "gs" as a class member, change the content page to

protected void Page_Load(object sender, EventArgs e) { gs = ConfigurationManager.ConnectionStrings["ging"].ConnectionString; if (Master.showCheck(s)) { //do something... } }

string def you have there is shadowing the class member.

Collectives™ on Stack Overflow

Why is there a ConnectionString not initialized error

2 Answers 2

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Related