Posts
All the articles I've posted.
-
ASP.NET URL rewrites using .htaccess-like syntax
Having a PHP background, I've been using .htaccess mod_rewrite in Apache for ages. ASP.NET allows rewriting too, but using a different syntax than mod_rewrite. Using the attached library, you can now use mod_rewrite syntax to perform rewrites on your ASP.NET application. Here's how... First of all, you need to download the attached library. Reference it from your web project, and register it as a module in Web.config, preferrably as the first one: [code:xml] <httpModules> <add name="UrlRewriter" type="MaartenBalliauw.UrlRewriter.Rewriter"/> <!-- Other modules can be put here... --> </httpModules> [/code] Second, create a file UrlRewriter.xml in the root of your web project, and add rewrite conditions in there: [code:xml]
-
Enlisting an ADO.NET command in an NHibernate transaction
For everyone who has read my article on NHibernate, here's a story for you... When building an application, everyone comes to a point where one needs to batch-update records in a database table, based on one or more criteria. Let's say, for example, there's a table "User" containing an activation date. And you want to remove all users that have activated in 1999. In a regular database environment, or when using ADO coding, one would write a DbCommand "DELETE FROM User WHERE activationdate < '2000-01-01'".
-
Commandline FTP folder download
A quick annoyed post... I just spent two hours searching the Internet for a means on how to recursively download a complete FTP folder, command-line, and in a simple way. Oh yeah, and preferably freeware. The solutions I found were not what I expected: a $50 software product providing a GUI (I said command-line! [:@]), a bloated scheduler thingy that does download in the background (I said simple! [8o|]), to batch-files relying on Windows built-in ftp.exe and a gigantic list of all files that need to be downloaded.
-
My blog has just moved...
Just finished painting, unpacked some boxes, and here we are: a new home! The people from Eurobesthosting.com (shameless commercial plug in my blog) provided me my own ASP.NET server, which is now serving this page/RSS feed to you! A new home also means new URL's... I did my best forwarding all old URL's to this new page, but I won't keep the forwarding for the next century... The only noteworthy thing for you as a RSS reader, is the RSS feed URL, which has changed to: /rss.aspx. If you placed a link to my blog on your website, please change that link to /.
-
Disclaimer
The information on this website represents my personal opinion. My opinion may differ with other people's opinion and my employer's opinion. This website is by no means related to other people nor my employer. Texts, lay-out, images, script and other items on this site are protected by copyright. Copies, adaptations, translations, versions, modifications of whole or of a part of this site, in any form or manner, are prohibited, unless preceding written authorisation has been granted by the owner of this site. Each violation can lead to civil rights or criminal prosecution. Deeplinking is allowed when mentioning the original source.
-
OpenXML news overview
A lot of news around OpenXML these days, so I decided to bundle some things into one big blog post. In .NET 3.0, there's the System.IO.Packaging API, which allows programmatic access to OpenXML packages (amongst them Office2007 files).Since this API is quite low-level, the Microsoft people introduced a new SDK built on top of System.IO.Packaging, which allows you to use strongly typed classes for document parts. Checkout a code sample on Wouter's blog and see for yourself: this SDK provides access to an OpenXML package in a much easier way than System.IO.Packaging. Download the SDK here.
-
A small TFS linkdump...
Some new TFS links I found: Team Development with Visual Studio Team Foundation Server Guidehttp://www.codeplex.com/TFSGuide Work Item Creatorhttp://www.codeplex.com/wicreator/
-
New PHPExcel release: 1.3.0
The new version of PHPExcel has just been released, bringing 1.3.0 to the public. New features include formula calculation, inserting and removing columns/rows, auto-sizing columns, freezing panes, ... One of the new features in PHPExcel is formula calculation. Just like Excel or any other spreadsheet application, PHPExcel now provides support for calculating certain cell values, using a formula. For example, the formula "=SUM(A1:A10)" evaluates to the sum of values in A1, A2, ..., A10. Have a look at this: if you write the following line of code in the invoice demo included with PHPExcel, it evaluates to the value "64": Another nice feature of PHPExcel's formula parser, is that it can automatically adjust a formula when inserting/removing rows/columns. Here's an example:
-
Excel Formula Parsing using PHP?
One of the new (planned) features of PHPExcel is to implement parsing and calculating Excel formulas. One thing every developer should do is not to try to reinvent the wheel. Therefore, a Google search learned me someone wrote a Excel expression parser in JavaScript, which parses an expression into a tree. Parsing Excel formulas (expressions) in JavaScript is done here. Someone ported this to C# too, and as of today, it is ported to PHP5 too 8-). The only thing left to do is building this into PHPExcel, and performing calculations using the parsed tree...
-
MCTS for .NET framework 2.0 Web applications
Just like my colleague Kristof did last friday, I passed the Microsoft.NET Framework 2.0 - Web-based Client Development (Exam 070-528) exam yesterday, resulting in a new certification title: I’m now offically a Microsoft Certified Technology Specialist for .NET framework 2.0 Web applications.