Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Skip While Clause (Visual Basic)

Bypasses elements in a collection as long as a specified condition is true and then returns the remaining elements.

Skip While expression

Term

Definition

expression

Required. An expression that represents a condition to test elements for. The expression must return a Boolean value or a functional equivalent, such as an Integer to be evaluated as a Boolean.

The Skip While clause bypasses elements from the beginning of a query result until the supplied expression returns false. After expression returns false, the query returns all the remaining elements. The expression is ignored for the remaining results.

The Skip While clause differs from the Where clause in that the Where clause can be used to exclude all elements from a query that do not meet a particular condition. The Skip While clause excludes elements only until the first time that the condition is not satisfied. The Skip While clause is most useful when you are working with an ordered query result.

You can bypass a specific number of results from the beginning of a query result by using the Skip clause.

The following code example uses the Skip While clause to bypass results until the first customer from the United States is found.

Public Sub SkipWhileSample()
  Dim customers = GetCustomerList()

  ' Return customers starting from the first U.S. customer encountered. 
  Dim customerList = From cust In customers
                     Order By cust.Country
                     Skip While IsInternationalCustomer(cust)

  For Each cust In customerList
    Console.WriteLine(cust.CompanyName & vbTab & cust.Country)
  Next 
End Sub 

Public Function IsInternationalCustomer(ByVal cust As Customer) As Boolean 
  If cust.Country = "USA" Then Return False 

  Return True 
End Function
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.