TechyGypo

Techy stuff I find out about in the world of computers and stuff like that...

Friday, 27 October 2017

Open & Close a VPN Connection with C#

›
I've thrown together this simple class to check if a windows VPN connection is open and with it you can also connect and disconnect. It...
Friday, 13 January 2017

signalR - Error during WebSocket handshake: Unexpected response code: 500

›
Having recently started playing with signalR , I got the following error: WebSocket connection to 'ws://localhost/../signalr/connect?t...
10 comments:
Friday, 2 December 2016

Set Many Properties in One Go

›
If you're looking for a way to set the value of many properties who's name starts with the same string, then look no further! Here...
Wednesday, 18 November 2015

SQL Server Remove Command from Replication

›
I managed to create a script on a replicated database that when run on the live server errored - oops! I've had this before and it stops...
Thursday, 27 August 2015

Filter an Enum By String Value in C#

›
I have an enum declared and wanted to get all items in the enum that contained certain text. Well, this can be done using Linq and here...
Saturday, 25 July 2015

Setting a Default Value on a C# Property

›
Came across this little beauty for setting a default value on a C# 5.0 and below property so you can condense this: private int myInt = 3;...
Thursday, 9 April 2015

Overload Resolution Failed Because No Accessible Is Most Specific For These Arguments

›
I have a method which has two overloads where I can pass one of two object types. In some cases, these objects may be Nothing or null . Whe...
Thursday, 9 October 2014

Get Google Calendar Event ID from the Page

›
If you need to find out the event ID from a Google calendar event, then luckily Google puts the ID for us on the page! I found this posting...
Wednesday, 20 August 2014

Count the Rows of a Filtered Tablix

›
Been having some major ball aches with SSRS (SQL Server Reporting Services) recently -specifically around trying to hide elements and filter...
Tuesday, 19 August 2014

Error Applying Security - Failed to Enumerate Objects

›
I was recently trying to apply some security settings to a folder in Windows. When I clicked OK or Apply I had a Error Applying Security -...
Saturday, 22 March 2014

C# & VB.NET Trim String To a Specific Length

›
I needed to trim some strings that if over a certain length would trim nicely and add "..." to the end. I particularly like to use...

C# Hex Colour to RGB

›
I have to do a lot of interop work with Word & Excel and generally struggle matching up colour pallets across the two applications and t...

Return Dynamic Generic IList in C#

›
I had a situation where I had a SQL statement stored against a row in a database. Depending on the row would depend on what data was output....
Friday, 27 September 2013

How To Use __doPostBack with an ASP.NET Button

›
Courtesy of  Nikhil Vartak , I found I new way to able to perform a postback using an ASP.NET Button control. By default the button control...
1 comment:
Wednesday, 21 August 2013

SSRS: Black Box When Exporting to PDF with Hidden Column

›
Had a funny with SQL Server Reporting Services where I had a column in a table being hidden based on an expression. That was all fine, the i...
Friday, 12 April 2013

How To Change the Value in the app.config File

›
If you need to be able to change values in your application's app.config file, then it is surprisingly easy :) In VB Dim config As ...
Thursday, 11 April 2013

Method VBProject of _workbook Failed

›
I ran recently ran an old bit of Excel VBA in Excel 2010 which automatically adds the Microsoft Scripting Runtime to the workbook for me. Ra...
Wednesday, 30 January 2013

OpenVPN Client: Import Error Cannot Read ca Directive

›
I was following instructions to import an OpenVPN connection and got the following error: IMPORT_ERROR: Profile or its references could n...
Sunday, 20 January 2013

SSRS: Table KeepTogether Not Working

›
I was recently having a problem with SQL Server Reporting Services 2005 edition trying to stop a table control from breaking over a page. Th...
Monday, 24 December 2012

How To Schedule Sending an Email with GMail

›
If you need to send scheduled emails from GMail  or Goolge Apps, use Boomerang . It's mega easy and you are able to send 10 a month on t...
1 comment:
›
Home
View web version
Powered by Blogger.