Leave a Self-Deleting Message for your End Users

After you’re done working on someone’s computer after hours, have you ever wanted to leave them a message? Here’s a Slab-ette that lets ‘em know what they need to know, then goes away.

 

Add Command Line Arguments to Executables

Command line arguments are a very handy thing to have around. With them, you change connection strings, run special processing, anything. Here’s a quickie slab to get things rolling.

 

Import to SQL Server from Excel

Importing into SQL Server from Excel isn’t as trivial as it sounds, but this slab codes straight outta production code.

 

Who Has What Checked Out?!

SourceSafe.  Love it or hate it, we live with it.  Have you ever wondered what projects you have checked out? Or tried to get code, only to realize that the sloth we fired six months ago still has code checked out?  Here’s a slab that produces the report SS should have!

 

Recreate web traffic from IIS logs

If you ever need to recreate production web traffic in a different environment this code slab will come in handy.

 

SQL Server Title Case Function

Unfortunately, SQL Server doesn’t have a built in Title Case function.  Roll your own with this slab.

 

Sortable GridView WebControl

This custom GridView control extends the functionality of the ASP.NET GridView to implement sorting in a generic fashion. 

 

Make SQL Server Connection Strings Changable at Runtime

Strongly typed datasets do not allow you to alter connection strings at runtime by default.  These directions show how to change that behavior.

 

Visual Clue to Data Change

I sort of like showing the user which fields on a form have been changed, especially on forms with a lot going on.  Here’s how I do it.

 

Listing Excel Worksheets

This slab shows you how to list the worksheets of an Excel workbook in a combobox.