At first, I used custom built CSV helper class, which simply separates CSV formatted string with a comma and push the data into DataTable. However, this class didn’t handle double quotation qualifier well enough. So, I started searching for a CSV library. One reliable and mostly recommended CSV library was A Fast CSV Reader (aka LumenWorks.Framework.IO) by Sebastien Lorion,… Continue reading CSV Library to use
Author: rocker8942
Javascript to use in 2016
Use AngularJS, React, D3, Polymer and Ionic and throw away backbone, knockout, ember, jQuery.
How to prevent memory leak in WCF
I have one WCF site that I’m managing and it started leaking memory, which ended up consuming up all server memory and stopped working. The change I made between the incident was that I changed from using service reference to using a class called WebServcieClinet that dynamically instantiating the web service connection. The reason why I introduced WebServiceClient… Continue reading How to prevent memory leak in WCF
SQL Server remote access
To make Sql Server to be accessed remotely, check the belows. 1. Use correct server name. The server name is machine name + instance name. e.g. My-PC\SQLExpress The server name shouldn’t start with ‘\\’ 2. Tick Allow remote connection to this server from the tab Connection of Server Property from SQL Server Management Studio. 3. Enable TCP/IP… Continue reading SQL Server remote access
DateTime time zone conversion in .Net / C#
Converting time zone sometimes can be tricky. If we understand a few basic facts around time zone and knows the how to use it, it turns out relatively easy. Basics of Time Zone There are 3 concepts to know clearly about time zones. UTC (Coordinated Universal Time) : Standard time zone. When it comes to the… Continue reading DateTime time zone conversion in .Net / C#