If any of you readers are like me, you are sitting here looking at the TreeView and wondering how you are going to maintain the expansion state of each node. I tested out several possible methods for getting the expansion states and setting them and finally settled on a method which has worked pretty well for me. (I am using .NET framework...

A while back I wrote about the way I had come up with to export data to Excel. This worked for me for a little while, but I am always looking for ways to speed up the execution of my code. When I started working with framework 4.0 and the accompanying Excel interop COM library (v14 i think it is) the execution of saving some 50 columns and 300...

If you are like me, you have to use the Reportviewer object quite often in your .NET development. If that is the case, you have also found that there isn't a whole lot of help out there with reference to said reports.

The other day, a customer asked me to write a small application for him which would compile a bunch of information in a...

I had a customer come to me the other day and ask if I could put together some data for him. It was only 18 months worth of shipped products so I naturally said "Sure! That won't be too hard. What database is it in?" He replied, "Well, we don't have the data stored in a database...what we have is all of the pallets of...

Recently, I had a customer request to send a bunch of data to a single Excel file. Normally, this would not be an issue if I were using VB6 or VBA, but I'm not. I am a VB.NET developer (I have finally overcome my phobia of actually calling myself a "developer"). I work with .NET FW 3.5 in VS2010. There just isn't a lot of...