Problem I have an application that generates financial reports in excel. After installing Office 2013, if a user opens excel while the application is running, the application returns a error: System.Runtime.InteropServices.COMException with HRESULT: 0x800AC472 which interrupts the data from being written to the spreadsheet. After some research according to Microsoft this was done by design, the … More Writing Data From .Net to Excel Interrupted by User Opening Excel Window
Date time – how to initialize a date Concatenate string list into comma separated string Initialize a string list Save text to a file What was the last thing I created in that database? Open the database using Microsoft SQL Server Management Studio, create a query for the database and a You can filter by … More Handy C#, VB.Net & SQL Code Snippets
On the previous post I moved URL parsing code by extending the StockData class and creating a property called Url, now we are left with this code, but if you look at the highlighted code, there are way too many things happening here!. First you see negotiations between StockData and TickerData, validations. This functionality needs to be moved … More Refactoring III -Why is this here?
The Problem You have a data table and you need to group and sum records dynamically. Solution I needed to group information by a field and the sum the values on a different field; For example, I want to group employees by department and then sum their salary. Below is the linq code to this: … More Sum and Group Data Table Records Using Linq