VB.NET - How to Print Content of Textbox

This Microsoft link will explain everything: Print Content of Textbox

VB.NET - Find Differences Between 2 Arrays

To get an array of common items between 2 arrays, use the .Except method off of the first array.

i.e.:

Dim strDifferences As String()
Dim strUserGroups As String()
Dim strOrgGroups As String()

strDifferences= strUserGroups.Except(strOrgGroups).ToArray()

VB.NET - Find Common Items Between 2 Arrays

To get an array of common items between 2 arrays, use the .Intersect method off of the first array.

i.e.:

Dim strSimilarities As String()
Dim strUserGroups As String()
Dim strOrgGroups As String()

strSimilarities = strUserGroups.Intersect(strOrgGroups).ToArray()

SQL - Update Statement from Join

UPDATE    p

SET       p.phone_ext = d.phone

FROM      people p

JOIN      directory d

ON        p.last_name = d.last_name