Navigation

	Home Page
	What's New
	Index
	All Pages
	All Categories
	Leave Message

Favorites

	ASCII Code Table
	Class Library
	CSS Quick Reference
	Database Layout Script
	Date Calculations (SQL Svr)
	Foreign Key Pages
	LINQ Examples
	Printing Forms in SSRS
	Reg-Ex Quick Reference
	Windows API
	XSL Quick Reference

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

Home Page

Welcome

Credits

• Microsoft Access 2.0 Help file
• Guide to Data Access Objects, Chapter 6 of the Visual Basic 4.0 Professional Features manual, by Microsoft Press.
• Introduction to Oracle: SQL and PL/SQL, Student Guide, Volumes 1 and 2, Copyright © 1998, 1999 by Oracle Corporation.
• Microsoft SQL Server 7.0 Database Design, computer-based training by NETg
• SQL Server 7.0 Programming Unleashed, by John Papa, Matthew Shepker, et al., Copyright © 1999 by Sams Publishing.
• Intermediate Visual Basic 5.0 Programming, by Application Developers Training Company, 7151 Metro Blvd., Suite 175, Minneapolis, MN 55439, 1-800-578-2062.
• Advanced Visual Basic 5.0 Programming, Ibid.
• Microsoft Visual Basic 5.0 Help file.
• Beginning Visual C++ 6, by Ivor Horton, Copyright © by Wrox Press.
• Portions adapted from the now defunct website WWW.VBAPI.COM, Copyright © 1999-2001 by Paul Kuliniewicz.
  

