Dim Arr3 As New ArrayList
Dim SQLdr As SqlDataReader
Dim StrCol3 As String
If StrCol3 <> String.Empty Then
If IsDBNull(SQLdr(StrCol3)) = False Then
StrColval3 = SQLdr(StrCol3)
StrColval3 = StrColval3.Trim
If StrColval3 <> String.Empty Then
'Check for duplicates in array
If Not (Arr3.Contains(StrColval3)) AndAlso Not (Arr3.Contains(StrColval3.ToLower)) Then
If Not (Arr3.Contains(StrColval3.ToUpper)) Then
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex.
A simple solution to parsing a customized CSV fi…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this?
In .NET 3.5, this is possible…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online)
The email signat…
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…