SQL = dbSession
SQL * Select(EMPLOYEE_ID, FIRST_NAME, LAST_NAME).From(PUNCH_VIEW);

while(SQL.Fetch(view))
{
    if(SQL[FIRST_NAME] == "John")
    {
        // add this text to a GridCtrl
    }

}