Different Encryption Methods in MySQL
Below are examples of three different encryption methods to encrypt data inserted into a MySQL database table. A test table is created where field1 will store data in plain text and field2…
Monitor Number of Emails on Shared Folders
This VBScript was made for David who wanted to know the count of emails received on a daily basis in the Shared Mailboxes.
Example of VBA code running in Outlook 2016 to connect to SQL Express
This VBA example was configured to run in Outlook 2016. It connects to a local SQL Express Database and insert a record. In order for the VBA to connect to the SQL…
Runs an Event in Outlook as Mail is Received in a Specific Folder
This code shows a couple of triggers in Outlook that invokes when email is received. There are two email folders being monitored and custom triggers can be created based on which folder…
Create an Event in Outlook as Mail is Received
This code triggers an event as Outlook receives email in inbox. This scenario opens a popup window with the information regarding the email that came in but that popup window can be…
Connect C# to mySQL Example
This example requires MySQL.Data.MySqlClient and System.Data.SqlClient to insert data into a MySQL database. Originally, I had an error during execution: IO.FileNotFoundException in MySql.Data.dll: Can’t load System.Security.Permissions. To fix the issue. I had…
Example of HashMap (Array Pair Type)
This is an example of how to create a hashmap (Paired Array).
How to Create Multiple Scenes and Switch Between Scenes in JavaFX
This example shows how to create multiple scenes and switch between scenes in JavaFX. In JavaFX, an app can only have one stage but that stage can have 1 or more scenes….
Example of Parsing JSON Array from URL
Example of Parsing JSON from URL where JSON contains an Array (phoneNUmbers). The data is on ID 57 but shown below: { “firstName”: “John”, “lastName”: “Smith”, “age”: 25, “address”: { “streetAddress”: “21…
Example of reading JSON data from a URL, putting information in a String, then Parsing JSON from that string
This example shows how to read a JSON file from a URL using BufferedReader() then place that to a string, then parse that string to extract data by creating a JSONObject.