-
Recent Posts
Categories
Meta
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
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
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:
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 Character Replacement, REPLACE, sql, sql server, string manipulation, t-sql, without loop
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 asp.net, c#, css, dynamic, master page, programming, web
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 reports, sql server, SQL Server Reporting Services, SSRS
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
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