Navigation

	Home Page
	Index
	All Pages

Contributor Links

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

Other Wiki Sections

Software

Home Page

Welcome¶

Index¶

	(drafts)
	ActiveDirectoryQuery Class Creating Group Header Rows in a GridView Creating Templates - Visual Studio 2005 Data Modelling Standards DeveloperPanel Class - ASP.NET Installer Attributes - NSIS Lookup Class - ASP.NET MVC Template - ASP.NET MVC Paginate Function SqlBuilder Class SSRS Extender Cache Class Using Site Maps - ASP.NET Validation Notes - ASP.NET MVC
	(Favorites)
	ASCII Codes Cascading Style Sheets Quick Reference Class Library Pages Code Snippets - JavaScript Data Modelling Standards Database Layout - SQL Server Developer Primer - Sitecore Extensions - jQuery Foreign-Key Pages - SQL Server LINQ Examples Quick Reference - JavaScript Quick Reference - jQuery Regular Expressions Quick Reference Schema Change Scripts - SQL Server Table Row Counts - SQL Server Telerik Grid Quick Reference XSL Quick Reference
	(uncategorized)
	DB Tools Desktop Text App Determining Geolocation (Latitude and Longitude Coordinates) from Google Maps Enforcing Required Fields in a PDF Form - ASP.NET and ActivePDF Home Page Index Main Page Report Publisher Add-In for Visual Studio 2005 Report Server Object Enumeration - SSRS SqlCommand and SqlConnection Objects 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 First Entity Framework - .NET Framework Code First Shortcomings Code Snippets - .NET Framework Command Text Generation from a SqlCommand Object Common, Useful Exception Classes ConnectionString Class - .NET Framework Converting A .Net DataSet To An ADODB Recordset Converting Between Hex and Integer Creating a COM object in .NET Creating a WCF Self-Hosted Service Data Annotation - .NET Framework Database Command Timeouts: Performance Differences between .NET and Management Studio Database-Table-Wrapper Class Code Generator 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 Downloading a Web Page Programmatically - .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 GZip Error with Code First - .NET Framework IAuditable Interface - .NET Framework Indexers - C# LinkLabel Example LINQ Examples LoaderExceptions Property - .NET Framework Looking Up a User in Active Directory - .Net Framework Lookup Class - ASP.NET LookupItem Class for DropDownLists - .NET Framework MailServer Class Making an IEnumerable Enum - .Net Framework Numeral Class Optional Parameters in C# Ordinal Function - .NET Framework Printing a Variable Name and Value - .NET Framework Reading Excel Files with OLEDB 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 SQL Statement used by LINQ SqlDatabase Base Class - SQL Server and .NET Framework Streams - .NET Framework String Extender Functions Thumbnails - Creating in C# Time Database Columns in .NET 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 Windows Taskbar Wrapper Class - C# XML Encoding
	Algorithms
	Annuity Calculations Building an Address by Concatenating Field Values Calculating Age from Date of Birth Estimated Time of Completion Calculation - C# Estimated Time of Completion Calculation - SQL Server Transforming a Name from First-Last to Last-First
	Android
	Android Versions and API Levels Code Snippets - Android Setting Up a PC for Android Development
	ASP·NET MVC
	AJAX Example - jQuery and JavaScript Changing Password without the Old Password - ASP.NET Membership API Connection Strings Externalized - ASP.NET Cookies - ASP.NET Custom AuthorizeAttribute - ASP.NET MVC Custom Controller Factory - Putting Controllers in an External Assembly - ASP.NET MVC CustomValidation Attribute - ASP.NET Database-Table-Wrapper Class Code Generator Excel Export - ASP.NET MVC Formatting Field Values - ASP.NET MVC GZip Error with Code First - .NET Framework HOSTS File Location IAuditable Interface - .NET Framework jQuery-UI Tab Code Generator LoaderExceptions Property - .NET Framework LookupItem Class for DropDownLists - .NET Framework Menu System based on User Roles MVC Basics - ASP.NET MVC MVC Template - ASP.NET MVC reCaptcha Implementation in MVC3 - ASP.NET MVC Remote Connections to IIS in Windows 7 Taking Down a Website for Maintenance - ASP.NET Uploading Files - ASP.NET MVC2 Validation Notes - ASP.NET MVC View Engine (Razor and ASPX) Syntax - ASP.NET MVC
	ASP·NET Web Forms
	ActionValidator Class - ASP.NET AJAX Coding in ASP.NET Web Forms 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 Changing Password without the Old Password - ASP.NET Membership API 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 Connection Strings Externalized - ASP.NET ConnectionString Class - .NET Framework Consuming Custom Controls in ASP.NET Cookies - ASP.NET Creating a Reset Button - ASP.NET Creating Group Header Rows in a GridView CustomValidation Attribute - ASP.NET CustomValidator Class Data Annotation - .NET Framework Database Command Timeouts: Performance Differences between .NET and Management Studio DataTypeValidator Class - ASP.NET Date-Picker Source and Demo - JavaScript DeveloperPanel Class - ASP.NET Disable the Submit Button - jQuery Downloading a Web Page Programmatically - .NET Framework 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 GZip Error with Code First - .NET Framework HOSTS File Location IAuditable Interface - .NET Framework Internet Explorer Quirks Journal Class and Logging - ASP.NET jQuery-UI Tab Code Generator Life Cycle of a Page - ASP.NET LoaderExceptions Property - .NET Framework Lookup Class - ASP.NET LookupItem Class for DropDownLists - .NET Framework Membership API in ASP.NET Membership API with Windows Authentication and a Custom Role Provider - ASP.NET Menu System based on User Roles Merging a Code-Behind File into Its APX File Merging Reports - SSRS MyGridViewRow Class - ASP.NET Paging Data and the PageSelector Control Parser Class Password Generator - ASP.NET PDF Generation via RDLC Report File Publishing a Website in Visual Studio Express Edition QueryString Class Quick Reference - ASP.NET RegularExpressionValidator Class - ASP.NET Remote Connections to IIS in Windows 7 Required Field Validation (Conditionally) - ASP.NET RequiredFieldValidator Class - ASP.NET Security - Showing and Hiding Page Elements Based on User Role 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 Sitecore Extensions Methods Site-Root-Relative References - ASP.NET SqlDatabaseWeb Class - ASP.NET State Persistence - ASP.NET Streaming a File from a Web Page - ASP.NET Taking Down a Website for Maintenance - ASP.NET TelephoneNumberTextBox Class - ASP.NET Telerik Grid Quick Reference TextBox Class - ASP.NET Thumbnails - Creating in C# Trapping MaxRequestLengthExceeded 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 Validation Errors with AJAX Calls - 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 Password Generator - ASP.NET 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 Generator
	Database-Table-Wrapper Class Code Generator jQuery-UI Tab Code Generator
	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
	DotNetNuke
	HTML Content in the Database - DotNetNuke
	General Information
	Annuity Calculations ASCII Codes Common Software Tests Converting Between Hex and Integer Default Browser Deployment Checklist HOSTS File Location Recurrence Patterns States and Their Postal Codes Telephone Keypad Types of Numbers XFDL File Decoding
	HTML and CSS
	Apostrophes - Correct Usage in HyperLinks Cascading Style Sheets Quick Reference Cascading Style Sheets Reference Color Table - HTML Creating a Reset Button - ASP.NET Creating Rounded Corners - Cascading Style Sheets Disabling Autocomplete - HTML5 Favorites Icon - Creating and Installing a FAVICON.ICO File Fixed Navigation Bar - CSS Hand Cursor - CSS HOSTS File Location Image Maps - HTML Internet Explorer Quirks MailTo Protocol - Avoiding Spammers Read-Only Fields - Displaying as Disabled - CSS Remote Connections to IIS in Windows 7 Rotating Text with CSS Special Characters - HTML Taking Down a Website for Maintenance - ASP.NET Target Attribute - HTML/JavaScript Uploading Files - ASP.NET MVC2 Validation Controls - ASP.NET Web Browser Differences with CSS
	iPad
	Tips and Tricks - iPad
	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
	JavaScript and jQuery
	AJAX Example - jQuery and JavaScript Apostrophes - Correct Usage in HyperLinks Cascading DropDownLists - jQuery Characters Left - JavaScript Checklist in HTML and jQuery Code Snippets - JavaScript ConfirmExt Function - JavaScript Copying Text to the Windows Clipboard - JavaScript Current Time - JavaScript Date Formatting - JavaScript Date Validation - JavaScript Date-Picker Source and Demo - JavaScript Disable the Submit Button - jQuery Exception-Handling in JavaScript Extensions - jQuery Flyouts - JavaScript Helper Functions - jQuery Internet Explorer Quirks jQuery-UI Tab Code Generator MailTo Protocol - Avoiding Spammers Marquee - Javascript Modal Dialogs - JavaScript Namespacing in JavaScript QueryStrings in JavaScript Quick Reference - JavaScript Quick Reference - jqGrid Quick Reference - jQuery Regular Expressions in JavaScript Security - Showing and Hiding Page Elements Based on User Role Sorting - JavaScript TextArea MaxLength Enforcement - jQuery Window Object's Open Method - JavaScript Words Left - JavaScript
	LINQ
	LINQ Examples SQL Statement used by LINQ Stored Procedures with Entity Framework
	Lotus Notes
	Managing Rules - Lotus Notes
	MCTS Exam 70-515
	Chapter 01: Introducing ASP.NET 4.0 - MCTS Exam 70-515 Chapter 02: Using Master Pages, Themes, and Caching - MCTS Exam 70-515 Chapter 03: Handling Events and Managing State - MCTS Exam 70-515 Chapter 04: Using Server Controls - MCTS Exam 70-515 Chapter 05: Input Validation and Site Navigation - MCTS Exam 70-515 Chapter 06: Globalization and Accessibility - MCTS Exam 70-515
	Microsoft Office
	Accessing Email Messages - Outlook Automation Annuity Calculations Coalesce Function - Microsoft Access Command Line Options for Various Applications CreateField Script - Microsoft Access CreateLinkedTable Script - Microsoft Access CreateRelation Script - Microsoft Access CreateTable Script - Microsoft Access Downloading Email from an Exchange Server - Microsoft Outlook Enabling Security - Microsoft Access Format Property - Microsoft Access HandleNotInList Subroutine - Access Killing Stray Excel References - Excel Automation Linked Server Setup from SQL Server to a Microsoft Access Database Linked Tables - Reattaching Programmatically NetWorkDays Function - SQL Server Phone Number Best Practices - Microsoft Access PrimoPDF - Getting Started Pushing Data To Excel From SQL Server Reading Excel Files with OLEDB Ribbon Creation in Access 2007 Searching All Database Objects - Microsoft Access 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 Data Modelling Standards 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 and PDF
	IFilter for PDF Files Merging Reports - SSRS PDFJOIN - Joining PDF Files 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 - JavaScript Quick Reference - jqGrid Quick Reference - jQuery 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 Telerik Grid Quick Reference 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 in JavaScript Regular Expressions in SQL Server 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
	Sitecore
	Best Practices and Pitfalls to Avoid - Sitecore Code Snippets - Sitecore Custom Editors - Sitecore Developer Primer - Sitecore Error: Can't Login to Admin Site - Sitecore Hierarchy of Items - Sitecore Installing Sitecore Media Item ID versus File Path - Sitecore Media Library Item Creation - Sitecore Multi-Site Implementation - Sitecore Package Installation - Sitecore Quick Reference - Sitecore Admin Interface Security Overview - Sitecore Sitecore Extensions Methods Sitecore URLs Sublayout Renaming - Sitecore Sublayout Usage - Sitecore Template Usage - Sitecore Unversioned versus Shared - Sitecore
	SQL Server
	Add Audit Fields to Every Table - SQL Server Add-Ins - 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 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 Common Option Settings Concat Function - SQL Server Configuring SQL Server Authentication Mode - SQL Server 2005 Connection Strings - SQL Server CONVERT Function Date Formats - SQL Server Copy Every Foreign Key - SQL Server Counter Table - Generating one On-The-Fly - SQL Server CountWords - SQL Server Cracking SQL Server Passwords Creating a Linked Server with an Alias - SQL Server Data Migration without SSIS Data Migration without SSIS (for a single table) - SQL Server Data Modelling Standards Database Command Timeouts: Performance Differences between .NET and Management Studio Database Dependencies - SQL Server Database Layout - SQL Server Database Mirroring Setup - SQL Server Database Object Counts - SQL Server Database Size - SQL Server Database-Table-Wrapper Class Code Generator Date Calculations - SQL Server DateAdd, DateDiff, and DatePart Functions - SQL Server DBCC FREEPROCCACHE - SQL Server DDL Syntax - SQL Server DDL Trigger Sample - SQL Server Deploying a Database - SQL Server Disable Every Foreign Key - SQL Server Drop Database with Active Connections - 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 Estimated Time of Completion Calculation - 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 Extended Properties Stored Procedure - SQL Server File Name Parsing Calculations - 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 Generation from Common Column Names - SQL Server Foreign-Key Pages - SQL Server Friday the 13th Analysis in 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 Hierarchies - SQL Server Index Columns - SQL Server Installing SQL Server Management Studio Express 2008 Job History - SQL Server jQuery-UI Tab Code Generator 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 Lorem Ipsum Generator - SQL Server Menu System based on User Roles Multi-Row String Concatenation - SQL Server NetWorkDays Function - SQL Server NULL versus NULL - SQL Server Ordinal Function - SQL Server PadLeft 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 Quick Reference - SQL Server Randomly Generate a List of Names - SQL Server Regular Expressions in SQL Server Removing Unwanted Characters from Data - SQL Server Reseeding an Identity Column - SQL Server ROW_NUMBER() Function - SQL Server Schema Change Scripts - SQL Server Schema Differences Between Databases - SQL Server Scripting Options - 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 sp_who2 Substitute - SQL Server sp_who2 with Filtered Results - 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 Time Database Columns in .NET Transforming a Name from First-Last to Last-First Trigger Quick Reference - SQL Server Triggers - List All - 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
	Index Columns - SQL Server 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 Data-Driven Subscriptions - SSRS Deploying a Report via Report Server's Web Service - SSRS Environment - SQL Server GreenBar in Reports - SSRS Merging Reports - SSRS Multi-Value Parameters and Stored Procedures - SSRS Paginate Function PDF Generation via RDLC Report File 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 Repeating Row Headers - SSRS 2010 Report File Format - SQL Server 2005 Report Server URLs - SQL Server Reporting Services Setting Up A Report for Email Delivery - SQL Server Reporting Services Shortcomings - SSRS 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 Read Entire File Contents - VB6 Safely Remove Hardware Version Compatibility
	Visual Studio and Developer Tools
	Add-Ins in Visual Studio Automatically Deploying an Application - Visual Studio Changing Visual Studio 2012 Menus to Mixed Case Common Option Settings Conditional Compilation - Visual Studio Creating a COM object in .NET Creating a Subversion Repository 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 Installer Projects - Visual Studio Installing SQL Server Management Studio Express 2008 Macro to Clear the Immediate Window - Visual Studio 2005 Publishing a Website in Visual Studio Express Edition Renaming a Computer - TFS Setting Up a PC for Android Development Team Foundation Server Basics TFS Usage in SQL Server Management Studio Transforming External Configuration Files - Visual Studio 2010 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 Web.Config Transformations - Visual Studio 2010 Web.Config Transformations with Web Setup Project - Visual Studio 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 Default Browser Disabling JavaScript - Internet Explorer EXE File Fix Files Ready to be Written to the Disc - Folder Location FTP Setup on IIS 7 HOSTS File Location Logging Off Another User - Windows Vista Performance Optimization in MSMQ Remote Connections to IIS in Windows 7 Safely Remove Hardware Script to Create a Virtual Directory - IIS Special Folders - Windows Taking Down a Website for Maintenance - ASP.NET 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 GetUserName 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 Windows Taskbar Wrapper Class - C# WNetGetConnection - Resolve a UNC Path 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 MRU (Most-Recently-Used) File Lists for Various Applications 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
	Building XML Programmatically 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 XSL to Display Raw XML

Recent Changes¶

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.