Posted by Anuraj on Wednesday, September 17, 2014 Reading time :1 minute
.Net .Net 4.0 ASP.Net MVC Windows Forms
In current project, I had to use some 3rd party APIs, which is exposed via COM Interop. I found some VB.Net code to consume, but I couldn’t find in C# implementation for the same. Here is the code snippet which is equivalent VB.Net CreateObject method.
Posted by Anuraj on Tuesday, September 16, 2014 Reading time :1 minute
.Net .Net 3.0 / 3.5 .Net 4.0 ASP.Net MVC Unit Testing
Recently I had to implement XML Serialization in one of my class, it was deriving from base class, which has a dictionary property and XML Serialization was failing due to that. And here is the code snippet which will help you to serialize a .Net dictionary. It is implemented using IXmlSerializable interface
Posted by Anuraj on Tuesday, September 9, 2014 Reading time :1 minute
.Net .Net 4.0 ASP.Net Windows Forms
In one of my project, I am using OpenXML SDK for opening Excel files. Recently I got an issue like SpreadsheetDocument.Open() method was throwing an IOException, if the Excel file is opened by MS Excel, even if I set the isEditable parameter false.
Posted by Anuraj on Monday, August 25, 2014 Reading time :1 minute
.Net .Net 4.0 ASP.Net CodeProject Windows Forms
Recently I had to work on FxCop, for static code analysis. For those who don’t know what is FxCop, check this link. But one issue I faced was, the report can be saved / exported from FxCop is only in XML format. I searched for tool which help me to convert this XML to any other formats like HTML or doc, but I couldn’t find anything. :( Then I found FxCop comes with some XSL file, which help you to convert the FxCop generated XML to HTML. You can find these XSL files under - “C:\Program Files (x86)\Microsoft Fxcop 10.0\Xml” folder. And here is the code which helps to generate HTML using XML and XSLT.
Posted by Anuraj on Wednesday, August 6, 2014 Reading time :1 minute
.Net Visual Studio
If you are using StyleCop for maintaining C# coding standards and conventions, we used to do Remove and Sort namespaces feature from Visual Studio. The Organize Usings options in the Visual Studio integrated development environment (IDE) provide an easy way to sort and remove using and extern declarations without changing the behavior of the source code. Over time, source files may become bloated and difficult to read because of unnecessary and unorganized using directives. The Organize Usings options compact source code by removing unused using directives and improves readability by sorting them. I am huge fan of keyboard shortcuts, but by default VS did come with a keyboard shortcut for this feature. This post is about adding a keyboard shortcut to Remove and Sort.
Posted by Anuraj on Tuesday, July 15, 2014 Reading time :1 minute
.Net .Net 3.0 / 3.5 .Net 4.0 ASP.Net ASP.Net MVC Visual Studio
This post is about creating custom configuration sections in .Net. If you search for this topic in internet, you will find lot of code snippets and blog posts(Here is the MSDN link). Unlike that, this post is about a nice tool, .NET Configuration Code Generator which will help you to generate code for you to create custom configuration section. It is a free, open source tool licensed under Apache License 2.0 (Apache).
Posted by Anuraj on Friday, July 11, 2014 Reading time :1 minute
.Net .Net 3.0 / 3.5 .Net 4.0 ASP.Net ASP.Net MVC
In the current project we were using OpenXML extensively for reading Excel files. Here is the code snippet, which will help you to read / convert Excel files to DataTable.