In this blog entry we will take a look at C# Properties. Properties in C# are used as fields. Their main purpose is to isolate the actual data by allowing the developer to perform some validation prior the client access the guarded member variable. Properties are meant to be simple and efficient. In Object Oriented … Continue reading C# Parameterless Properties – (Part 1)
Magento SQL Logging – (Part II)
In the last article we saw the different ways how one can analyse the SQL Queries running under the Magento’s hood. These are listed here again: To see all queries issued to the database Modify the core Magento code that deals with the database query generation Enable Magento Pdo MySql debugging Switch on MySQL logging … Continue reading Magento SQL Logging – (Part II)
Magento SQL Logging – (Part I)
As with any e-commerce solution Magento stores nearly all the data of the online store in a database. To simplify the communication between code and the database Magento provides a number of abstraction functions. The use of abstraction to communicate with the database leads to the question of what queries are being issued to the … Continue reading Magento SQL Logging – (Part I)
Automatically mark the current week in an Excel Chart
Last time we discussed how to highlight a row in Microsoft Excel automatically. This can be accessed here. Today we will discuss how to highlight a particular entry in a Microsoft Excel chart. The final result is shown in Figure 1. To demonstrate how the above is achieved, we will use the following data: Step … Continue reading Automatically mark the current week in an Excel Chart
Highlight a row in Excel based on a cell value
In this blog entry we take a look how to highlight a row in a Microsoft Excel table based on a cell value. First we take a look at the steps required and then we take an example to see it in practice. We will use the “Conditional Formatting” feature of Microsoft Excel. Steps to … Continue reading Highlight a row in Excel based on a cell value