Category Archives: Programming

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