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

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.
MS SQL Trim On Insert Really simple SQL to remove white spaces, in particular around an email address
DevExpress Show Report In Web Form Quick n dirty on how to show a report you've created in DevExpress on your web forms. There's a note on why it may not work and what to do about it.
DevExpress Report Inner Join DevExpress's Report's don't INNER JOIN unless you use the right DATA SOURCE TYPE.
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 - Web User Control DropDownList Values Access
Admin Ren's Biking Blog