In competitive programming, following the ICPC rules, one of the best strategies is to scan the problems given to your team and to start with the easiest ones. The easiest ones are not always the first problems and sometimes these …
Competitive Programming – Bus Stops Problem – Video Read more →
Writing code in the local language is actually taught by about 100% of the German VBA books, which I have read. Which is “kind of ok”, if the VBA code only works on German computers. However, if this is not …
VBA – How to avoid naming variables with non-latin alphabet characters (special letters) Read more →
Exactly 1 month and 5 days after the first video tutorial for the ASP.NET MVC with EF Core series, the last 10th video tutorial, following the Microsoft ones, is published. It is about advanced scenarios, and I have mentioned the …
C# – Learn about advanced scenarios – ASP.NET MVC with EF Core Read more →
Coloring the border of an Excel cell is a trivial task. The LineColor feature in Excel is easy to use out of the box: However, whenever half of the cell needs to be colored, the trick is a bit more tough …
VBA – Color Only Half of the Border of an Excel Cell Read more →
Slowly, after handling concurrency in the ASP.NET MVC application, we are approaching the end of the video tutorial series. Implementing inheritance is the prelast one and it is actually pretty an important one as well. In the video, the following …
C# – Implementing Inheritance – ASP.NET MVC with EF Core Read more →
Adam Freeman has written the 7th edition of the Pro ASP.NET Core MVC 2 book. And there should really be a reason to issue the book so many times! The book itself gives my favourite way of presenting software – …
After updating the related data in the ASP.NET tutorial, it is time for the next step – handling concurrency in the MVC Application. These are the points, followed by the video: Learn about concurrency conflicts Add a tracking property Create …
C# – Handle concurrency – ASP.NET MVC with EF Core Read more →
After reading complex the data, it is time to be able to update it. This video fills the following points from the ASP.NET MVC tutorial: Customize Courses pages Add Instructors Edit page Add courses to Edit page Update Delete page …
C# – Update related data – ASP.NET MVC with EF Core Read more →
After creating a complex data model, now it is time to display the data, following the tutorial. The task is actually a challenging one, as far as the data display is in a way partial – in the “Instructors” view, …
C# – Read related data – ASP.NET MVC with EF Core – Video Read more →
Creating a complex data model with the previous data model in ASP.NET is actually a challenging task. The model in general looks like this: It is not “extremely” complex, but it is something bigger than the previous 3 tables that …
C# – Create a complex data model – ASP.NET MVC with EF Core – Video Read more →
Migrations in C# are quite well facilitated by the EntityFramework. In general, when an application with databse is created, initially the database model is taken from the model classes. When these models classes change, then they get out of sync …
C# – Using Migrations – ASP.NET MVC with EF Core – Video Read more →
Sorting, filtering, paging and summary of an app are quite important features. In this video, which is a continuation of the Microsoft tutorial, I present step-by-step how to do each one of these. It is quite a large video, but …
C# – Add sorting, filtering, and paging – ASP.NET MVC – Video Read more →
This is the second video of the Microsoft tutorials, for ASP.NET MVC with Entity Framework Core: Continuing the previous video, in this one the following tasks are carried out: Customize the Details page Update the Create page Update the Edit …
C# – Implement CRUD Functionality – ASP.NET MVC with EF Core – Video Read more →
Lately, I have started with creating video tutorials for ASP.NET. Thus, today it is time to deep dive in the ASP.NET once again, following the Microsoft tutorial for ASP.NET MVC Web App from here. In the video below, the following …
C# – Get started with EF Core in an ASP.NET MVC Web App – Video Read more →
Creating a web application with ASP.NET could look as a hard task. Still, with the pre-built MVC models from Visual Studio, the task is a bit easier. This is how the application looks like, with 2 search buttons and fully …
C# – Create a web app with ASP.NET Core MVC – Video Read more →
Web API with Visual Studio 2019 is quite a bolierplate task – it is doable in less than 45 minutes, following the Microsoft.com tutorial: The video tutorial is here: The TodoController , implementing the CRUD actions looks like this: using System.Collections.Generic; …
The title somehow looks like random words, picked from a hat at one of those college games we are not supposed to talk about. Anyway, at the second reading it hopefully becomes a bit clearer. And it is simply the …
After writing about the longest palindromic substring, now it is time to see the longest palindromic subsequence. What is the difference? Pretty much, if we take the word abracadabra: the longest substring is ada in abracadabra the longest subsequence is …
VBA – Longest Palindromic Subsequence Algorithm with Excel – GIF Read more →
After the first video for MVC here, I have decided to make a next part, in which I save the entries to a database and display them: Sounds like a tiny update. However, it …
ASP – Data Entry MVC Application with Database – Video Read more →
The longest palindromic substring algorithm exists since 1975. It is different (and easier) than the longest palindromic subsequence. The idea of the substring is to return “anana”, if “bananazorro” is given. This is achieved with a 2 dimensional boolean array matrix and …
VBA – Longest Palindromic Substring Algorithm with Excel – GIF Read more →
Good software comes with tests. Fortunately, Visual Studio 2019 provides quite nice ways to test the software you are creating. One of these is xUnit – xunit.net. Thus, I have decided to make a video, showing how to implement xUnit …
C# – xUnit Test Implementation in Fibonacci Calculation – Video Read more →
I have started reading the 2nd edition of the Pro ASP.NET Core MVC book and after reading the first couple of chapters, I have decided to make a video of the application in the second chapter. The code is about …
Inserting an image to Excel with VBA is actually one line: ThisWorkbook.Worksheets(1).Pictures.Insert (“C:\Users\myPic.png”) The interesting part happens, when it should be correctly positioned. In order to position it the way we want, we need to give 3 parameters – the …
VBA – Insert an image/picture in Excel and position it correctly Read more →
The idea of the article is to make an updateable combobox, which takes all the keys of column A and writes them to the ComboBox. Then, upon selection of the corresponding values in the combobox, it provides the corresponding values …
VBA – Put a Collection inside a Scripting Dicitonary OR Make an Updateable ComboBox Read more →
The idea of the article is to show how to add, edit and remove specific entries of the ListBox in Excel through VBA: ListBox is a control, which is available through Developer>Insert>ActiveX>ListBox in Excel: Once you add it, it has …
VBA – ListBox in Excel – Adding, Editing and Removing Data Read more →
Reversing words in a sentence with VBA in Excel is quite easy, using the built-in StrReverse function. StrReverse takes a string and reverses it. Thus, “VitoshAcademy.com” becomes “moc.ymedacAhsotiV”: The idea of reversing the order of the words in a sentence …
Excel’s ranges and cells are both complicated and very simple. They are simple, because everyone has an idea what is a range and what is a cell, and they are complicated, because these are both: Properties of the worksheet object …
VBA – Cells and Ranges in Excel (A bit more than the standard story) Read more →
Long time ago, an astronomer called Benford was taking a look at logarithm books, noticing that the earlier pages (starting with 1) are pretty much more worn out than the later ones. He thought about the result, and managed to …
VBA has a dictionary structure. Dictionary is an object, and it can be referenced either with early binding or with a late binding, referring to Microsoft Scripting Runtime: What is a dictionary? This is the Microsoft definition of the VBA …
Python has a built-in GUI package, which allows easy building of forms like this: The package used in this example is tkinter. The form above takes the value, entered in the entry field, squares it and displays it back in …