Index

	(drafts)
	ActiveDirectoryQuery Class Creating Group Header Rows in a GridView Creating Templates - Visual Studio 2005 DeveloperPanel Class - ASP.NET Installer Attributes - NSIS Lookup Class - ASP.NET Paginate Function SqlBuilder Class SSRS Extender Cache Class Using Site Maps - ASP.NET
	(uncategorized)
	DB Tools Desktop Text App Home Page Index Main Page MRU (Most-Recently-Used) File Lists for Various Applications Report Publisher Add-In for Visual Studio 2005 Stopwatch What's New
	·Net Framework
	Adding A Description To A .Net Windows Service Building an Address by Concatenating Field Values Calculating Age from Date of Birth Changing XSL Code on the Fly - .NET Framework Class Library Pages ClickOnce App.Config Location - .Net Framework ClickOnce Bad Hash Error - .Net Framework Code Snippets - .NET Framework Command Text Generation from a SqlCommand Object ConnectionString Class - .NET Framework Converting A .Net DataSet To An ADODB Recordset Converting Between Hex and Integer Creating a COM object in .NET Declaration Modifiers - C# and VB.NET Displaying an XML DataSet in a DataGridView - .Net Framework Displaying an XSL Transformation in a Web Browser Control - .Net Framework Downloading a File - .NET Framework Dropping Emails onto a .NET Application Encrypting Web.Config Connection Strings - ASP.NET Extracting Data from a Grid Bound to a Typed DataSet- .Net Framework Extracting Images from Icons Format Codes Formatting Raw XML - Microsoft .Net Framework Indexers - C# LinkLabel Example LINQ Examples Looking Up a User in Active Directory - .Net Framework Lookup Class - ASP.NET MailServer Class Making an IEnumerable Enum - .Net Framework Numeral Class Optional Parameters in C# Reflection - .Net Framework Regular Expression Samples - .Net Framework Renaming an Assembly Sending Email - .Net Framework SendKeys Class Quick Reference Setting the Connection String for a TableAdapter SqlDatabase Base Class - SQL Server and .NET Framework String Extender Functions Using Custom Sections in an App.Config File - .Net Framework Using Embedded Resources - .Net Framework Using MSBuild Community Tasks to create an installer Using the ListView.ListViewItemSorter property - .Net Framework Using the SelectNodes Method with XML Namespaces - .Net Framework Windows Services in Visual Studio 2005 Standard Edition XML Encoding
	Algorithms
	Building an Address by Concatenating Field Values Calculating Age from Date of Birth Calculating Estimated Time of Completion - SQL Server Transforming a Name from First-Last to Last-First
	ASP·NET
	ActionValidator Class - ASP.NET An Extensive Examination of the DataGrid Web Control - ASP.Net Apostrophes - Correct Usage in HyperLinks AttachmentSelector Web Control - ASP.NET Building A Truly Dynamic Menu - ASP.NET CheckBoxList Class - ASP.NET CheckedListBox User Control - ASP.NET Class Library Pages CompareValidator Class - ASP.NET Comparison of the GridView, Repeater, and DataList Controls - ASP.NET ConfigMgr Class ConnectionString Class - .NET Framework Consuming Custom Controls in ASP.NET Creating a Reset Button - ASP.NET Creating Group Header Rows in a GridView CustomValidator Class DataTypeValidator Class - ASP.NET Date-Picker Source and Demo - JavaScript DeveloperPanel Class - ASP.NET Disable the Submit Button - jQuery Encrypting Web.Config Connection Strings - ASP.NET Extending Built-In Web Controls - ASP.NET Favorites Icon - Creating and Installing a FAVICON.ICO File FileUpload Control Sample - ASP.NET FileUploadExtender Class - ASP.NET GridView Class - ASP.NET GridViewExtender Class - ASP.NET GridViewRowExtender Class Journal Class and Logging - ASP.NET Life Cycle of a Page - ASP.NET Lookup Class - ASP.NET Membership API in ASP.NET Membership API with Windows Authentication and a Custom Role Provider - ASP.NET MyGridViewRow Class - ASP.NET Paging Data and the PageSelector Control Parser Class Publishing a Website in Visual Studio Express Edition QueryString Class Quick Reference - ASP.NET RegularExpressionValidator Class - ASP.NET RequiredFieldValidator Class - ASP.NET ServerVar Class - ASP.NET SessionVar Class - ASP.NET Setting the Default Button - ASP.Net Setting Up ASP.Net Settings Class - ASP.NET ShowLinkAs Page - ASP.NET Site-Root-Relative References - ASP.NET SqlDatabaseWeb Class - ASP.NET State Persistence - ASP.NET Taking Down a Website for Maintenance - ASP.NET TelephoneNumberTextBox Class - ASP.NET TextBox Class - ASP.NET Using Microsoft Access with ASP.NET Using MSBuild Community Tasks to create an installer Using Site Maps - ASP.NET Using the GridView Web Control - ASP.NET Validation Controls - ASP.NET ValidationSummary Class - ASP.NET Website Review - ASP.NET
	C and C-plus-plus
	C++ Data Types C++ Functions C++ Logic Flow Control C++ Operators C++ Pointers and References Console Input and Output - C++
	Class Library
	ActionValidator Class - ASP.NET ActiveDirectoryQuery Class AttachmentSelector Web Control - ASP.NET Cascading DropDownLists - jQuery CheckBoxList Class - ASP.NET Class Library Pages CompareValidator Class - ASP.NET ConfigMgr Class ConnectionString Class - .NET Framework Consuming Custom Controls in ASP.NET CustomValidator Class DataTypeValidator Class - ASP.NET DeveloperPanel Class - ASP.NET FileUploadExtender Class - ASP.NET GridView Class - ASP.NET GridViewExtender Class - ASP.NET GridViewRowExtender Class Journal Class and Logging - ASP.NET MailServer Class MyGridViewRow Class - ASP.NET Numeral Class Paging Data and the PageSelector Control Parser Class QueryString Class RegularExpressionValidator Class - ASP.NET RequiredFieldValidator Class - ASP.NET ServerVar Class - ASP.NET Settings Class - ASP.NET SqlDatabase Base Class - SQL Server and .NET Framework SqlDatabaseWeb Class - ASP.NET SSRS Extender Cache Class TelephoneNumberTextBox Class - ASP.NET TextBox Class - ASP.NET ValidationSummary Class - ASP.NET
	Code Sample
	Database Layout - SQL Server Database Object Counts - SQL Server FileUpload Control Sample - ASP.NET ProperCase Function - SQL Server SqlDatabase Base Class - SQL Server and .NET Framework Using MSBuild Community Tasks to create an installer
	DB2
	Special Registers - DB2 SQL Formatting System Tables - DB2 Useful Commands - DB2
	Design Patterns
	Desktop Applications
	General Information
	ASCII Codes Common Software Tests Converting Between Hex and Integer Deployment Checklist Recurrence Patterns States and Their Postal Codes
	HTML, CSS, and JavaScript
	AJAX Example - JavaScript Apostrophes - Correct Usage in HyperLinks Cascading DropDownLists - jQuery Cascading Style Sheets Quick Reference Cascading Style Sheets Reference Color Table - HTML ConfirmExt Function - JavaScript Copying Text to the Windows Clipboard - JavaScript Creating a Reset Button - ASP.NET Creating Rounded Corners - Cascading Style Sheets Date Validation - JavaScript Date-Picker Source and Demo - JavaScript Disable the Submit Button - jQuery Exception-Handling in JavaScript Favorites Icon - Creating and Installing a FAVICON.ICO File Flyouts - JavaScript Image Maps - HTML JavaScript Code Snippets Javascript Marquee Modal Dialogs - JavaScript QueryStrings in JavaScript Special Characters - HTML Validation Controls - ASP.NET Web Browser Differences with CSS Window Object's Open Method - JavaScript
	Jasinski Software
	Jasinski Visual Studio 2005 Add-In Outline Formatting Provider - Jasinski Software Web Notebook Registry Entries - Jasinski Software What's-New Formatting Provider - Jasinski Software
	Lotus Notes
	Managing Rules - Lotus Notes
	Microsoft Office
	Accessing Email Messages - Outlook Automation Command Line Options for Various Applications Downloading Email from an Exchange Server - Microsoft Outlook Enabling Security - Microsoft Access HandleNotInList Subroutine - Access Killing Stray Excel References - Excel Automation Linked Server Setup from SQL Server to a Microsoft Access Database NetWorkDays Function - SQL Server Pushing Data To Excel From SQL Server Security Principles - Microsoft Access Specifying Order of Address Books for Name Resolution - Microsoft Outlook WorkDay Function - SQL Server
	MSBuild
	Using MSBuild Community Tasks to create an installer
	NSIS
	Installer Attributes - NSIS NSIS Quick Reference Pages - NSIS
	Oracle
	Cursor Quick Reference - Oracle Function Quick Reference - Oracle PL/SQL Quick Reference - Oracle Sequence Objects Quick Reference - Oracle SQL Formatting SQL*Plus Commands Quick Reference - Oracle SqlBuilder Class System Tables - Oracle Tips and Tricks - Oracle
	PostScript
	Practical PostScript
	Quick Reference
	Cascading Style Sheets Quick Reference Cursor Quick Reference - Oracle Function Quick Reference - Oracle NSIS Quick Reference PL/SQL Quick Reference - Oracle Quick Reference - ASP.NET Quick Reference - SQL Server Regular Expressions Quick Reference Security in SQL Server SendKeys Class Quick Reference Sequence Objects Quick Reference - Oracle SQL*Plus Commands Quick Reference - Oracle Trigger Quick Reference - SQL Server T-SQL Quick Reference - SQL Server XSL Quick Reference
	Real Player
	Basics of a Skin - Real Player Skin.ini File - Real Player
	Regular Expressions
	Regular Expression Samples - .Net Framework Regular Expressions Regular Expressions Quick Reference Using Regular Expressions In The Replace Dialog - Visual Studio
	ScrewTurn Wiki
	File Formats - ScrewTurn Wiki Moving a ScrewTurn Wiki Navigation Paths - ScrewTurn Wiki Outline Formatting Provider - Jasinski Software Page Editing - ScrewTurn Wiki Page Transclusion - ScrewTurn Wiki Snippets - ScrewTurn Wiki Tables - ScrewTurn Wiki What's-New Formatting Provider - Jasinski Software
	SQL Server
	Add Audit Fields to Every Table - SQL Server Add-Ins - SQL Server ALTER TABLE Statement Examples - SQL Server Black Art Of Writing A SQL Server Management Studio 2005 Add-In Bulk Loading a Table without Taking it Offline - SQL Server Calculating a Running Total - SQL Server Calculating Estimated Time of Completion - SQL Server Case and Accent Sensitivity in SQL Server Changing the Default Database - SQL Server Class Library Pages CLR Integration - SQL Server Code Object Differences Between Databases - SQL Server Code Objects Line Counter - SQL Server CodeObjectsContaining Function - SQL Server Command Text Generation from a SqlCommand Object Configuring SQL Server Authentication Mode - SQL Server 2005 Connection Strings - SQL Server CONVERT Function Data Formats - SQL Server Copy Every Foreign Key - SQL Server Counter Table - Generating one On-The-Fly - SQL Server Cracking SQL Server Passwords Creating a Linked Server with an Alias - SQL Server Data Migration without SSIS Database Dependencies - SQL Server Database Layout - SQL Server Database Object Counts - SQL Server Database Size - SQL Server Date Calculations - SQL Server DateAdd, DateDiff, and DatePart Functions - SQL Server DBCC FREEPROCCACHE - SQL Server DDL Trigger Sample - SQL Server Disable Every Foreign Key - SQL Server Drop Every Database Object - SQL Server Drop Every Default Constraint - SQL Server Drop Every Foreign Key - SQL Server Enabling Remote Connections - SQL Server 2005 Express Environment - SQL Server Every Date in a Month - SQL Server Execute As DBO - SQL Server Expanding Tab Characters - SQL Server Extend Functionality in SQL Server 2005 Management Studio with Add-ins File Extension Calculation - SQL Server Finding a Column on a Server - SQL Server Finding an Object on a Server - SQL Server Finding Database Compatibility Level - SQL Server Foreign-Key Pages - SQL Server Generating XML from Recursive, Hierarchical Data Grant Execute Permission to Everyone - SQL Server Grant VIEW DEFINITION Permission Across Schemas - SQL Server Granting Execute Rights to Public - SQL Server Job History - SQL Server Linked Server Setup from SQL Server to a Microsoft Access Database List Database Permissions - SQL Server List Every Database Object - SQL Server List Every Foreign Key - SQL Server List Every Index - SQL Server List Tables in Dependency (Foreign Key) Order - SQL Server Multi-Row String Concatenation - SQL Server NetWorkDays Function - SQL Server NULL versus NULL - SQL Server Ordinal Function - SQL Server Paginate Function Paging Data and the PageSelector Control Percentile Calculation PIVOT and UNPIVOT Syntax - SQL Server ProperCase Function - SQL Server Pushing Data To Excel From SQL Server Querying Hierarchical Data - SQL Server Quick Reference - SQL Server Regular Expressions Removing Unwanted Characters from Data - SQL Server ROW_NUMBER() Function - SQL Server Schema Differences Between Databases - SQL Server Security in SQL Server Security Permission Differences Between Databases - SQL Server Selecting Top Row In Each Group Session ID - SQL Server Setting Maximum Recursions in a Common Table Expression - SQL Server Severe Error Occurred - SQL Server Splitting Text - SQL Server SQL Formatting SqlBuilder Class SqlDatabase Base Class - SQL Server and .NET Framework SqlDatabaseWeb Class - ASP.NET Stored Procedure Template - SQL Server Tab Stops - SQL Server Managment Studio Table Row Counts - SQL Server Tables Used by Stored Procedures - SQL Server Temp Tables and How to Drop Them from Script - SQL Server Transferring Data without SSIS (SQL Server Integration Services) - SQL Server Transforming a Name from First-Last to Last-First Trigger Quick Reference - SQL Server T-SQL Quick Reference - SQL Server Undocumented SQL Server 2005 Stored Procedures Updating with a Self-Join - SQL Server Using FOR XML Clause - SQL Server Using NULL to Mean "All" Using SP_AddLinkedServer - SQL Server Using SQL-CLR to create a Regular Expression Replace function Using the CROSS APPLY Syntax - SQL Server Using the OVER Keyword - SQL Server Using the XML Data Type - SQL Server Word Wrapping - SQL Server WorkDay Function - SQL Server XOR Function - SQL Server
	SQL Server System Tables
	log_shipping_databases System Table - SQL Server 2000 log_shipping_monitor System Table - SQL Server 2000 log_shipping_plan_databases System Table - SQL Server 2000 log_shipping_plan_history System Table - SQL Server 2000 log_shipping_plans System Table - SQL Server 2000 log_shipping_primaries System Table - SQL Server 2000 log_shipping_secondaries System Table - SQL Server 2000 sysalerts System Table - SQL Server 2000 syscacheobjects System Table - SQL Server 2000 syscategories System Table - SQL Server 2000 syscolumns System Table - SQL Server 2000 syscomments System Table - SQL Server 2000 sysconstraints System Table - SQL Server 2000 sysdepends System Table - SQL Server 2000 sysdownloadlist System Table - SQL Server 2000 sysfilegroups System Table - SQL Server 2000 sysfiles System Table - SQL Server 2000 sysforeignkeys System Tables - SQL Server 2000 sysfulltextcatalogs System Table - SQL Server 2000 sysindexes System Table - SQL Server 2000 sysindexkeys System Table - SQL Server 2000 sysjobhistory System Table - SQL Server 2000 sysjobs System Table - SQL Server 2000 sysjobschedules System Table - SQL Server 2000 sysjobservers System Table - SQL Server 2000 sysjobsteps System Table - SQL Server 2000 syslockinfo System Table - SQL Server 2000 syslogins System Table - SQL Server 2000 sysmembers System Table - SQL Server 2000 sysnotifications System Table - SQL Server 2000 sysobjects System Table - SQL Server 2000 sysoperators System Table - SQL Server 2000 syspermissions System Table - SQL Server 2000 sysprocesses System Table - SQL Server 2000 sysprotects System Table - SQL Server 2000 sysreferences System Table - SQL Server 2000 systargetservergroupmembers System Table - SQL Server 2000 systargetservergroups System Table - SQL Server 2000 systargetservers System Table - SQL Server 2000 systaskids System Table - SQL Server 2000 System Tables - SQL Server 2000 systypes System Table - SQL Server 2000 sysusers System Table - SQL Server 2000
	SSIS (SQL Server Integration Services)
	Hiding Excel Sheets from a Script Task - SQL Server Integration Services Merge Join Transformations - SQL Server Integration Services
	SSRS (SQL Server Reporting Services)
	Chart Terminology - SQL Server Reporting Services Common Functions - SQL Server Reporting Services Custom Aggregates in a Matrix Custom Assemblies - SQL Server Reporting Services Deploying a Report via Report Server's Web Service - SSRS GreenBar in Reports - SSRS Paginate Function Printing Forms - SSRS Printing Forms by Consolidating SQL - SSRS Printing Forms using a Shared Dictionary - SSRS Printing Forms using Report Parameters - SSRS RDL File's XML Namespaces Report File Format - SQL Server 2005 Report Server URLs - SQL Server Reporting Services Setting Up A Report for Email Delivery - SQL Server Reporting Services SSRS Extender Cache Class
	Visual Basic 6
	Accessing Email Messages - Outlook Automation ActiveX Data Objects (ADO) with Visual Basic ActiveX DLL Registry Entries ActiveX Objects and Controls - Visual Basic 6.0 COM+ Development COM+ Server Setup Creating a COM object in .NET Miscellaneous Visual Basic Topics Polymorphism in Visual Basic 6.0 Procedure Attributes - VB6 Safely Remove Hardware Version Compatibility
	Visual Studio, Source Safe, and TFS
	Add-Ins in Visual Studio Automatically Deploying an Application - Visual Studio Creating a COM object in .NET Creating a Website - Visual Studio 2005 Creating Templates - Visual Studio 2005 Difference Between Class Library Project and SQL CLR Project How To Make SourceSafe Keyword Expansion Work In Text Docs Macro to Clear the Immediate Window - Visual Studio 2005 Publishing a Website in Visual Studio Express Edition Team Foundation Server Basics Using ClickOnce to Deploy an App that Dynamically Loads DLLs Using MSBuild Community Tasks to create an installer Using Regular Expressions In The Replace Dialog - Visual Studio Visual SourceSafe Analyzer Working Directories - Team Foundation Server
	Windows (OS, IE, IIS, and MSMQ)
	Adding Find-Target to Context Menu BAT File Programming Changing the Drive Letter for a USB Device Clearing Unwanted Entries from Explorer's New Menu Command Line Options for Various Applications Command Prompt Entry in a Folder's Shortcut Menu Creating Custom Explorer Bars - Internet Explorer Disabling JavaScript - Internet Explorer EXE File Fix Logging Off Another User - Windows Vista Performance Optimization in MSMQ Safely Remove Hardware Script to Create a Virtual Directory - IIS Special Folders - Windows Useful Windows Registry Entries Windows Registry Settings for Internet Explorer's Proxy Settings Windows Search - Adding File Types
	Windows API
	BitBlt Function - Windows API CloseHandle Function - Windows API Constants - Windows API CopyMemory Function - Windows API CreateFile Function - Windows API CreateFileMapping Function - Windows API CreateRemoteThread Function - Windows API DeviceIoControl Function - Windows API DIRECTORY_BASIC_INFORMATION Struct - Windows API DuplicateHandle Function - Windows API EnumChildWindows Function - Windows API GENERIC_MAPPING Struct - Windows API GetClassName Function - Windows API GetCurrentProcess Function - Windows API GetCursorPos Function - Windows API GetDC Function - Windows API GetDesktopWindow Function - Windows API GetExitCodeThread Function - Windows API GetFileSizeEx Function - Windows API GetKeyState Function - Windows API GetLogicalDriveStrings Function - Windows API GetMappedFileName Function - Windows API GetModuleHandle Function - Windows API GetNamedPipeHandleState Function - Windows API GetParent Function - Windows API GetProcAddress Function - Windows API GetVersion Function - Windows API GetWindowText Function - Windows API GetWindowTextLength Function - Windows API GetWindowThreadProcessId Function - Windows API GlobalAlloc Function - Windows API GlobalFree Function - Windows API GlobalLock Function - Windows API MapViewOfFile Function - Windows API mciGetDeviceIDA Function - Windows API mciSendString Function - Windows API midiOutGetVolume Function - Windows API midiOutSetVolume Function - Windows API mixerClose Function - Windows API MIXERCONTROL Struct - Windows API MIXERCONTROLDETAILS Struct - Windows API MIXERCONTROLDETAILS_UNSIGNED Struct - Windows API mixerGetControlDetailsA Function - Windows API mixerGetLineControlsA Function - Windows API mixerGetLineInfo Function - Windows API MIXERLINE Struct - Windows API MIXERLINECONTROLS Struct - Windows API mixerOpen Function - Windows API mixerSetControlDetails Function - Windows API NtClose Function - Windows API NtOpenDirectoryObject Function - Windows API NtQueryObject Function - Windows API NtQuerySymbolicLinkObject Function - Windows API NtQuerySystemInformation Function - Windows API OBJECT_ALL_TYPES_INFORMATION Struct - Windows API OBJECT_ATTRIBUTES Struct - Windows API OBJECT_BASIC_INFORMATION Struct - Windows API OBJECT_HANDLE_ATTRIBUTE_INFORMATION Struct - Windows API OBJECT_NAME_INFORMATION Struct - Windows API OBJECT_TYPE_INFORMATION Struct - Windows API OpenProcess Function - Windows API POINT_TYPE Struct - Windows API QueryDosDevice Function - Windows API ReleaseDC Function - Windows API SendMessage Function - Windows API SetForegroundWindow Function - Windows API SetWindowText Function - Windows API SYSTEM_HANDLE_INFORMATION Struct - Windows API UNICODE_STRING Struct - Windows API UnmapViewOfFile Function - Windows API Using the Windows API in .Net Languages WaitForSingleObject Function - Windows API ZeroMemory Function - Windows API
	Windows Registry
	ActiveX DLL Registry Entries Adding Find-Target to Context Menu Clearing Unwanted Entries from Explorer's New Menu COM DLL Location - Windows Registry Command Prompt Entry in a Folder's Shortcut Menu Enabling Yahoo Email for the MailTo Protocol Registry Entries to Create Context Menu for DLL and OCX Files Useful Windows Registry Keys Windows Registry Settings for Internet Explorer's Proxy Settings Windows Search - Adding File Types
	XML, XSL, and XPath
	Changing XSL Code on the Fly - .NET Framework Code Snippets - .NET Framework Displaying an XML DataSet in a DataGridView - .Net Framework Displaying an XSL Transformation in a Web Browser Control - .Net Framework Formatting Raw XML - Microsoft .Net Framework Generating XML from Recursive, Hierarchical Data URL Encoding in XSL Using FOR XML Clause - SQL Server Using the SelectNodes Method with XML Namespaces - .Net Framework Using the XML Data Type - SQL Server XML Encoding XSL Quick Reference