Tag Archives: programming

Dynamic CSS files in ASP.net Master Page using C#

I have a reporting portal that serves up SSRS (SQL Server Reporting Services) reports to users. The users are from different organisations, indicated by a user group. I needed to have the front end personalised for each different organisation. The … Continue reading

Posted in Programming | Tagged , , , , , , | Leave a comment

New Shop!

I have a new shop opened on Zazzle Got lots of Computer Programming related designs, mugs, t-shirts, etc, plus items with some of my photography and some other random designs… I will be adding a lot of new products over … Continue reading

Posted in Shopping | Tagged , , , , , | Leave a comment

Add child items to ToolStripMenuItem using C# – C Sharp

I wanted to be able to populate menu items from a database, i.e. I had a Print Document top level menu item and I wanted to be able to populate the children from the database dynamically with each available document. … Continue reading

Posted in Programming | Tagged , , , , , , | Leave a comment

Shuffle an Array in C#

As part of a basic guessing game I wanted to be able to shuffle an array of n chars into a random order. The method I decided to use was the following. Create a loop to iterate n times (where … Continue reading

Posted in Programming | Tagged , , , , , | 3 Comments

Loading Data into a DataReader and Looping Through Records OLEDB / C#

Just a quick example of loading data into a data reader using C#. My data source is MS SQL Server in this case, although you would just need the correct OLEDB connection string to use any other data source. Couple … Continue reading

Posted in Programming | Tagged , , , , , | Leave a comment

Changing Default Parameter Value SSRS (SQL Server Reporting Services) 2008

If you’re here you have probably found that if you’ve deployed a report to your server updating the default parameter values and redeploying has no effect on the server report. E.g. I had a report with an integer parameter with … Continue reading

Posted in Programming | Tagged , , , , , | Leave a comment

Image Slideshow on Windows Form C# with Timer Control

Quick example of how to display an image control that loops through a folder of images. Firstly drop a timer control onto your form (name: tmrNextImage), set the Interval to 1000 milliseconds (1 second) and set enabled to true. Next … Continue reading

Posted in Programming | Tagged , , , , | 6 Comments

Find all Subdirectories from a given path using C# – With Error Handler

In my earlier post () I showed how you can iterate through folders and add the folder names to a list (lstDirs). The problem with this code was that if you encountered a folder you didn’t have access to it … Continue reading

Posted in Programming | Tagged , , , , | Leave a comment

Multiple OR’s in T-SQL WHERE Condition SQL Server

Just been rewriting some SQL Server stored procedures for a client. There were a lot of SELECT statements like the one below: I’ve seen this quite a few times, and I’m not suggesting this is wrong, however I find that … Continue reading

Posted in Programming | Tagged , , , | Leave a comment

Null Dates in SQL Stored Procedure called from C# – Conversion Error DateTime2 DateTime

One issue with calling stored procedures from C# is with null date parameters. If you try to pass an unassigned DateTime type to the parameter you will receive an error regarding conversion of DateTime2 to DateTime data type. One way … Continue reading

Posted in Programming | Tagged , , , , , , | 1 Comment