C#

Raztor0 wrote:

solving it by adding static is a good solution

while(sqlReader.Read())
{
  // do reads here
}

while (sqlReader.Read())
{
    // do something with the row
}

while (sqlReader.Read())
    {
      //test for data field
      while(sqlReader["SOME FIELD"] == variable) 
        {
          //do work, write data to file, yada, yada
          sqlReader.Read()//advance to next record
          if (!sqlReader.HasRows)//there's no more data
           {
              blEnd = true;
              break
           }
         if (blEnd){break} //break out of sqlReader.Read() loop
        //do more work, yada, yada    
       }
      //end of sqlReader.Read(), loop
    }

sqlReader.Read()//advance to next record
if (!sqlReader.HasRows)//there's no more data

bool found = false;

while (sqlReader.Read() && !found)
{
    if (sqlReader["SOME FIELD"] == DBNull.Value)
    {
        // advance to the next row
        continue;
    }

    // convert the data to the appropriate type here, I'm using string as an example
    string dbVal = sqlReader["SOME FIELD"] as string;

    if (dbVal != variable)
    {
        // advance to the next row
        continue;
    }

    // value is found!
    found = true;
    // do something . . . 
}