Posts

Showing posts from 2008

Visual Studio 2008 Survey

My friend Fabien Lavocat from Microsoft France recently sent me an email regarding a Visual Studio 2008 survey they have just started. The survey is of course available in English. If you have a couple of minutes to kill, please answer the survey as this will help Microsoft improve their future editions of Visual Studio! Click here to access the survey Thanks for your time!

Dotnet-France

For french developers willing to obtain Microsoft Developer certifications, a colleague of mine (Julien Dollon) has just published a very useful website that will help you prepare for the certification exams: Dotnet-france.com I wish Julien good luck with his website and trust it will be a great help a lot of developers.

[MySQL] Using SQL_CALC_FOUND_ROWS and FOUND_ROWS with MySQL

Hello, for this second blog article I've decided to explain this neat little feature of MySQL: SQL_CALC_FOUND_ROWS and FOUND_ROWS() . This article is about MySQL only, it is likely that these keywords/functions exist in other SQL-based languages but I've only ever used them with MySQL. What's the point, you ask? When working with (my)SQL databases, you often find yourself using the LIMIT keyword, in order for example to limit the results of a large search. Let's study a particular case. - You're working on the "employees" table, which contains, say 1000 data rows. - You wish to display the list of employees in a particular department, 10 by 10. - You wish to display the amount of employees in this department . What would you normally do? Here's a rough example: $result = mysql_query("SELECT * FROM employees WHERE department='sales' LIMIT 0,10 "); $total = mysql_num_rows($result); -> This is incorrect because $total will never exce

WPF: drawing a video using MediaPlayer, VideoDrawing and DrawingBrush

Image
I've decided to start this blog for a simple reason: I was recently doing some research on various subjects, and was unable to find any clear documentation. And here I was thinking the World Wide Web had all the answers. Perhaps my contributions will help some of my fellow developers! This first article is about how to draw a video using the MediaPlayer class in WPF (C# only - my apologies to VB.NET users: I'm allergic to VB). I was in the middle of preparing a training session at Avanquest Software when I read something in the WPF MOC: using the MediaElement control isn't the only way you can draw a video on a surface. Doh! I investigated a little further on the subject but couldn't find anything on the subject. What does this do? This article will explain how to use the MediaPlayer class to play a video on a surface. To demonstrate the wide range of possibilities offered by this mechanism, I will explain how to draw the same video clip on 9 different controls simulta