Here my library of VB.Net function written during many years.

I know that VB is used just by a few number of people, compared to C#.
But VB is more elegant and less compressed.

BASIC was the third language that I learned (after the Digital PDP-11 assembler and FORTRAN, more or less half a century ago).
Writing code was awkward using a teletype to interact with the PDP-11…

VB is an old style language but, considering my age, I don’t see any reason to switch to C#.

So, VB FOREVER!

Note: many of the functions/forms use some other functions of my library, so be sure to include also the required additional ones.

• Access Functions
  • Execute Non Query on Access Table
  • Load Access Table to Datatable
• Active Directory Functions
  • Get All Group Users
  • Get All Users From Groups Pattern
  • User Principal Comparer (Service Class)
• Assembly Info
  • Check if an Assembly Is 64 Bit
  • Get .NET Type Kind
  • Get Assembly Info (Assembly Path)
  • Get Assembly Info (Assembly)
  • Get Assembly Name
  • Get Assembly Platform
  • Get Assembly Resource List (Assembly)
  • Get Assembly ResourceList (Assembly Path)
  • Get Framework Info
• Color/Image Functions
  • Get Foreground Color
  • Is Valid Color
  • Is Valid Color Name
  • Resize Image
• Data Table Functions
  • Convert Boolean Columns
  • Convert CSV File To DataTable
  • Convert CSV String to DataTable
  • Convert DataTable to CSV String
  • Convert DataTable to Html Page
  • Convert DataTable to Html Table
  • Convert Date Columns
  • Convert Empty Strings To DBNull
  • Log DataTable To CSV File
• Email Functions
  • Is Valid Email Address
  • Send Html Email
• Excel Functions
  • Column Scanning – Return First Empty Cell Row (Top to Bottom)
  • Column Scanning – Return First Not Empty Cell Value (Top to Bottom)
  • Column Scanning – Return Last Not Empty Cell Value (Top to Bottom)
  • Data Import/Export – Convert ListObject to DataTable
  • Data Import/Export – Load Excel Sheet to DataTable
  • Data Import/Export – Read Excel Sheet to DataTable
  • Data Import/Export – Write Datatable to Sheet
  • Row Scanning – Return First Not Empty Cell Value (Left to Right)
  • Row Scanning – Return Last Not Empty Cell Value (Left to Right)
  • Sheet Custom Property – Get Sheet Custom Properties To CSV String
  • Sheet Custom Property – Get Sheet Custom Properties To Datatable
  • Sheet Custom Property – Get Sheet Custom Property
  • Sheet Custom Property – Remove All Custom Properties from a Sheet
  • Sheet Custom Property – Set Sheet Custom Property
  • Sheet Custom Property – Sheet Custom Property Exists
  • Sheet Custom Property – Write Sheet Custom Properties
  • Table Manipulation – Get ListObject
  • Table Manipulation – ListObject First Blank Row
  • Table Manipulation – Lookup List Object Value
  • Table Manipulation – Set ListObject Headers
  • Table Manipulation – Sort Table
  • Utility – Add Comment
  • Utility – Column to Index
  • Utility – Get First Blank Row
  • Utility – Get Row Range Interval
  • Utility – Index to Column
  • Workbook Access – Get First Sheet Name
  • Workbook Access – Is Excel File Opened
  • Workbook Access – Open WorkBook
  • Worksheet Search – Find Text Coordinates
  • Worksheet Search – Get Element Start Row
  • Worksheet Search – Is Sheet Suitable
• LDAP Functions
  • Convert Domain Format
  • Decode User Account Control
  • Format Ldap Date
  • Get All Group Users
  • Get Groups Distinguished Names
  • Query Users
• Logging Functions
  • Open Log
  • Write Log
• Object Utilities Functions
  • Is Method Exists
  • Release Object
  • Resolve Type
• Save/Restore Form Layout
  • Restore Layout
  • Save Layout
• Source Code Retrieval
  • Find C# Source Code
  • Find VB Source Code
• Sql Functions
  • Check Sql Connection
  • Execute Non Query Sql Cmd (Signature 1)
  • Execute Non Query Sql Cmd (Signature 2)
  • Execute Query On DataTable
  • Load Sql Table
  • Read Sql Table Chunk
  • Sql Bulk Write
  • Table Exists
• String Functions
  • CSV/Text Delimiting – DeQuote string
  • CSV/Text Delimiting – Enquote string
  • HTML Rendering – Check if a string is Html
  • HTML Rendering – Convert Tabbed String to Html Page
  • HTML Rendering – Convert Tabbed String to Html Table
  • String Normalization – Convert a string to Proper Case
  • String Normalization – Convert Culture Chars
  • String Normalization – To Fixed Width
  • Text Analysis – Count Uppercase Letters
  • Text Analysis – Detect Encoding and Get String
  • Text Analysis – Get Words Starting With Uppercase
  • Text Formatting – Insert Blank Before Capital Letter
  • Text Splitting – Split In Chunk
  • XML Encoding – EncodeXML
• System and Utilities
  • Convert To Integer
  • Exec Ping
  • Is Debug Runtime
  • Is Host OnLine
• Utility Forms
  • Show File Content
• Web Fuctions
  • URL Exists