Nitesh Kejriwal

22/06/2016 by Nitesh

Solution: Error with Entity Framework – Incorrect syntax near ‘OFFSET’

Friends, This post explains the solution to an issue that occurs with Entity Framework used against SQL Server 2008 database. The error is – An error occurred while executing the command definition. See the inner exception for details. —> System.Data.SqlClient.SqlException: Incorrect syntax near ‘OFFSET’. The error occurs if you are using Entity Framework EDMX file…

12/05/2016 by Nitesh

How To Install Spire.Office On your Machine

In this post we will see how to install Spire.Office software on your machine. Spire.Office for .NET is a combination of Enterprise-Level Office .NET components that includes Spire.Doc, Spire XLS, Spire.Spreadsheet, Spire.Presentation, Spire.PDF, Spire.DataExport, Spire.PDFViewer, Spire.DocViewer and Spire.BarCode. This product enables developers to open, create, modify, convert, print, View Office and PDF documents without the…

09/05/2016 by Nitesh

Disallow Search Engine Crawlers to Index Websites

When working for any client, we all showcase the work on a development server that is available on a public domain and easily accessible to client. With Search Engines crawling the internet at a huge speed, it’s likely that Search Engine Crawler aka Robots like Google, Bing, yahoo will index the development webpages that we…

02/05/2016 by Nitesh

Managing Word Documents With Spire.Doc Library Functions

Around a year ago, I wrote a post on How To Create a Word Document using Spire.Doc library. A few days back, one of my readers emailed me asking to help with some other functions in the library. Hence, this post is here where I explain various Spire.Doc Library Functions that eases the life of…

22/04/2016 by Nitesh

Enable IIS Server to Serve .mp4 files through web.config file

Now, most of the websites are being developed using HTML5 and using videos on the background is an easy job using the video tag.. It is advised to serve video files using a CDN, however, in case you want to host videos from your own server, you need to configure IIS to server .mp4 files….