VB NOTES PART 19

VB NOTES PART 19 - -Query is not executed until results are...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
4/14 Language-Integer Queries (LINQ) Executes a SQL-like query on any data source When query is executed, it returns a collection Dim tmeCollection As List (of Time) = New List (Of Time) () Dim t1 As Time = New Time (10, 20) timeCollection.Add (+1) 10 t1.Minute =5 20 t1.Second =20 5 timeCollection.Add (+1) 20 Dim timeQuery = From t in timeCollection -------------- range variable t data source timeCollection Where t.Minute =5 ------------- Boolean condition Select t ---------- value to return in result For each viewTime in timeQuery 5 myListBox.Items.Add (viewTime. Second) 20 Next myListBox
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: --Query is not executed until results are used 20--Result of query is an IEnumerable (Of Time) returns a collection of Integer (Interface set of common methods) 20 Sequential-access Files Data hierarchy Bit Byte Character Field-group of characters with same meaning E.g. name, ID, salary ….represented as a variable in VB Record-group of related-fields E.g. employee, student, etc…. .in VB, an object File-collection of records Records often have a key-one field that uniquely identifies the records VB treats files as a stream of bytes...
View Full Document

{[ snackBarMessage ]}

Page1 / 2

VB NOTES PART 19 - -Query is not executed until results are...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online