This blog post covers a few tips for holding presentations that include some activity in Visual Studio, such as live coding. It explains how to switch VS into presentation mode with a single command and how to store your code snippets in the toolbox. In about 80% of the presentations that I have witnessed so […]
This blog post shows how you can use Sysinternals Process Explorer to examine .NET Processes at runtime without installing any software on the machine: Look at managed call stacks Get performance info for CPU and GPU Check .NET performance counters Unlock Files See what assemblies are loaded and from where Find out the CLR version […]
Many developers heavily underestimate the power of the format string. This post shows a couple of examples that can greatly facilitate a coders daily life. Don’t know what a format string is, look here: https://msdn.microsoft.com/en-us/library/system.string.format(v=vs.110).aspx Another great resource with some more advanced ideas: http://blogs.msdn.com/b/kathykam/archive/2006/03/29/564426.aspx Remember that there are multiple ways how a format string […]
As with writing data to Excel, reading data can be achieved in multiple ways. If you need read and write capabilities, check out .NET PowerTip 2: https://www.12qw.ch/2015/09/net-powertip-2-write-data-to-excel/ However, if you just need to read some data, there is a magnificent library to help you out. Meet LinqToExcel https://github.com/paulyoder/LinqToExcel . How does it work: Add the […]
Every now and then, developers have to write data to excel. There are several approaches: 1. Full fledged Excel Interop: Add the interop assembly to your project, connect to your local excel application, create workbook, sheet, fill data, etc. Example: http://stackoverflow.com/questions/19933135/writing-to-excel-using-c-sharp Drawback 1: You need excel on the client. Drawback 2: The Excel version installed […]
This blog post introduces ILSpy and shows the lesser known feature that allows you to decompile foreign assemblies and directly save them in the Visual Studio Project format (*.csproj). You might be familiar with ILSpy (http://ilspy.net/), the open source successor of the legendary .NET Reflector. It emerged in the time when RedGate acquired .NET […]