Limiting rows in Sql Server

One problem I have always faced with Sql Server (more so, after I used MySql, and saw that MySql allows this) is to find a way to limit the number of rows being fetched in a SELECT query.Although Sql Server provides a ROWCOUNT statement & TOP clause for the SELECT...

Insert Html in MS Word documents

One of my clients recently asked me to generate dynamic reports from content in the database, where the content contained Html entered by him through a WYSIWYG editor from a web application. I already had a library, that allowed considerable flexibility in generating...

Token Replacement in Office documents

A common situation is to prepare invoices, etc. from information in a database. Clients usually have extremely customized invoice formats, but the data to be filled in is basically the same. This article and its related code present a new (I have searched, but could...

Chit Chat

Projects