C#

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 . . . 
}

ika2 wrote:

Is there something equivalent in .net 2.0?

public class Controller : IController
{
    private State state;
    private Speed speed;

    public class ProductHandler
    {
        public void ChangeState(State newState)
        {
        }
    }
}

hotthoughtguy wrote:

if i compile my wpf project in xp
and execute it on vista.

will it be executing normally.

hotthoughtguy wrote:

i had an experience it from windows form application. it was not ruing on vista. i faced color combination problem.