Archive for April, 2010

Find text in stored procedure

Posted: 23rd April 2010 by thegrayzone in Development
Tags: , ,

Today I was trying to debug an error that was occurring in an old .NET 1.1 and SQL Server 2000 application. I needed to find out how a particular value was being set in a DataSet. I knew the value was being returned via a stored procedure, and due to naming conventions this stored procedure [...]

LINQ2SQL GroupBy

Posted: 23rd April 2010 by thegrayzone in Development
Tags: , ,

I’m currently working on a taxi-type system that manages journeys for customers. All journeys need authorised before they can be carried out. There is a page that shows all journeys that require authorisation but this required changing to show 1 row per customer rather than 1 row per journey. I got some help from Andy [...]

Action Delegate

Posted: 12th April 2010 by thegrayzone in Development
Tags: , ,

I recently wrote a small application for transferring files which searches through the specified folder and any child folders for files matching the specified filter. The application has a checkbox for the user to select whether to copy or cut/move the file. I decided to use the Action delegate to set the action to perform [...]