Auto Generating a Data Dictionary – Part 2

This slab takes the data gathered in Part 1 and turns it into an Excel workbook. Very useful for most needs!

 

Notify Icon Template

Here’s a quick slab to bootstrap you into using system tray icons…

 

Enumerate the Properties of an Object

Have ever wanted to enumerate the properties of and object?  Here’s a slab that does just that.

 

Manually Updating a ClickOnce Deployed Application

Under certain circumstances, you may not want an app to automagically update itself.  This slab shows how to do it manually.

 

The Missing Forms Collection

In VB6 we had Me.Forms; what happened? People stopped needing it, I guess. If you do though, here’s a slab to get you through.

 

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.

 

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.