Update SQL Server and return ID of row updated

So you want to update a single row in your table and then return the row identifier that was affected, here’s one way of going about it. Remember SCOPE_IDENTITY() is about inserting so as we are updating here we need a little something different. This will...

Application window freezing in Windows 8

So I am an early adopter of windows 8 on both my home computers, the intro price was just too good to miss at £15 each to windows 8 pro including this media centre thing. My first peeve with windows 8 is that applications have a frozen interface, so...

Free webcam home security solution

So I have a broadband connection, a few computers, a quickcam pro 5000 and the desire to keep an eye on what happens in front of my house when I am not there.. Crap neighbour and foxes amongst other things.. So set up a solution based around yawcam which does all the...

HTML5 and PowerShell…

I’m constantly seeing references to PowerShell in Visual Studio 2010 related tutorials, today I came across this thing… PowerShell and HTML5, and would love to get your feedback on a proof-of-concept. This prototype uses the System.Net.WebClient class to...

Bind a Dataset to a Listbox using OleDbDataAdapter

Need to bind a web control to an OleDb data source in your C# web application, here’s the magic. In this case I am binding a ListBox control with an ID of ListBox1 to the ProductName field in the Products table of our old friend the Northwind database. These are...