Some time ago I started reading this book – Pro WPF 4.5 in C#. As far as it was given to me in order to write some reviews on it, today I have decided to write something about chapter 11. …
WPF – Triggers and Styles – Pro WPF 4.5 in C# book Read more »
After writing some articles for linear regression here and here, I have decided to get a little deeper into the Excel Data Analysis Tool. Pretty much, what it does is providing a lot of statistical information for a set of data. …
Excel Data Analysis Tool – Descriptive Statistics – Simple Explanation Read more »
Some time ago I wrote an article explaining linear regression. If you have no understanding about the method, I recommend that you read it. Now I am going to build upon this article, using the same example as from it and …
VBA is a Microsoft script language, mostly used with Excel. And there are reasons for this – mainly, the skills needed to use VBA are easily grasp by those, using Excel on a daily basis. The second reason is that …
After showing some tricks for VBA MS Access, I have decided to go back to the field again to find a way to export a table in HTML format. Actually, VBA and Microsoft have taken care of the issue (no …
VBA – Access – Export a table in HTML and other tricks Read more »
In this article, I present 5 useful Excel worksheet based tricks: Set a date and time for the beginning of the latest update on the sheet; Color the changed cells in red; Change the sheet name based on the value …
After the first article for custom excel formulas with VBA (here) I have decided to enlarge my knowledge in the area with some additional examples. Here I present three different custom formulas for excel. 1. The first one is an …
After writing some articles about XAML, I have decided to go a little deeper in XML. Actually going deeper into XML is quite a challenge, due to the fact that XML is considered a meta-language and thus it is quite …
In this article I present a code from the book “Pro WPF 4.5. in C#“, which I consider useful and interesting. This example has impressed me with its structure – it simply gives good practises for creation of 23 different …
In the current article I proudly present a simple application, which creates a simple Excel file from XAML. In the example I present I am using Excel 2010 as this is my current version. In order to be able to …
In this article I present a code from the book “Pro WPF 4.5. in C#“, which I consider useful and interesting. The application concerns building a simple program where you may ask a yes-no question and get a random answer. …
In the last 2 weeks I have read the first 6 chapters of the book “Pro WPF 4.5 in C#” from Matthew MacDonald. Click on the book to go to its site in Apress.com The experience, reading these chapters was …
Book Review – Pro WPF 4.5 in C# – A detailed introduction into WPF Read more »
As a beginner in WPF, I am trying to become really better in the subject by changing existing codes and adding some new features in it. This code simply adds a voice control feature of the snake WPF game from …
With the current article I will show you how to create a simple application, presenting yourself. The most of the application is created in XAML. Roughly, it looks like this: The text is from here. This application is really …
In this article I present the combination of a drop-down menu and audio in a WPF application. Simply, the application’s logic is the following – you select one media file from a drop-down list and then you play it. The …
In the current article I will show how to bind elements in a small application. Two types of binding are presented – the so called (by me) runtime binding and command binding. The difference is that the runtime binding is …
C# – WPF – Runtime and Command Binding of Labels Read more »
With the current post I will present a simple application, which changes styles of buttons within WPF, based on our selection. In order to change the styles of the design, we define both styles as variables in the XAML code. …
C# – WPF – Changing styles in WPF (Setter Property usage / Style declaration in XAML) Read more »
In this article I present a simple application with two buttons and two radio buttons. The idea is the following – each one of the two click buttons run a WAV file from the Windows ones. The radio buttons are …
C# – WPF – Application with two click buttons and two radio buttons Read more »
With this article I will show how to create a simple browser application with WPF (Windows Presentation Foundation). The browser is really just a simple one, with just four options: Back button, Forward button, History Chooser and Go Button. Before …
Sometimes you should create more than one constructor for a class. This is a useful practice, if you need to generate objects of the same type which need to be initiated with different fields. In the current example, we generate …
C# – Example of Class with Two Constructors – Video Read more »
I know, that the title of the article seems a little tautological, but this is the truth – this is a data analysis book, written with passion. It is real keeper for Data Analysts, who are working all day long with …
You know, a lot of people nowadays should simply take loans. There are plenty of load calculators available online, but it is always better whey one can calculate this thing by himself. Or with Excel, which is pretty much the …
In this article I present a good possibility to customize your Active Window from Excel itself and not from the ribbon. By inserting some form controls, we receive a decent-looking customization dashboard like the one below: The idea of the …
Let’s imagine you are a supply chain manager of a company. You use 10 warehouses. Each warehouse has a number of pallets, it can accommodate. One day you decide to check what will happen if you simply reduce the numbers …
VBA – Quick & Impressive Recalculation of Total Sum – Video Read more »
VBA is not a perfect language – actually it is not exactly a language, but if you have worked 4+ years in Excel and then you have discovered it, it is probably like miracle for you! (especially if you have …
Visual Studio F5 Run F10 Step Over. Does not step into the current method and goes to the next statement. F11 Step Into. Standard Step-by-step slow debugging. Ctrl + F5 Runs the project without debugging Shift + F11 Step Out. …
Everyone knows that in the English language there are more than 100K words. As in any other language on Earth. The point is that we DO NOT use all of them in our every day life. We simply use about …
C# – Count Words in a Text – ABC Analysis for Linguists Read more »
It is probably interesting to many junior programmers to create different functions and to execute them, based on the code. In short something like: if (Z>Y) Then Function A Else Function B However, the things become more interesting, when we …
This is the second C# book, to which I am writing a review. So far I have read the first 100 pages of the book and I have obtained an idea about it. It is definitely not for beginners with less …
Book Review – C# in Depth, 3rd Edition – Free Code Read more »
With the current console application we display the contents of a given folder. It is a little useless by itself, but the code has one good advantage – it shows perfect application of DirectoryInfo and some properties as .FullName & …
C# – Display Folder Contents with Console Application – Directory Info Usage Read more »