Category Archives: C#

Sort a DataTable

Posted on July 20, 2018 by pfb_admin

I first noticed this technique here: https://www.codeproject.com/Questions/219205/How-To-Sort-Datatable-in-csharp-net More Juicy goodness here: https://social.msdn.microsoft.com/Forums/vstudio/en-US/87a64069-e78c-4930-a751-d2be7f1e7b50/how-to-sort-datatable?forum=csharpgeneral   private void FillSessionChecklistboxForAttendees(CheckedListBox clb, string session_id) { MesQueries.TrainingAdmin ta = new MesQueries.TrainingAdmin(_mq); ta._queryMode = MesQueries.TrainingAdmin.QueryModes.AttendeesForSession; ta.session_id = session_id; DataTable dtAttendees = _mq.GetContentDataTable(ta); Creativity is simply at the bay … Continue reading →

Posted in C#, Programming, SQL Server | Leave a comment

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

Posted on January 17, 2018 by pfb_admin

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

Tips for adjusting TableLayoutPanel

Posted on November 30, 2017 by pfb_admin

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#, Design and UX, Musings, Programming | Leave a comment

List of line endings

Posted on September 8, 2017 by pfb_admin

programmingScriptText += “\r\n”; //Windows style CRLF line ending. //programmingScriptText += “\n\r”; // Nobody does this. //programmingScriptText += With more blood flowing in and less flowing out, levitra generika Facts about levitra generika the arteries in the penis enlarge, resulting in … Continue reading →

Posted in C#, Programming | Leave a comment

C# Make a SplitContainer dragbar visible to users

Posted on August 16, 2017 by pfb_admin

/// /// 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

Posted on July 17, 2017 by pfb_admin

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

Log files and Fail-friendly code

Posted on June 7, 2017 by pfb_admin

Oh my goodness. Thoughts for the day… Log file-based troubleshooting of deployed applications in limited-access environments has to be one of the most frustrating processes of application development. Magic numbers are EVIL. Most men experience feeble erection occasionally, which is … Continue reading →

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

C# SystemColors class

Posted on August 2, 2016 by pfb_admin

I set the design-time background color of by-default-invisible controls to a vibrant Pale Green as an indication to the designer/developer/myself that this control won’t be visible unless made so. When working with the In depth studies happen to be generic … Continue reading →

Posted in C#, Programming | Leave a comment

Save a null value to a GUID field using C# SqlParameter

Posted on February 12, 2016 by pfb_admin

sCommand.Parameters.Add(“@employee_id”, SqlDbType.UniqueIdentifier).Value = (processEmployee_id == String.Empty ? System.Data.SqlTypes.SqlGuid.Null : new Guid(processEmployee_id));   In order to obtain safe and long term solutions, Ayurveda offers excellent, effective, and no side effects people generic levitra online glacialridgebyway.com prefer to take only VigrX male … Continue reading →

Posted in C#, Programming, SQL Server | Leave a comment

C# columnar Time zone conversions on populated DataTables

Posted on September 11, 2015 by pfb_admin

TLDR; the code below converts a DataTable’s time columns from UTC to local time, even when the DataTable is populated with data. My utility framework for general data displays queries a predefined content-specific DataTable into a DataGridView. The columns are automatically handled by … Continue reading →

Posted in C#, Programming | 2 Comments