In this post I will show inserting rows in excel file from a c Sharp list using Open XML SDK. Open XML SDK is very useful when you don’t want to or cannot use Microsoft Office InterOP dll. You can download it from below URL http://www.microsoft.com/download/en/details.aspx?id=5124 Once you download and run the MSI follow theContinueContinue reading “Inserting in Excel file from C# collection using Open XML SDK 2.0”
Category Archives: Miscellaneous
.NET 4 for Enterprise Architects and Developers by Sudhanshu Hate
Book at Amazon http://www.amazon.ca/Net-4-Enterprise-Architects-Developers/dp/1439862931 A book by Infosys Press and Foreword by Kris Gopalakrishnan Are you a Developer? Are you an Architect? Then this book is for you This book is written by industry veteran Sudhanshu Hate and Suchi Paharia. Both authors have articulated their real time experience in simple words suited to bothContinueContinue reading “.NET 4 for Enterprise Architects and Developers by Sudhanshu Hate”
ROSLYN: Complier as Service ?
As a developer I see [rather forced to see] Compiler as a black box. It takes certain input and gives respective output. If I remember my college days classical definition of compiler was, “Compiler is system software which converts high level language in machine instructions line by line “ Compilation process follows certain steps, AndContinueContinue reading “ROSLYN: Complier as Service ?”
Step by step installation guide to install Windows 8 Developer Preview on Virtual Box
In Microsoft Build conference all we got an opporunity to have a first look on most awaited Windows 8 . Microsoft revealed Developer Preview of Windows 8 on 13th september 2011. Windows 8 is adhering Metro Design Gudielines. Without going much into deep technical discussions on features of Windows 8 , in this post IContinueContinue reading “Step by step installation guide to install Windows 8 Developer Preview on Virtual Box”
Learn ADO.Net Entity Framework: Performing basic CRUD Operation
In this post I will walkthrough you on performing basic CRUD operation using ADO.Net Entity framework. Database design I am going to use School Database. You can find School database script here . To be precise, I am going perform CRUD operation on only one table Person. Schema of Person table is as below. IContinueContinue reading “Learn ADO.Net Entity Framework: Performing basic CRUD Operation”
Code snippet for Fetching Data from Excel using ADO.Net
Today one of my team members asked me a very simple question though very important question, “How could we fetch Excel Records using ADO.Net? Could you give me code snippet of same? “ I replied him; it is pretty possible using oledDbConnection I told him to add below reference I gave him below straight forwardContinueContinue reading “Code snippet for Fetching Data from Excel using ADO.Net”
Performance of Non-Zero lower bound Single Dimensional Array
Today while returning from office, I had a very good conversation with one of mine friend Sunny Raheja. We were discussing here and there and suddenly he asked to me “Hey DJ, is there any difference in performance of single dimensional array if I don’t give lower bound as 0 or if lower bound isContinueContinue reading “Performance of Non-Zero lower bound Single Dimensional Array”
System.ServiceModel.Web is missing in Visual Studio 2010 Console Application ?
I was creating a managed host application for WCF Service. Although it was just to write few lines of codes in console application, it took 1 hrs. for me to figure out a strange problem. I followed steps as below, 1. Created a console application 2. I had to add reference of System.ServiceModel and System.ServiceModel.WebContinueContinue reading “System.ServiceModel.Web is missing in Visual Studio 2010 Console Application ?”
30 day free trial for SQL Azure/Windows Azure without Credit Card
I am excited to share with you people that, Now you can see your code is running as Web/Worker role in Azure hosted service, your application is performing CRUD operation on database resides SQL Azure and many other more stuff and that also without using your valuable CREDIT CARD Now you can get free AzureContinueContinue reading “30 day free trial for SQL Azure/Windows Azure without Credit Card”
MVP 2nd time in Row: A Thanks Note and statistics
Second time in row Microsoft says, I am their “MOST VALUABLE PROFESSIONAL”. All credit goes to community and readers of my blog and articles. Now I am MVP on Connected System Development since 1st April 2010. A Thanks note … There are many people who have helped me in this way or other. I thankContinueContinue reading “MVP 2nd time in Row: A Thanks Note and statistics”
Dhananjay Kumar 