How to get variable outside loop?

Question

I have this:

 countReader = command7.ExecuteReader();
 while (countReader.Read())
 {
    string countName = countReader["count(*)"].ToString();                
 }

How to get string countName outside while loop?

What is "count(*)"? That doesn't look like a valid column name to me. Are you trying to get the sum of that column? If not, what are you trying to accomplish? — Tim
– Tim, Commented Sep 4, 2011 at 10:14

Haris Hasan · Accepted Answer · 2011-09-04 09:59:03Z

1

If you want to access a variable outside the while loop you should declare it outside like this

countReader = command7.ExecuteReader();
string countName = String.Empty;

 while (countReader.Read())
 {
  countName = countReader["count(*)"].ToString();                
 }

answered Sep 4, 2011 at 9:59

Haris Hasan

30.1k13 gold badges97 silver badges124 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Darin Dimitrov · Accepted Answer · 2011-09-04 09:59:23Z

1

You could declare it in the outer scope:

countReader = command7.ExecuteReader();
string countName = "";
while (countReader.Read())
{
    countName = countReader["count(*)"].ToString();                
}
// you can use countName here

Note that because you are overwriting its value on each iteration, outside the loop you will get its value from the last iteration or an empty string if the loop didn't execute.

answered Sep 4, 2011 at 9:59

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

2 Comments

Damian Leszczyński - Vash Over a year ago

If i may suggest somenthing. One change "" to String.Empty.

Tim Over a year ago

+1 for noting that the countName will be overwritten on each loop, if there's more than one row in the reader.

Paul Ridgway · Accepted Answer · 2011-09-04 09:59:11Z

0

string countName;
countReader = command7.ExecuteReader();
while (countReader.Read())
{
   countName = countReader["count(*)"].ToString();                
}

The scope will mean it is still accessible after the loop is exited.

answered Sep 4, 2011 at 9:59

Paul Ridgway

1,0652 gold badges14 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to get variable outside loop?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related