Excel has a very cool feature where you can declare that a range of cells is a table.  It is a feature that allows you to use Excel very much like a database.  You can add new rows as necessary, sort the table by columns, do some simple filtering, calculate the sum of columns, and more.&... [More]

 

I'll be on and off line for the next few days, so there may not be a new Linq Exchange post until Jan 2. Have a Merry Holiday (please substitute the appropriate holiday you celebrate, here), and Happy New Year.

 

There are times when it is useful to know the line number of a node in an XML file. This information can be a helpful to users, particularly if you want to report an error. It can also be convenient to search for a node by line number, but that can, of course, be a very risky endeavor, as docu... [More]

 

Many times we need to collect a number of results depending upon certain conditions. For that we need to create some sort of collection object, inserting the output to that collection and then returning that collection. But it can be very cumbersome to do that. A rather simple way to do that is t... [More]

 

Since the creation of the .Net Framework, Microsoft has kept the concept of “Type Safe” at the forefront of their design goals.  When 1.1 shipped, the framework had a “generic” collection type called an ArrayList that seemed to break this goal.  Microsoft quick... [More]