Articles by PIEBALDconsult (Articles: 42, Tip/Tricks: 45)

Articles: 42, Tip/Tricks: 45

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.12

.NET
	MasterFileUpdater 25 Nov 2011 Updated: 25 Nov 2011 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 17,591 Bookmarked: 10 Downloaded: 116 Please Sign up or sign in to vote. A generic class to help plumb the matching of items of two sorted lists
	ParsedCommandLine 12 Feb 2013 Updated: 15 Mar 2013 Rating: 4.91/5 Votes: 8 Popularity: 4.44 Licence: CPOL Views: 29,483 Bookmarked: 28 Downloaded: 225 Please Sign up or sign in to vote. An enumeration-based command line parser.
	Testing for Empty String 21 Feb 2008 Updated: 21 Feb 2008 Rating: 3.03/5 Votes: 13 Popularity: 3.37 Licence: CPOL Views: 48,061 Bookmarked: 12 Downloaded: 0 Please Sign up or sign in to vote. A brief comparison of techniques of testing for empty strings
General Programming
Algorithms	From one number system to another 9 May 2012 Updated: 10 May 2012 Rating: 4.80/5 Votes: 8 Popularity: 4.33 Licence: CPOL Views: 15,302 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "From one number system to another"
File	MergeFiles 3 Jun 2016 Updated: 3 Jun 2016 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 10,342 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. A C function that merges the content from an arbitrary number of text files into a Character-Separated-Variable-Width result file
Programming Languages
C#	PIEBALDdiff 30 Aug 2009 Updated: 21 Sep 2009 Rating: 3.95/5 Votes: 15 Popularity: 4.65 Licence: CPOL Views: 37,111 Bookmarked: 9 Downloaded: 149 Please Sign up or sign in to vote. A line-by-line file diff utility
	Accessing CommandTimeout Properties in a TableAdapter 9 Feb 2006 Updated: 9 Feb 2006 Rating: 4.76/5 Votes: 12 Popularity: 4.76 Licence: CPOL Views: 153,251 Bookmarked: 23 Downloaded: 0 Please Sign up or sign in to vote. Describes adding public properties to a TableAdapter to access the CommandTimeouts of the private DataAdapter
	DatabaseAccessor 13 Aug 2007 Updated: 23 Aug 2007 Rating: 4.73/5 Votes: 24 Popularity: 6.35 Licence: CPOL Views: 120,814 Bookmarked: 98 Downloaded: 945 Please Sign up or sign in to vote. A simple base class that encapsulates basic database access functionality
	Simplified Database Access via ADO.NET Interfaces 2 Apr 2014 Updated: 2 Apr 2014 Rating: 4.56/5 Votes: 15 Popularity: 5.36 Licence: CPOL Views: 45,675 Bookmarked: 37 Downloaded: 830 Please Sign up or sign in to vote. Using the ADO.NET Interfaces to build a small framework to simplify Database Access
	Database Connector 28 Jan 2009 Updated: 28 Jan 2009 Rating: 4.78/5 Votes: 14 Popularity: 4.56 Licence: CPOL Views: 48,814 Bookmarked: 42 Downloaded: 508 Please Sign up or sign in to vote. A system of plug-ins that provide very simple database access
	TimeRanger -- Allows foreaching across a time interval 9 Feb 2007 Updated: 9 Feb 2007 Rating: 3.85/5 Votes: 9 Popularity: 3.67 Licence: CPOL Views: 41,853 Bookmarked: 31 Downloaded: 294 Please Sign up or sign in to vote. A class that allows foreach to enumerate various points within the time interval defined by two DateTime objects
	Enum Utilities 17 Feb 2008 Updated: 24 Feb 2008 Rating: 4.73/5 Votes: 29 Popularity: 6.85 Licence: CPOL Views: 95,734 Bookmarked: 106 Downloaded: 435 Please Sign up or sign in to vote. Various methods for working with enumerations
	EnumOperators 22 May 2008 Updated: 22 May 2008 Rating: 4.50/5 Votes: 11 Popularity: 4.50 Licence: CPOL Views: 34,472 Bookmarked: 30 Downloaded: 146 Please Sign up or sign in to vote. A class to help ease the burden of not being able to specify enum as a generic constraint
	EnumTree 12 Jun 2008 Updated: 12 Jun 2008 Rating: 3.75/5 Votes: 4 Popularity: 2.26 Licence: CPOL Views: 20,072 Bookmarked: 14 Downloaded: 98 Please Sign up or sign in to vote. A class and attribute to allow accessing enum values as a tree
	TypeTransmogrifier 11 Jun 2008 Updated: 13 Jun 2008 Rating: 3.92/5 Votes: 4 Popularity: 2.36 Licence: CPOL Views: 34,713 Bookmarked: 19 Downloaded: 87 Please Sign up or sign in to vote. Allows mapping of types to enumerated values.
	.NET Rational (fraction) value type using Decimals, written in C# 24 Jan 2006 Updated: 24 Jan 2006 Rating: 2.28/5 Votes: 6 Popularity: 1.77 Licence: CPOL Views: 37,543 Bookmarked: 13 Downloaded: 235 Please Sign up or sign in to vote. Implements a Rational datatype.
	DateTruncate 14 Nov 2006 Updated: 14 Nov 2006 Rating: 2.79/5 Votes: 7 Popularity: 2.36 Licence: CPOL Views: 16,152 Bookmarked: 8 Downloaded: 69 Please Sign up or sign in to vote. This article describes my DateTruncate function.
	ThreadQueue -- A queue for threads that allows asynchronous execution and a time limit 6 Dec 2006 Updated: 6 Dec 2006 Rating: 4.14/5 Votes: 9 Popularity: 3.95 Licence: CPOL Views: 47,746 Bookmarked: 41 Downloaded: 250 Please Sign up or sign in to vote. Describes my ThreadQueue class and related classes.
	SetServiceDescription 12 Jul 2006 Updated: 14 Jan 2008 Rating: 2.83/5 Votes: 7 Popularity: 2.39 Licence: CPOL Views: 23,711 Bookmarked: 12 Downloaded: 76 Please Sign up or sign in to vote. A method for setting the "description" of a Windows Service.
	Versioner: An AssemblyInfo version incrementer 9 Jun 2006 Updated: 9 Jun 2006 Rating: 3.00/5 Votes: 9 Popularity: 2.86 Licence: CPOL Views: 42,481 Bookmarked: 9 Downloaded: 374 Please Sign up or sign in to vote. A simple C# program that will increment the AssemblyVersion attribute of an AssemblyInfo.cs file.
	NonNullable Class Wrapper 11 Apr 2008 Updated: 11 Apr 2008 Rating: 4.68/5 Votes: 18 Popularity: 5.75 Licence: CPOL Views: 49,402 Bookmarked: 20 Downloaded: 124 Please Sign up or sign in to vote. A wrapper to place the burden of checking a class reference for null on the calling method rather than the called method.
	Parsomatic 8 Dec 2008 Updated: 8 Dec 2008 Rating: 4.00/5 Votes: 4 Popularity: 2.41 Licence: CPOL Views: 27,641 Bookmarked: 15 Downloaded: 97 Please Sign up or sign in to vote. A Dictionary of Parse methods for several datatypes
	A Simple, Infix to Reverse Polish Notation Transformer, Written in C# 24 Jan 2006 Updated: 10 Mar 2009 Rating: 3.03/5 Votes: 10 Popularity: 3.03 Licence: CPOL Views: 58,944 Bookmarked: 12 Downloaded: 452 Please Sign up or sign in to vote. Transforms a mathematical expression from Infix notation to Reverse Polish notation
	ProgressDialog: for executing long-running code with some thread safety 19 May 2006 Updated: 23 May 2006 Rating: 2.70/5 Votes: 9 Popularity: 2.57 Licence: CPOL Views: 65,929 Bookmarked: 45 Downloaded: 898 Please Sign up or sign in to vote. A dialog for executing long-running code on a thread (written in C#).
	ApplyFormat 2 Feb 2009 Updated: 9 Mar 2009 Rating: 4.33/5 Votes: 2 Popularity: 1.30 Licence: CPOL Views: 20,771 Bookmarked: 9 Downloaded: 75 Please Sign up or sign in to vote. A method to apply multiple formats to a value
	A Set class 20 Nov 2006 Updated: 20 Nov 2006 Rating: 4.48/5 Votes: 11 Popularity: 4.27 Licence: CPOL Views: 67,342 Bookmarked: 28 Downloaded: 363 Please Sign up or sign in to vote. A Set class using a System.Collections.Generic.Dictionary to hold its elements.
	Non-recursive Permutations and Combinations 22 Dec 2010 Updated: 22 Dec 2010 Rating: 4.87/5 Votes: 11 Popularity: 5.07 Licence: CPOL Views: 48,888 Bookmarked: 16 Downloaded: 365 Please Sign up or sign in to vote. Enumerating permutations and combinations without recursion.
	The Hexatridecimal Numbering System 24 Nov 2012 Updated: 24 Nov 2012 Rating: 3.50/5 Votes: 2 Popularity: 1.05 Licence: CPOL Views: 11,872 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "The Hexatridecimal Numbering System"
	ReplaceOmatic 27 Nov 2016 Updated: 30 Nov 2016 Rating: 4.95/5 Votes: 12 Popularity: 5.15 Licence: CPOL Views: 13,013 Bookmarked: 7 Downloaded: 201 Please Sign up or sign in to vote. Performs replacements within strings
	CommScript 23 Mar 2010 Updated: 3 Apr 2010 Rating: 4.42/5 Votes: 7 Popularity: 3.73 Licence: CPOL Views: 25,413 Bookmarked: 19 Downloaded: 207 Please Sign up or sign in to vote. A simple scripting engine for automating communication (e.g. Telnet)
	TelnetSocket 4 Mar 2010 Updated: 3 Apr 2010 Rating: 4.47/5 Votes: 20 Popularity: 5.72 Licence: CPOL Views: 88,994 Bookmarked: 44 Downloaded: 5,965 Please Sign up or sign in to vote. A wrapper for a System.Net.Sockets.TcpClient that performs simple Telnet negotiation and is scriptable.
	Untabify and Tabify 16 Jan 2009 Updated: 16 Jan 2009 Rating: 3.31/5 Votes: 7 Popularity: 2.80 Licence: CPOL Views: 42,344 Bookmarked: 3 Downloaded: 121 Please Sign up or sign in to vote. Untabify and Tabify Extension Methods for intending code.
	RegexTester 20 Aug 2009 Updated: 20 Aug 2009 Rating: 4.56/5 Votes: 8 Popularity: 4.11 Licence: CPOL Views: 35,155 Bookmarked: 35 Downloaded: 308 Please Sign up or sign in to vote. Presenting a test bed for .NET Regular Expressions
	Rive 28 Mar 2010 Updated: 28 Mar 2010 Rating: 4.97/5 Votes: 15 Popularity: 5.85 Licence: CPOL Views: 40,461 Bookmarked: 28 Downloaded: 121 Please Sign up or sign in to vote. An improved string split method.
	ProcessCommunicator 5 Apr 2010 Updated: 5 Apr 2010 Rating: 5.00/5 Votes: 16 Popularity: 5.88 Licence: CPOL Views: 32,724 Bookmarked: 28 Downloaded: 335 Please Sign up or sign in to vote. A class that allows my CommScript class to "'drive' a command line utility"
	Compiling Source Code from a String 19 Aug 2009 Updated: 19 Aug 2009 Rating: 3.97/5 Votes: 9 Popularity: 3.79 Licence: CPOL Views: 52,942 Bookmarked: 23 Downloaded: 296 Please Sign up or sign in to vote. A method that uses a CodeDomProvider to compile program code from a string into an Assembly.
	LimitedQueue 16 Dec 2008 Updated: 23 Dec 2008 Rating: 4.35/5 Votes: 12 Popularity: 4.70 Licence: CPOL Views: 51,226 Bookmarked: 18 Downloaded: 190 Please Sign up or sign in to vote. Wrapping a built-in type when deriving is not a suitable solution, and why
	Implanting Common Code in Unrelated Classes 6 Dec 2009 Updated: 6 Dec 2009 Rating: 4.45/5 Votes: 3 Popularity: 2.13 Licence: CPOL Views: 29,936 Bookmarked: 4 Downloaded: 43 Please Sign up or sign in to vote. Using partial classes to share common code when a base class and inheritance aren't appropriate
Visual Basic	Transsubstantiate 2 Apr 2011 Updated: 2 Apr 2011 Rating: 4.33/5 Votes: 2 Popularity: 1.30 Licence: CPOL Views: 16,543 Bookmarked: 6 Downloaded: 96 Please Sign up or sign in to vote. Copying base class constructors to derived classes
XML	XmlNode 15 May 2011 Updated: 15 May 2011 Rating: 4.64/5 Votes: 8 Popularity: 4.19 Licence: CPOL Views: 63,813 Bookmarked: 20 Downloaded: 758 Please Sign up or sign in to vote. A technique to make working with XML easier
	XmlBuilder 20 Oct 2008 Updated: 20 Oct 2008 Rating: 3.40/5 Votes: 5 Popularity: 2.38 Licence: CPOL Views: 36,411 Bookmarked: 12 Downloaded: 173 Please Sign up or sign in to vote. Wraps an XmlDocument to simplify formatting flat data into XML
XSLT	Using XML/XSLT with the "C Preprocessor" 7 May 2007 Updated: 7 May 2007 Rating: 3.52/5 Votes: 6 Popularity: 2.74 Licence: CPOL Views: 41,805 Bookmarked: 7 Downloaded: 75 Please Sign up or sign in to vote. How to misuse XML/XSL to do what not even the
	GenOmatic 17 Feb 2009 Updated: 9 Mar 2009 Rating: 3.80/5 Votes: 4 Popularity: 2.29 Licence: CPOL Views: 23,314 Bookmarked: 14 Downloaded: 69 Please Sign up or sign in to vote. A console application to generate enumerations from a database query

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.56

.NET
	Enumerating OleDb Providers [Tip/Trick] 22 Feb 2018 Updated: 22 Feb 2018 Rating: 3.67/5 Votes: 5 Popularity: 2.56 Licence: CPOL Views: 10,463 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. A simple way to enumerate the OleDb Providers installed on the system
	IDictionary.AddWithType Extension Method [Tip/Trick] 6 Apr 2016 Updated: 6 Apr 2016 Rating: 4.69/5 Votes: 4 Popularity: 2.83 Licence: CPOL Views: 11,493 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. An Extension Method to avoid an undocumented limitation of Exceptions
	On why to use DataViews [Tip/Trick] 7 Dec 2014 Updated: 7 Dec 2014 Rating: 5.00/5 Votes: 5 Popularity: 3.49 Licence: CPOL Views: 16,084 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. Why your methods should accept DataViews; not just DataTables.
	Write right [Tip/Trick] 24 Jan 2013 Updated: 24 Jan 2013 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 5,781 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Regarding use of the various Write and WriteLine methods
ADO.NET
	Listing Sheets in an Excel File [Tip/Trick] 21 Feb 2018 Updated: 21 Feb 2018 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 6,150 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. A simple way to use ADO.NET to get a list of sheets in an Excel file
Database Development
	Generating constructors at compile time [Tip/Trick] 6 Dec 2014 Updated: 8 Dec 2014 Rating: 4.72/5 Votes: 8 Popularity: 4.26 Licence: CPOL Views: 27,093 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "C# Convert DataTable to List of Objects Dynamically"
SQL Server	Stupid CTE tricks -- string concatenation [Tip/Trick] 17 Dec 2011 Updated: 25 Dec 2011 Rating: 4.67/5 Votes: 5 Popularity: 3.26 Licence: CPOL Views: 40,521 Bookmarked: 9 Downloaded: 0 Please Sign up or sign in to vote. Concatenating values from multiple rows into one string value via a Common Table Expression
	Getting a list of SQL Server modules to refresh [Tip/Trick] 17 Dec 2011 Updated: 25 Dec 2011 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 20,032 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Using a Common Table Expression to produce a list of Views, Procedures, and Functions
	Getting a List of SQL Server Modules to Refresh [Tip/Trick] 1 Mar 2012 Updated: 26 Apr 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 12,511 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. How to get a list of SQL Server modules to refresh
	LPAD and RPAD Functions in SQL [Tip/Trick] 15 Mar 2012 Updated: 15 Mar 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 10,740 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "LPAD and RPAD functions in SQL"
	Bitwise OR aggregate [Tip/Trick] 28 Mar 2012 Updated: 28 Mar 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 19,199 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Performing a bitwise OR aggregate in SQL Server
	List SQL Server table column name as rows [Tip/Trick] 3 May 2012 Updated: 3 May 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 11,472 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "List SQL Server table column name as rows"
	SQL Server Procedure to Report Duplicates [Tip/Trick] 13 Dec 2014 Updated: 13 Dec 2014 Rating: 5.00/5 Votes: 10 Popularity: 5.00 Licence: CPOL Views: 25,108 Bookmarked: 12 Downloaded: 0 Please Sign up or sign in to vote. A stored procedure I use to find duplicate records in tables and views.
	Sorting 'Total' After Data Values [Tip/Trick] 28 Mar 2012 Updated: 1 Jun 2016 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 21,511 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Interspersing 'Total' rows among summarized data rows in the correct order
	Concatenate many rows into a single text string using SQL Server 2008 [Tip/Trick] 23 Feb 2012 Updated: 23 Feb 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 11,854 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. See also Stupid CTE tricks -- string concatenation[^]
Desktop Programming
Windows Forms	Adding Functionality To .NET Controls [Tip/Trick] 7 Aug 2014 Updated: 7 Aug 2014 Rating: 3.00/5 Votes: 2 Popularity: 0.90 Licence: CPOL Views: 8,860 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "Adding Functionality To .NET Controls"
	TextBox cursor position [Tip/Trick] 6 Dec 2011 Updated: 25 Dec 2011 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 9,021 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. OK, here's another way (I found this at http://dotnet.mvps.org/dotnet/faqs/?id=textboxcaretpos&lang=en[^]). [System.Runtime.InteropServices.StructLayoutAttribute (System.Runtime.InteropServices.LayoutKind.Sequential)]private struct ApiXY{ public int X ; public int Y ;}[ ...
	TextBox cursor position [Tip/Trick] 29 Nov 2011 Updated: 3 Jan 2012 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: CPOL Views: 81,753 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. Getting the line and position of the cursor in a TextBox
	Determining which TabPage was clicked [Tip/Trick] 8 Nov 2011 Updated: 7 Jan 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 31,341 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. A binary search technique to determine which TabPage of a TabControl was clicked
General Programming
Algorithms	Split Any Delimited String in SQL [Tip/Trick] 11 Sep 2015 Updated: 11 Sep 2015 Rating: 4.83/5 Votes: 3 Popularity: 2.31 Licence: CPOL Views: 14,420 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "Split Any Delimited String in SQL"
String	A String.StartsWith that uses a StringComparer [Tip/Trick] 10 Feb 2012 Updated: 23 Feb 2012 Rating: 4.60/5 Votes: 5 Popularity: 3.22 Licence: CPOL Views: 12,632 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. An Extension Method that is similar to String.StartsWith, but uses a StringComparer
	Dictionary<string,T>.BestMatch [Tip/Trick] 1 Feb 2013 Updated: 27 Mar 2015 Rating: 4.60/5 Votes: 3 Popularity: 2.19 Licence: CPOL Views: 32,943 Bookmarked: 11 Downloaded: 0 Please Sign up or sign in to vote. Extension methods to select a Dictionary entry using StartsWith
IList
	Getting the index of an item in a sorted IList [Tip/Trick] 8 Dec 2011 Updated: 8 Dec 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 5,540 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. I wasn't going to publish this version, but I just used it a second time, so maybe someone else will need it too. This is very much like the second version above except that it uses a non-generic IList. Today, I used this to find and insert TreeNodes in a TreeNodeCollection, yesterday I used it...
	Getting the index of an item in a sorted IList [Tip/Trick] 7 Dec 2011 Updated: 25 Dec 2011 Rating: 4.56/5 Votes: 2 Popularity: 1.37 Licence: CPOL Views: 36,432 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. A binary search of a sorted IList to retrieve an index
Operating Systems
DOS	Deleting subtrees in a DOSbox [Tip/Trick] 8 Nov 2011 Updated: 10 Nov 2011 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 9,465 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Using DOS' FOR command to delete subtrees
	Setting a DOS box as large as the monitor will allow [Tip/Trick] 12 Nov 2011 Updated: 13 Nov 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 7,251 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Using a few members of the System.Console class to fill the screen
Programming Languages
C#	How to Split Long Strings into Manageable Portions and Display them in a MessageBox [Tip/Trick] 16 Jun 2014 Updated: 16 Jun 2014 Rating: 4.71/5 Votes: 4 Popularity: 2.84 Licence: CPOL Views: 18,146 Bookmarked: 9 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "How to Split Long Strings into Manageable Portions and Display them in a MessageBox"
	Producing KeyPress events for the Console [Tip/Trick] 23 Nov 2011 Updated: 23 Nov 2011 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 26,327 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. A C# class to raise KeyPress events for use in Console Applications
	A Flexible String Trim Method [Tip/Trick] 6 Apr 2018 Updated: 6 Apr 2018 Rating: 4.83/5 Votes: 6 Popularity: 3.76 Licence: CPOL Views: 7,890 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. A Trim method for strings that provides flexibility without requiring the use of large character arrays
	The Elegant Art of Programming [Tip/Trick] 15 May 2012 Updated: 15 May 2012 Rating: 3.67/5 Votes: 3 Popularity: 1.75 Licence: CPOL Views: 11,800 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "The Elegant Art of Programming"
	The Elegant Art of Programming [Tip/Trick] 16 May 2012 Updated: 18 May 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 25,943 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "The Elegant Art of Programming"
	TryGetLineAndOffsetOf [Tip/Trick] 7 Nov 2016 Updated: 7 Nov 2016 Rating: 4.38/5 Votes: 4 Popularity: 2.63 Licence: CPOL Views: 9,432 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. A method to match a string within a string, but with added features
	Cloning an Exception (kinda sorta) [Tip/Trick] 9 Apr 2011 Updated: 10 Apr 2011 Rating: 4.75/5 Votes: 3 Popularity: 2.27 Licence: CPOL Views: 21,864 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Using Reflection to instantiate an Exception of a given type
	System-wide compiler symbols [Tip/Trick] 25 Apr 2010 Updated: 11 Jul 2010 Rating: 3.88/5 Votes: 7 Popularity: 3.27 Licence: CPOL Views: 17,750 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. A way to define system-wide compiler symbols to be used for all C# builds
	Use wildcard characters * and ? to compare strings [Tip/Trick] 20 Feb 2012 Updated: 20 Feb 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 16,902 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. This is much simpler: fewer new strings created, no recursion. And it allows the caller to specify how to do a string comparison.public static boolWildcardMatch( this string Subject, string Pattern, System.StringComparison...
C# 4.0	PrettyXML (.NET Port) [Tip/Trick] 12 Jul 2012 Updated: 12 Jul 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 8,891 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "PrettyXML (.NET Port)"
	Sorting Strings Based on the Position of the Block Letter [Tip/Trick] 6 Jun 2012 Updated: 6 Jun 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 15,428 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "Sorting Strings based on the position of the block letter"
SQL	SQL Convert Simple Names to Proper Case [Tip/Trick] 19 Nov 2017 Updated: 19 Nov 2017 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 8,064 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "SQL Convert Sentence to Proper Case"
	Instantiating an SqlException [Tip/Trick] 11 Apr 2011 Updated: 20 Apr 2011 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 29,873 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. Using Reflection to instantiate a System.Data.SqlClient.SqlException
	SQL Server 2008 User Defined Table Types and Table-Valued Parameters [Tip/Trick] 11 Jul 2010 Updated: 14 Jul 2010 Rating: 4.90/5 Votes: 6 Popularity: 3.81 Licence: CPOL Views: 113,957 Bookmarked: 12 Downloaded: 0 Please Sign up or sign in to vote. Simple demonstration of using UDTTs and TVPs to pass DataTables to SQL Server 2008
T-SQL	LTRIM RTRIM doesn’t always work [Tip/Trick] 16 Feb 2012 Updated: 16 Feb 2012 Rating: 3.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 13,270 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. In SQL Server 2008, I do that with a CLR User Defined Function:namespace PIEBALD.Lib{ public static partial class LibSql { public static string Trim ( string Victim ) { return ( Victim.Trim() ) ; } }}Needs to be built into a...
Stopwatch
	A simple way to use a Stopwatch [Tip/Trick] 28 Nov 2011 Updated: 25 Dec 2011 Rating: 1.67/5 Votes: 2 Popularity: 0.50 Licence: CPOL Views: 26,372 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Making Stopwatches easier to insert (and remove) when looking for bottlenecks
Web Development
ASP.NET	Validating Gender Dynamically using REGEX [Tip/Trick] 19 Apr 2012 Updated: 19 Apr 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 9,452 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "Validating gender dynamically using REGEX"
HTML	Resize Form To Fit DataGridView [Tip/Trick] 4 Jan 2016 Updated: 4 Jan 2016 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 34,238 Bookmarked: 3 Downloaded: 535 Please Sign up or sign in to vote. Attempts to resize a Form to show the entire table of a DataGridView
	Remove all the HTML tags and display a plain text only inside (in case XML is not well formed) [Tip/Trick] 17 Dec 2010 Updated: 19 Dec 2010 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: CPOL Views: 20,543 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. How about loading it into an XmlDocument and getting the InnerText? (Provided the HTML is well-formed XML, of course.)
	EnumConstrainedDictionary [Tip/Trick] 5 Jan 2016 Updated: 5 Jan 2016 Rating: 2.80/5 Votes: 2 Popularity: 0.84 Licence: CPOL Views: 10,051 Bookmarked: 1 Downloaded: 19 Please Sign up or sign in to vote. A Dictionary that is constrained to hold only the defined members of an enumeration

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

PIEBALDconsult

Software Developer (Senior)

United States

BSCS 1992 Wentworth Institute of Technology

Originally from the Boston (MA) area. Lived in SoCal for a while. Now in the Phoenix (AZ) area.

OpenVMS enthusiast, ISO 8601 evangelist, photographer, opinionated SOB, acknowledged pedant and contrarian

---------------

"I would be looking for better tekkies, too. Yours are broken." -- Paul Pedant

"Using fewer technologies is better than using more." -- Rico Mariani

"Good code is its own best documentation. As you’re about to add a comment, ask yourself, ‘How can I improve the code so that this comment isn’t needed?’" -- Steve McConnell

"Every time you write a comment, you should grimace and feel the failure of your ability of expression." -- Unknown

"If you need help knowing what to think, let me know and I'll tell you." -- Jeffrey Snover [MSFT]

"Typing is no substitute for thinking." -- R.W. Hamming

"I find it appalling that you can become a programmer with less training than it takes to become a plumber." -- Bjarne Stroustrup

ZagNut’s Law: Arrogance is inversely proportional to ability.

"Well blow me sideways with a plastic marionette. I've just learned something new - and if I could award you a 100 for that post I would. Way to go you keyboard lovegod you." -- Pete O'Hanlon

"linq'ish" sounds like "inept" in German -- Andreas Gieriet

"Things would be different if I ran the zoo." -- Dr. Seuss

"Wrong is evil, and it must be defeated." –- Jeff Ello

"A good designer must rely on experience, on precise, logical thinking, and on pedantic exactness." -- Nigel Shaw

“It’s always easier to do it the hard way.” -- Blackhart

“If Unix wasn’t so bad that you can’t give it away, Bill Gates would never have succeeded in selling Windows.” -- Blackhart

"Use vertical and horizontal whitespace generously. Generally, all binary operators except '.' and '->' should be separated from their operands by blanks."

"Omit needless local variables." -- Strunk... had he taught programming

Articles by PIEBALDconsult (Articles: 42, Tip/Tricks: 45)

Articles: 42, Tip/Tricks: 45

Average article rating: 4.12

.NET

General Programming

Programming Languages

Average blogs rating:

Average tips rating: 4.56

.NET

ADO.NET

Database Development

Desktop Programming

General Programming

IList

Operating Systems

Programming Languages

Stopwatch

Web Development

Average reference rating:

Average project rating: