Welcome To TechSolus

What's A Techsolus?

A bloke in Bolton, a computer and 23 years of experience in the IT industry. I are be mostly a programmer using C# .NET, SQL, and web page front ends. Currently I'm getting to grips with MVC, a lot of Javascript and JQuery, APIs such as Amazon and PayPal, and Razor pages.

So What's This Website?

This is my brain dump. I learned a LONG time ago there is simply too much to know in IT. There's no way I can remember EVERYTHING. I use this space to keep my notes and code samples to act as a reminder of the things I know and some things that I've forgotten I know.

The Nerding Blog

C# Get Types From Object (SQL Fudge) An example for showing the type of an object, in this case used to prepare parameters for an sql query
Auto Suggest Javascript JSON C# SQL Example code for a textbox with suggestions appearing as you type. This is also split be spaces in the search
Transact SQL IsNumeric Examples Examples on how to use Transact SQLs ISNUMERIC Function in a IIF Statement
SQL For Working Hours Using SQL to calculate working hours seems fiddly, but we'll get there in the end
C# Add Column(s) to a Datatable Reminder of the quick way to add columns to a regular DataTable in C#
C# HttpClient and Async Super Basic Example Really simple ASP.Net Framework aspx page that uses Asynchronous method to get HTML from a website.
DevExpress GridView Column Button And Popup A basic example of DevExpress's GridView populated on the code side, with a button in a column and a popup also from DevExpress
DevExpress GridView Populate In Code Another super basic example of using DevExpress's GridView but this is filled in the code rather than with a regular DataSource in the html side.
JavaScript Moveable Draggable Div This is NOT a "drag-n-drop" div, rather a div that a user can position on the page where they see fit by dragging it with their mouse. VERY SIMPLE
SQL SUM of Non Normalised Column Getting Normalised SUMS from a non normalised table can be tricky... This seems to work fine. Be curious to see how slow it is on a BIG dataset though.
See More What's New

Latest Posts

C# Add Column(s) to a Datatable x said :-
x
11/10//2023 13:52:19 UTC
Quick CheatSheet C# HashTables Fred said :-
Ta
04/12//2023 15:27:14 UTC
Fix DBNull In C# David S Squire said :-
I've been struggling with this for some time. It is the '.Value' part I was missing.
07/22//2021 14:55:46 UTC
PHP Mail() With HTML DSG said :-
Cheers, useful thanks
06/11//2021 14:48:44 UTC
C# Equivalent of VB's vbcrlf JohnS said :-
Thanks, durgh
08/07//2019 11:35:50 UTC
C# Hash SHA512 Simple Dirty JT said :-
Handy. Nice n simple
02/18//2019 11:55:49 UTC
See More Comments

Latest Chit-Chat

Go To Chit-Chat Ren - The Ed said :-
BAH HUMBUG!!
12/24//2019 10:34:40 UTC
Random Link - Visual Studio Code Reset - Green Underlines
Admin Ren's Biking Blog