Tag Archives: programming

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

Posted on November 19, 2014 by Me

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!

Posted on July 25, 2013 by Me

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

Posted on January 22, 2013 by Me

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#

Posted on January 15, 2013 by Me

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#

Posted on December 24, 2012 by Me

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

Posted on December 17, 2012 by Me

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

Posted on December 7, 2012 by Me

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 , , , , | 7 Comments

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

Posted on December 7, 2012 by Me

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

Posted on November 30, 2012 by Me

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

Posted on November 29, 2012 by Me

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