Content

Skip While Clause
 Syntax
 Parts
 Remarks
 Example
 See also
 Source/Reference

Skip While Clause

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

Syntax

Skip While expression

Parts

TermDefinition expressionRequired. 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.

Remarks

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.

Example

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

Source/Reference

©sideway

ID: 210500020 Last Updated: 5/20/2021 Revision: 0 Ref:

References

Active Server Pages, , http://msdn.microsoft.com/en-us/library/aa286483.aspx
ASP Overview, , http://msdn.microsoft.com/en-us/library/ms524929%28v=vs.90%29.aspx
ASP Best Practices, , http://technet.microsoft.com/en-us/library/cc939157.aspx
ASP Built-in Objects, , http://msdn.microsoft.com/en-us/library/ie/ms524716(v=vs.90).aspx
Response Object, , http://msdn.microsoft.com/en-us/library/ms525405(v=vs.90).aspx
Request Object, , http://msdn.microsoft.com/en-us/library/ms524948(v=vs.90).aspx
Server Object (IIS), , http://msdn.microsoft.com/en-us/library/ms525541(v=vs.90).aspx
Application Object (IIS), , http://msdn.microsoft.com/en-us/library/ms525360(v=vs.90).aspx
Session Object (IIS), , http://msdn.microsoft.com/en-us/library/ms524319(8v=vs.90).aspx
ASPError Object, , http://msdn.microsoft.com/en-us/library/ms524942(v=vs.90).aspx
ObjectContext Object (IIS), , http://msdn.microsoft.com/en-us/library/ms525667(v=vs.90).aspx
Debugging Global.asa Files, , http://msdn.microsoft.com/en-us/library/aa291249(v=vs.71).aspx
How to: Debug Global.asa files, , http://msdn.microsoft.com/en-us/library/ms241868(v=vs.80).aspx
Calling COM Components from ASP Pages, , http://msdn.microsoft.com/en-us/library/ms524620(v=VS.90).aspx
IIS ASP Scripting Reference, , http://msdn.microsoft.com/en-us/library/ms524664(v=vs.90).aspx
ASP Keywords, , http://msdn.microsoft.com/en-us/library/ms524672(v=vs.90).aspx
Creating Simple ASP Pages, , http://msdn.microsoft.com/en-us/library/ms524741(v=vs.90).aspx
Including Files in ASP Applications, , http://msdn.microsoft.com/en-us/library/ms524876(v=vs.90).aspx
ASP Overview, , http://msdn.microsoft.com/en-us/library/ms524929(v=vs.90).aspx
FileSystemObject Object, , http://msdn.microsoft.com/en-us/library/z9ty6h50(v=vs.84).aspx
http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944(v=vs.85).aspx, , ADO Object Model
ADO Fundamentals, , http://msdn.microsoft.com/en-us/library/windows/desktop/ms680928(v=vs.85).aspx