You have a class and you need to save values to of the class to an xml file to be consumed later on Save your class values to This is the template content To read the content of the xml back to your class
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
Now that you have your Access Token – in case you missed it, here is the link to how to get it OAuth2: Get an Access Token – C#, you can now pass your authorization token to interact with your API. Make sure to add a header to your request with your authorization token The … More OAuth2 – Pass Access Token – C#
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
Problem I have a Microsoft Access database application. When updating a record from the screen, users kept getting the error: This recordset is not updateable The form datasource is a query with two tables Solution This query was not updatable, here is a list of reasons why a query would not be updatable By Allen … More This Recordset is not Updateable
On the previous post, we moved validation functionality to the Scraping object. The resulting function was this: There is still too much going on. The next step is to extract a method to process the items on the list, I called this method ScrapeStockData The resulting function would be, you can get an idea of … More Refactoring IV – Finally There
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?
On my previous post, I started refactoring a function that reads stock and dates, checks the data against Yahoo Finance and returns some data. In this function, I take the Stock Ticker and the data and parse the URL to be evaluated by our web scrapper object. Now, this code can be taken out of … More Refactoring II- Encapsulating
Refactoring is an important process to crafting readable and maintainable code. Functions should follow the single responsibility principle – a function should do one thing and one thing only and should have few lines of code. Like with everything, you should apply this with measure and wisdom. I was asked to write a function that … More Refactoring I -Convert Linq Anonymous Types to List
The obligatory reflection on what have we accomplished in 2015 … always a sticky question. But if keep it to my book, training and research, it does not look that bad, I managed to keep the momentum going. Software Development Cracking the coding Interview – Gayle Laakman This is a great book with brain teasers and … More Books every software developer should read in 2016 – if you have not done so
Serendipituos Code 