Things that are helpful
I had an error when using Dependency Injection in a Console App. I was trying to access the configuration to get a section or a connection string, and the result was always null. The article relates only to the use of Host.CreateDefaultBuilder(). in a Console Application. The Problem […]
I was asked to get a list of customers with a single address for each, and preferably the Postal address if the customer has one. Getting the first record is easy enough with a MIN function, but when you have to add an ORDER BY or GROUP BY […]
Convert a JSON array of objects to Key Value pairs so you can access the value by the key.
In this article I will show a bit of code I wrote to parse a CSV file to a list of defined objects. There are a lot of really good CSV readers out there and I don’t intend on adding one more to that mix, but I often […]
This article came about from the following question… Why are the user details blank when running my PowerApp, but they are populated when editing it? This happened to me in 2 scenarios, Using the current users details to get their supervisor, but the supervisors’ details were not showing. […]
When working with a third party EDMS I needed to add a document using a multipart/related request. Having never done a multipart/related request before I did struggle at first, trying all sorts off methods. But then I stumbled across the System.Net.Http.MultipartContent – things often seem so simple when […]
I have had this error several times on different servers, and here are the steps that I recommend following to find and resolve the problem. Step 1 – Track down the source of the error One of the things I found with this error, is that it doesn’t […]
When I first started in software development, it wasn’t so common to have a dedicated systems or business analyst (well in the smaller firms anyway). For the first 10 years or so, my job title was something like Software Analyst/Developer. I did everything including analysis, design, development, testing/debugging, […]
My Problem I had a problem today when I worked on a Power Apps Form for applying for Training, Accommodation, and or Travel (any or all of these). There was a Purpose field in the form which the user can enter one to many possible options (Training, Accommodation, […]
This article was written for SQL 2014 Summary If you have an SSRS subscription that emails out a report, but there is a requirement to only send that report if there is data, then that should be easy enough to do, shouldn’t it? From what I’ve found so […]