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 - Auto Suggest Javascript JSON C# SQL