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,290 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: 28,622 Bookmarked: 28 Downloaded: 223 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: 47,069 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,032 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,001 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: 36,180 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: 150,899 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: 119,192 Bookmarked: 98 Downloaded: 944 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: 43,434 Bookmarked: 37 Downloaded: 825 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: 47,982 Bookmarked: 42 Downloaded: 507 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,362 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: 93,296 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: 33,821 Bookmarked: 30 Downloaded: 145 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: 19,921 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,052 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: 36,952 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,041 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,325 Bookmarked: 41 Downloaded: 248 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,600 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: 41,930 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: 48,602 Bookmarked: 20 Downloaded: 123 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,140 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,170 Bookmarked: 12 Downloaded: 451 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,136 Bookmarked: 45 Downloaded: 892 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,660 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: 66,261 Bookmarked: 28 Downloaded: 361 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: 47,714 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,470 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: 12,682 Bookmarked: 7 Downloaded: 195 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: 24,992 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: 87,422 Bookmarked: 43 Downloaded: 5,954 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: 41,711 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: 34,504 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: 39,490 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: 31,662 Bookmarked: 28 Downloaded: 334 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: 51,522 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: 49,775 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,214 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,411 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,162 Bookmarked: 20 Downloaded: 757 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,100 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: 40,943 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,061 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: 9,743 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,271 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: 15,503 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,680 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: 5,910 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: 26,152 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: 39,661 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: 19,401 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,370 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,640 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: 18,678 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,281 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: 24,396 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: 20,921 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,643 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,710 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: 8,861 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: 80,722 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: 30,171 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: 13,610 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,471 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: 31,952 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,390 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: 35,521 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,325 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,150 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: 17,454 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: 25,905 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,670 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,510 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: 24,551 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,200 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,243 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,390 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,250 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,790 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,047 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: 7,623 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,022 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,345 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: 12,820 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: 25,502 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,291 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: 33,267 Bookmarked: 3 Downloaded: 528 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: 19,671 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: 9,581 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: