Category Archives: Programming

save to DB & update DT+DGV, vs Total UI requery from DB

Here’s code for this… save to database + update local datatable + update local datagridview = faster than refreshing UI from database if (lblSerialNumberId.Text != “”) { MesQueries.SRUSheetCreation sru = new MesQueries.SRUSheetCreation(_mq); string serial_number_id = lblSerialNumberId.Text; string change_orders = txtChangeOrders.Text; … Continue reading

Posted in C#, Programming | Leave a comment

SQL Server diagnostics notes

This week’s amusement: performance of a recently-implemented Stored Procedure dropped and dropped to intolerable levels. This system cannot be easily upgraded. Significant fragmentation is involved. Memory pressure is involved. Inserts to table variables in multiple stored procs are involved. This … Continue reading

Posted in Linkdump, Programming, SQL Server, System/DB Administration | Leave a comment

Tips for adjusting TableLayoutPanel

UI adjustments feel clumsy until you struggle through several, but there are some techniques that can help. It’s obviously better to see these in use, but a list is at least something to start with. TableLayoutPanel displays a flyout menu … Continue reading

Posted in C#, Musings, Programming | Leave a comment

tip: passive error and warning messages

It’s best to put error/warning messages in very passive, non-blaming language, especially if users might see them. Avoid exclamation marks unless something is seriously wrong and they need to take immediate action, and in that case tell them which actions … Continue reading

Posted in Business, Musings, Programming, System/DB Administration | Leave a comment

List of line endings

programmingScriptText += “\r\n”; //Windows style CRLF line ending. //programmingScriptText += “\n\r”; // Nobody does this. //programmingScriptText += “\r”; // Max style (CR) line ending. //programmingScriptText += “\n”; //UNIX style (LF) line ending.

Posted in C#, Programming | Leave a comment

C# Make a SplitContainer dragbar visible to users

/// /// Given a SplitContainer, /// set the color of its background to make the splitter dragbar visible to users. /// Set the color of the splitter’s panels to the original color of the splitter, /// to keep their backcolors … Continue reading

Posted in C#, Programming | Leave a comment

ClickOnce, Crystal Reports, and dependent projects

Problem causing failure to install ClickOnce project after adding a reference to another project: ERROR DETAILSERROR DETAILS Following errors were detected during this operation. * [7/17/2017 12:01:25 PM] System.Deployment.Application.InvalidDeploymentException (RefDefValidation) – Reference in the manifest does not match the identity … Continue reading

Posted in C#, Linkdump, Programming, System/DB Administration | Leave a comment

Linkdump: Dynatrace- app monitoring with AI

https://info.dynatrace.com/apm_wc_ai_webinar_na_registration.html  

Posted in Business Intelligence, Linkdump | Leave a comment

LINQ basics

Basic LINQ Query Operations (C#) https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/concepts/linq/basic-linq-query-operations  

Posted in Linkdump, Programming | Leave a comment

Phil Factor @ SimpleTalk: Statistics in SQL: Pearson’s Correlation

Statistics in SQL: Pearson’s Correlation The series so far: Statistics in SQL: Pearson’s Correlation Statistics in SQL: Kendall’s Tau Rank Correlation Statistics in SQL: Simple Linear Regressions Statistics in SQL: The Kruskal–Wallis Test

Posted in Business Intelligence, SQL Server, System/DB Administration | Leave a comment