Read Excel as DataTable using OpenXML and C#

Posted by Anuraj on Friday, July 11, 2014

.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.

How to pass parameters to Work Flow

Posted by Anuraj on Wednesday, July 2, 2014

.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.

How to load WF workflows dynamically

Posted by Anuraj on Tuesday, July 1, 2014

.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.

Share on facebook - chrome extension

Posted by Anuraj on Wednesday, June 25, 2014

CodeProject HTML5 Javascript

Long back I wrote a post about how to create a chrome extension. This post is about creating an extension which will help you to share current page URL on facebook. You can follow the same steps in the previous post except few changes in the background.js file. And facebook uses a URL like this to accept URL -[URL to share].

Returning Multiple Files from MVC Action

Posted by Anuraj on Tuesday, June 24, 2014

.Net ASP.Net ASP.Net MVC CodeProject

Today I faced an issue with ASP.Net MVC, I have to download multiple files as a compressed (zip) file. Initially I thought of using third party component like DotNetZip. Later I used ZipArchive class, which comes with .Net Framework 4.5.

Generate your database entities using T4 templates

Posted by Anuraj on Sunday, June 15, 2014

.Net .Net 4.0 ASP.Net ASP.Net MVC EF Code First Entity Framework SQL Server WPF

Long back I wrote some post about code generation using T4 templates. This post is about generating database entities using T4 templates. This code is pretty straight forward, you are reading the app.config to get the connection string, connecting to db server using Sql Server SMO objects, enumerating tables and columns.

How to get text from Masked Text Box without the masked format

Posted by Anuraj on Monday, June 2, 2014

.Net .Net 3.0 / 3.5 .Net 4.0 Windows Forms

Today I saw some SO question asked about how to get values from Masked Textbox without the masked format. For those who don’t know what is masked textbox - Uses a mask to distinguish between proper and improper user input.

Copyright © 2017 - Anuraj P. Blog content licensed under the Creative Commons CC BY 2.5 | Unless otherwise stated or granted, code samples licensed under the MIT license. This is a personal blog. The opinions expressed here represent my own and not those of my employer. Hosted with ❤ by GitHub