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.
Posted by Anuraj on Wednesday, July 2, 2014 Reading time :1 minute
.Net ASP.Net WF Windows Forms
You can create arguments to workflow and can pass the values from outside. For creating arguments, you can use the Arguments Tab in the WorkFlow designer.
Posted by Anuraj on Tuesday, July 1, 2014 Reading time :1 minute
.Net .Net 4.0 ASP.Net MVC WF Windows Forms WPF
This is post is about loading and running Workflow foundation (WF) XAML files. It is a powerful technique which can be used to change Workflows on the fly, without re-compiling the application. All this functionalities can be achieved via single line of code.