Category Archives: Programming

Clear Up SSRS Subscriptions

One of the things with SSRS subscriptions is that they create a load of Agent Jobs that don’t clearly link back to specific reports. SQL warns you not to mess with these directly, so you need to find the report … Continue reading

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

Copy DataGridView to Clipboard

Following on from exporting a DataGridView to a CSV file someone asked this week if it’s possible to copy the contents to the clipboard for pasting into another application. The code below copies the content of the passed DataGridView to … Continue reading

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

Simple SSRS Menu

This post assumes you know how to create a basic SSRS report and link it to a SQL Stored Procedure. We were starting to build up a fair number of SSRS reports that the users were running on an ad … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Remove Characters in String T-SQL with No Loop Part 2

Okay, expanding on what I did yesterday. I Built a table, called ExclusionList with one field, ExcludedText E.g. Then created a function: You can then use like this:

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

Remove Characters in String T-SQL with No Loop

Ok, I’ve seen many ways to do this using loops, but nothing in plain T-SQL Let’s say we have a string that may contain illegal characters, in my case it was project identifiers that needed to be used as file … Continue reading

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

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

Showing Two Different Scales on Y Axis SQL Server Reporting Services (SSRS)

Long time, no post… I was asked to create a graph showing throughput of bags on a conveyor grouped into 5 minute intervals. ¬†One of the requirements was to show two scales on the Y axis, bags / 5 minute … Continue reading

Posted in Programming | 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