How to Pivot a DataTable in .NET

So I would have thought this problem would have already been solved by the Internets at large. As it turns out, I couldn’t find a very simp...

Remove Items in For Loop

As a general rule, you should not modify a collection that your are looping over, only the items inside of that collection. The problem wit...

SQL Like 'In' Function For .NET

SQL has a wonderful terse and natural syntax for checking if an item is inside of a collection by using the IN keyword . Which can be expr...

Calculating Age From DOB

I couldn’t believe there was no native way in .NET to do something alarmingly simple like calculate someone’s age from their date of birth. ...

Extending XmlReader Class: IsEndElement()

Introduction You may find, as I did, the lack of symmetry in the XmlReader Class quite odd. If we look at the NodeType property, which ex...

Handle Text Change In Selected Index Changed Event

The Problem You may have noticed that .NET won’t let you change the Text value of a ComboBox during the SelectedIndexChanged event. Thi...

Firing The DataGridView CellValueChanged Event Immediately

Intro Let’s say you have a list of things displayed in a DataGridView and you want a user to be able to select among them on a DataGridVie...