Remove Multiple Blank Rows in Excel


Overview Sometimes I run into situations where I have an Excel file with a lot of blank rows that I want to remove. A common scenario for me is an Internet Information Services (IIS) log file. These don't contain blank lines, but they have a header that repeats throughout the file, each day. Since I … Continue reading Remove Multiple Blank Rows in Excel

Advertisements

Auto-Build Windows Forms Menu From Name Space


Overview Spanning the decade plus I've been a developer and before that as a systems administrator, I've written a seemingly endless supply of small programs to help me do different little jobs. This has ranged from little utilities I designed to iterate folders and rename, sort, etc. files (too inefficient to do by hand) to some pretty decent code generators. The problem is … Continue reading Auto-Build Windows Forms Menu From Name Space

Accessing Session State in an HttpModule in MVC


Overview HttpModules can be very useful for a lot of tasks. They are especially handy when trying to accomplish logging within a .NET web application. However, they also come with quite a few hurtles to overcome. In this article we'll discuss some of those challenges as well as ways to get around them. In the … Continue reading Accessing Session State in an HttpModule in MVC

XML Comment on ‘X’ Has CRef Attribute That Could Not Be Resolved


The generic collections in the System.Collections.Generic namespace get the "generic" moniker from their ability to mold themselves to fit the type you're working with. Within the definition of the generic collections this generic type is generally specified with a "". Well, the XML comment system also needs a type specifier to match up with the generic object's definition. In XML comments we can't use the less-than () characters so we instead use curly braces ({ and }). If you update all of the XML references that are throwing the error described above to have "{T}" at the end, the XML comment system will recognize it and resolve the error. If you have a Dictionary or other generic type, simply include the generic type characters appropriate to that definition. For instance the Dictionary object has a key and value so I simply put "{K,V}" after its definition.

High DPI Compatibility Fix


Overview With today's computers having high DPI/PPI (Dots-per-Inch/Pixels-per-Inch) screens, you can start experiencing some problems with the way certain pieces of software render things like buttons, dialog boxes, etc. Here is an example of this in CadSoft Eagle. Although the menu appears normal (i.e. File, Edit, etc.), the toolbar icons are practically microscopic. There can … Continue reading High DPI Compatibility Fix

Use Assembly Title, Description, Company, Copyright, Version in C#


When you edit the properties of a project in Visual Studio, you can enter a Title, Description, Company, Copyright and Version in the Assembly Information section. The question becomes, how do you use these in a project so that you have a single source of information? In this article I'll walk you through the steps used to access the assembly information so you can easily use it throughout your application.

C# WMI Tutorial


This tutorial will provide a step-by-step process to follow in order to use WMI. It will provide information about the tools you need, how to use them and finally how to code to get information from WMI.