.NET Howtos

• A light focus on SQL Profiler
  
• Accessing the inbox through MAPI using C# .NET
  
• C# : Sharing something for the toolstripprogressbar.
  
• C#: Setting Icons
  
• Capture Screen (The Express Way in 5 Lines)
  
• Connect Remote SQL instance from Vista Client
  
• Convert Pic file (jpg, bmp, etc) to Icon c#
  
• Creating SQL Stored Procedures
  
• CSV Bulk insert and Delete
  
• Error encountered while working with FAXCOM.dll
  
• Export complete database to excel file
  
• FTP File Transfer get() and put() Files Example
  
• Fundamental difference between Visual Source Safe (VSS) and VSTS Team Foundation
  
• How to build long Regular Expression
  
• How to check if a textbox contains a number
  
• How to create classes that can be Serialized by using XML Serialization:
  
• How to find the status of fax operation using FAXCOM.dll
  
• How to play a wave file on the phone (C#) - PART I
  
• How to play a wave file on the phone (C#) - PART II
  
• How to play a wave file on the phone (C#) - PART III
  
• How To Use A Database In Your Program
  
• How To: Use Dynamic Controls in ASP.NET
  
• How To: Use Events In .NET
  
• Make all the rows height even in DataGridView in .Net 2.0
  
• Multi-targeting (.Net 3.5)
  
• QueryString Manipulation Using VB.NET
  
• Quick Reference on how to send an email using .NET
  
• Quick Review on Delegates
  
• Removing all spaces from inside a string value in VB.NET
  
• Row numbers and alternate colors to a Continuous Form
  
• Serviced Component
  
• Sessions - How To Pass Information Between Web Pages
  
• store the mails from Outlook database to Local database
  
• String and Stringbuilder Usage
  
• Subfolders that have specific characteristics in .Net 2005:
  
• Understanding Connection Pooling
  
• Use CallByName in C#
  
• Using CommandArgument to find the database table record_id for a datagrid row
  
• VB.NET Class File For Zip a File or Directory
  
• VB.NET SQL-powered Sitemap
  
• Visual Studio 2003 HTTP/1.1 500 Internal Server Error
  
• What is .NET? Why do I need the Framework?
  
• Write/Read A Text File - C#
  

Coldfusion Howtos

• Coldfusion Tips and Tricks
  
• How to send mail using Coldfusion
  
• How to upload a file in Coldfusion
  
• Links to popular tutorials
  

C / C++ Howtos

• Arrays Revealed
  
• Bubble Sort
  
• Class 1: So You Wanna Learn Programming... (In C++)
  
• Class 2: Hello World. All Right, Let's Do This!
  
• Class 3: Hello, Variables!
  
• Design Patterns: State
  
• Design Patterns: The Singleton
  
• Design Patterns: Visitor
  
• Designing for Polymorphism in C++
  
• Handle Classes: The Smart Pointer
  
• How to Parse a File in C
  
• How to parse a file in C++
  
• The Case Against Global Variables
  
• The sizeof an empty class or structure is 1
  
• Tutorial 1 - What Is Programming?
  
• Tutorial 2 - How to Program
  
• Useful Sites and Links (Compilers, Tutorials, API Documentation, Code Repositories)
  

XML Howtos

• How to create a white space in the XML Text node....
  
• XML from Start to Finish - Phase 1
  
• XSLT Tips you don't learn at w3schools
  

Flash / Actionscript Howtos

• How to Convert PowerPoint to Flash Manually
  

Apache Howtos

• Advanced caching with mod_expires
  

Ruby / Rails Howtos

MySQL Howtos

• MySQL Basics
  
• Views and Why We Love Them
  

ASP Howtos

• ASP.NET / SQL Server 2005 Database interaction:localhost
  
• Dealing with checkboxes
  
• How To Dynamically Search A Database Table
  
• How To Export Your Displayed Data To Excel
  
• How To Highlight Searched For Text
  
• How to insert data into a database with ASP
  
• How to upload whole files with ASP
  
• MySQL with Integrated Windows Authentication
  

Visual Basic / VBA Howtos

• Adding Bitmap to Menu.
  
• Adding Items to Listview Manually.
  
• Adding Items to TreeView & ListView from Database.
  
• Adding Items to Treeview Manually.
  
• Apostrophe causes error in SQL string: Solution
  
• Auto Scroll text in a static label
  
• Backup / Restore of Access Database
  
• BLOB - Retrieve image stored in database
  
• BLOB - Save image to database
  
• Capture video from webcam and displays in picture box
  
• CD ROM Detection
  
• Check whether project is running VB IDE
  
• Clone any object in vb 6.0
  
• Connection strings
  
• Create Dynamic Report : with Parent Child Command
  
• Data management with XML, Text files using VB 6.0: Part One
  
• Data management with XML, Text files using VB 6.0: Part Three
  
• Data management with XML, Text files using VB 6.0: Part Two
  
• Deleting temporary files with just one click
  
• Display a byte as two hex digits
  
• Drawing Chart using MSChart Control.
  
• Drawing Graphics
  
• Evaluate mathematical expressions with VB
  
• Excel: select only visible cells
  
• Execute a shell command from a program
  
• Execute VB code from a string
  
• Executing Oracle Stored Functions.
  
• Executing Oracle Stored Procedures with both IN & OUT type parameter.
  
• Executing Oracle Stored Procedures with IN OUT type parameter.
  
• Executing Oracle Stored Procedures with IN Type Parameter.
  
• Factorial and Gamma Functions for VB
  
• FileSystemObject model - how to list files in a directory (VB6)
  
• Format a database date
  
• Generate Random Password
  
• Generating Random Numbers in VB.NET
  
• Generating Random Numbers in VB6
  
• Give FadeOut Effect to your Application
  
• Give XP Look to VB6
  
• Handling Picture Using Picture Box.
  
• How To Handle More events Visual Basic 6.0 Not Support
  
• How to read a file in VB - Part 1 - VB6, Line Input
  
• How to read a file in VB - Part 2 - VB6, Binary mode (Get)
  
• How to: Determine number of colours
  
• Listing All Available Drives
  
• Mouse Tail...
  
• Non-repeating random numbers
  
• Opening and Closing CD TRAY
  
• Playing WAV Sounds
  
• Run AVI Files inside a Picture Box
  
• Set default printer
  
• Shuffling a list...
  
• Shut down Windows from a program.
  
• Simple Factorial function for VB
  
• Simple VB function to calculate distance between two points
  
• Simple way to read Login information from text file
  
• VBA Minesweeper - Take advantage of your Mouse in an Excel's Worksheet.
  

Linux / Unix / BSD Howtos

• Understanding Ext-2 file system:chapter 1
  
• Understanding Ext-2 file system:chapter 2
  

PHP Howtos

• Article of interest: PHP pros/cons for the enterprise
  
• Configuring PHP 5.2.3 with GD support for Mac OS X
  
• Creating a Data Abstraction Layer in PHP
  
• Making A History Page For BIG Sites
  
• Neat way to use Headers and Footers in PHP
  
• PHP Sessions
  
• Turn array indices into variables.
  
• Uploading files into a MySQL database using PHP
  
• Using HTML Forms to pass data to PHP
  
• XSRF: What is it, How does it work, and How can you thwart it?
  

Python Howtos

• Boa Constructor: Undocumented Features
  
• ctypes Basics
  
• Database Login now uses mxODBC
  
• DB Connection Manager now supports mxODBC, win32ODBC and PyODBC
  
• Encapsulating a SyPy filter
  
• Extending Python
  
• Fast Prime Number List Generator
  
• happy (tkinter) easter 2007 folks!
  
• py2exe setup file for wxPython that runs from any IDE and excludes Tkinter
  
• Python and Tkinter
  
• Python Universal Library bug fix
  
• Simple guide to using py2exe
  
• Simple guide to using PyInstaller
  
• Simple wx.Dialog subclass for Database Login
  
• SQL helper function updates
  
• The Model used by wx.Dialog subclass for DB login.
  
• Thinking Outside the Box with Python
  
• Tkinter XMas Graphics
  
• wx.Config encapsulation improved with __getattribute__()
  
• wx.Dialog subclass instantiates my dbServer class
  
• wx.Wizard creates pages using eval() in a List comprehension
  
• wxPython:event.Skip() - watch out for stack depth
  

Javascript / DHTML / Ajax Howtos

• A Guide to Coding Cross-Browser Scripts
  
• A Guide to Coding Cross-Browser Scripts Part 1: Browsers and Standards
  
• A Guide to Coding Cross-Browser Scripts Part 2: Event Normalization
  
• Ajax Example
  
• An Introduction to Function Objects
  
• Browser Bugs, Quirks and Inconsistencies
  
• Deep Cloning JS-Objects
  
• Deep linking with AJAX made possible with the use of DHTML & PHP
  
• Don't want to send your comments with the code?
  
• Drag & Drop Table Columns (new version, explained)
  
• Extremely Simple Progress Bar
  
• Filtered Drop Down
  
• Function to check a users browser v1.2
  
• Function to convert decimal color number into HTML hex color string
  
• Grid table (add, remove, import, edit)
  
• Hang man
  
• Hide JavaScript code from the client
  
• Image Slide Show
  
• Javascript Loading Mask
  
• Optimize Loops to Compare Two Arrays
  
• Playing a sound file with a JavaScript function
  
• Position Absolute Center of Page
  
• print_r(), JavaScript Edition
  
• Reading Tables Like Excel
  
• Resizable, sortable, findable and scrollable HTML table
  
• Script to validate all form fields for null in one quick call
  
• Solution to drag and draw rectangles on an image in javascript
  
• String Handling Opportunities with split(), indexOf() and RegExp
  
• Table - Columns drag & drop
  
• Table - Lines drag & drop
  
• Table Highlighting On Click
  
• Table with filtering to the content
  
• Text Effects
  
• Tic Tac Toe
  
• Variable Scope in JavaScript
  
• Weather Widget with XML and Javascript
  

Access / VBA Howtos

• 'Persisting' a Recordset
  
• A 6-Pack of Good Programming Style Hints
  
• Access 2007 Linkedtable manager not working correct...
  
• Access Built-in Functions
  
• Access QueryDefs Mis-save Subquery SQL
  
• Access VBA DAO recordset loop using two recordsets
  
• Accessing Field Values in Recordsets
  
• Accessing Tabs on a Tab Control
  
• ADO Events [Advanced Content]
  
• ADO Transaction Processing
  
• ANSI Standards in String Comparisons
  
• Application Automation
  
• Automatic Error Handling in Access
  
• Avoid IIf(), Switch(), and Choose() in VBA code
  
• Basic SQL Syntax for Access Queries
  
• Cache Object References
  
• Cascading Combo/List Boxes
  
• Cascading Forms.
  
• Control Object Reference (Me!)
  
• Converting numbers to Words
  
• Create Dynamic Report using VBA
  
• Custom Error Messages
  
• DAO or ADO - Why Not Both?
  
• DAO Transaction Processing - What is it?
  
• Database Normalization and Table structures
  
• Debugging in VBA
  
• Debugging in VBA - 1) Overview
  
• Debugging in VBA - 2A) The Code Pane (F7)
  
• Debugging in VBA - 2B) The Project Explorer Pane (Ctrl-R)
  
• Debugging in VBA - 2C) The Properties Pane (F4)
  
• Debugging in VBA - 2D) The Immediate Pane (Ctrl-G)
  
• Debugging in VBA - 2E) The Object Browser Pane (F2)
  
• Debugging in VBA - 2F) The Locals Pane
  
• Debugging in VBA - 2G) The Watch Pane
  
• Debugging in VBA - 3) General Tips
  
• Does a File Exist?
  
• Double-clicking to move an item between list boxes
  
• Early vs Late Binding
  
• Example Filtering on a Form.
  
• Excel Functions in Access
  
• Excel in Access (Part 1)
  
• Finding a Specific Record Programmatically
  
• Finding Jet SQL Help
  
• Front-End / Back-End (FE/BE)
  
• Function to Move (Forwards or Backwards) Through Weekdays
  
• Function to return Username (NT Login) of current user
  
• Generate Statistics With the OpenSchema Method
  
• Hide/Display SubMenu Buttons
  
• How to Create a Data Link File
  
• How to Declare a Default Property in a Class Module
  
• How to Generate a User List
  
• How to Optimize Queries and Recordsets
  
• How to Play Sounds in Access
  
• How to Programmatically Create a Hyperlink on a Form
  
• How to Unsecure a Secure Access Database
  
• How to Use a Progress Meter in Access
  
• How to Use Excel Functions in Access
  
• How to Use Named Arguments
  
• Import csv (Comma Separated Value) File
  
• In Arrays, For Each...Next vs For...Next
  
• Indexes in Microsoft Access
  
• Input Masks
  
• Literal DateTimes and Their Delimiters (#).
  
• Macro's or VBA ?
  
• Meet the ADO Cursors
  
• Memo Fields in Access
  
• Methods of Connecting to SQL Server
  
• Microsoft Access Specifications
  
• Microsoft Scripting Runtime #1
  
• Microsoft Scripting Runtime #2
  
• Microsoft Scripting Runtime #3
  
• Microsoft Scripting Runtime #4
  
• Module to Read from the Windows Registry
  
• MS Access Calculated List
  
• Obtain Access Information/State of an Object
  
• Passive Shutdown
  
• Printer and Printing Tips
  
• Producing a List from Multiple Records
  
• Publishing Access Data on the Web
  
• Queries in Access using SQL View
  
• Quotes (') and Double-Quotes (") - Where and When to use them.
  
• Referring to Items on a Sub-Form
  
• Require Variable Declaration
  
• Reserved Words in Access, Especially Date and Time
  
• Retrieve Values from a Multi-Select ListBox
  
• Retrieving Data From a DAO Recordset Using GetRows()
  
• Retrieving Data From an ADO Recordset Using GetRows()
  
• Running code asynchronously
  
• Scroll Wheel Support in VBA Window
  
• SQL JOINs
  
• Stored Query vs SQL Statement
  
• Subqueries in SQL
  
• Testing for an Empty Recordset
  
• The BLOB (not the movie!)
  
• The ISAMStats Method
  
• The Partition() Function
  
• The Supports Method of an ADO Recordset Object
  
• timeGetTime() vs Timer()
  
• To create an mde file
  
• Use IsCharAlphaNumeric() Rather Than ASCII Values
  
• User-defined class for SQL Select expressions
  
• Using "&" and "+" in WHERE Clause
  
• Using ParamArray()
  
• Using Tabbed Pages on a Form
  
• Using the MouseMove Property
  
• Variable Scope in VBA for MS Access
  
• VBA - Event Driven Programming
  
• VBA Data Types
  
• What is Null?
  
• What's Your Function Flavor?
  
• Windows Script Host Object library
  

Perl Howtos

• Character Classes and Special Characters
  
• Creating custom Modules
  
• How to Install and Setup Strawberry Perl
  
• How to Upload Files using the CGI.pm Module and Perl
  
• Sorting data with perl - Part One
  
• Sorting data with perl - Part Two
  
• Sorting Data with the Schwartzian Transform
  

Java Howtos

• ! Java Articles Index
  
• A quick introduction to Java concepts 1
  
• A quick introduction to Java concepts 2
  
• A quick introduction to Java concepts 3
  
• An Introduction to Exceptions - Ch. 1
  
• An Introduction to Exceptions - Ch. 2
  
• An Introduction to Exceptions - Ch. 3
  
• An Introduction to Exceptions - Ch. 4
  
• An Introduction to Exceptions - Ch. 5
  
• Author Madhoriya22: Serialization
  
• Author Nomad: ArrayLists
  
• Compilers - 1: Introduction
  
• Compilers - 2A: Tokenizers
  
• Compilers - 2B: Tokenizers
  
• Compilers - 3: Grammars
  
• Compilers - 4: Bookkeeping
  
• Compilers - 5A: Parsers
  
• Compilers - 5B: Parsers
  
• Compilers - 6A: Interpreters
  
• Compilers - 6B: Interpreters
  
• Compilers - 7: Instructions
  
• Generic heap sort algorithm A
  
• Generic heap sort algorithm B
  
• Generics and Sets
  
• Graphs and the BFS algorithm
  
• Initializers
  
• Insertion Sort
  
• LSP and programming by contract
  
• Old tricks
  
• Overriding the equals and hashCode methods
  
• Patterns: the Decorator pattern
  
• Patterns: the Visitor pattern
  
• Permutations A
  
• Permutations B
  
• Program Structures
  
• Reading and Writing files
  
• Repetition or Iteration
  
• RPL - 1A: Introduction and the core language
  
• RPL - 1B: Introduction and the core language
  
• RPL - 2: Composite objects
  
• RPL - 3: Structure objects
  
• RPL - 4: Evaluation and lambda bindings
  
• RPL - 5: Currying
  
• RPL - 6: Intermezzo
  
• Scripting
  
• Selection Sort
  
• Sudoku A
  
• Sudoku B
  
• Sudoku C
  
• Switch
  
• Text retrieval systems - 1: Introduction
  
• Text retrieval systems - 2A: Text Processors
  
• Text retrieval systems - 2B: Text Processors
  
• Text retrieval systems - 3A: the Library Builder
  
• Text retrieval systems - 3B: the Library Builder
  
• Text retrieval systems - 4A: the Library
  
• Text retrieval systems - 4B: the Library
  
• Text retrieval systems - 5: the BookMark implementation
  
• Text retrieval systems - 6: Queries
  
• Text retrieval systems - 7: the Software and Data
  
• WeakReferences
  

Mobile Development Howtos

• Configure WURFL on Resin application server
  
• Intro to WML - WAP Basics #1
  
• Intro to WML - WAP Basics #2
  

HTML / CSS Howtos

• CSS Articles
  
• HTA CPU Usage monitor
  
• HTML help for MySpace users
  
• HTML helpful links
  
• Move away from table layout to using CSS
  
• Post or link your markup
  
• Simple Three Column Layout
  
• The doctype or DTD
  
• The Web is Ruined and I Ruined It
  
• Validate your markup early and often.
  
• Where is imagedata? <img src="cid:image001.gif@01BF4C68.ABA6D350"
  
• Which browser are you using?
  

Oracle Howtos

• 10g REGULAR EXPRESSIONS (REGEXP_LIKE)
  
• 10g REGULAR EXPRESSIONS (REGEXP_INSTR)
  
• 10g REGULAR EXPRESSIONS (REGEXP_REPLACE)
  
• 10g REGULAR EXPRESSIONS (REGEXP_SUBSTR)
  
• A Roadmap To Query Tuning
  
• Bulk-Fetching from a Cursor
  
• CHARACTER FUNCTIONS
  
• CONVERSION FUNCTIONS
  
• CUME_DIST Function.
  
• DATE FUNCTIONS
  
• EXCEPTIONS - 1
  
• EXCEPTIONS - 2
  
• EXCEPTIONS - 3
  
• EXCEPTIONS - 4
  
• Fast-Start Failover An Overview In Dataguard Environment
  
• GENERAL FUNCTIONS
  
• Impact Of Nologging Operations In High Availability Environments
  
• Important Date Related Queries - 1
  
• Important Date Related Queries - 2
  
• LogMiner Utility, useful stuff ?
  
• NTILE Function
  
• Oracle 10g Feature: REGULAR EXPRESSIONS - 1
  
• Oracle 10g Feature: REGULAR EXPRESSIONS - 2
  
• Oracle 10g Feature: REGULAR EXPRESSIONS - 3
  
• Oracle 11g New Features-I
  
• Oracle 11g New Features.-II
  
• Oracle Database Links (DB Link)
  
• Oracle PL/SQL 9i/10g - Introduction
  
• Oracle PL/SQL 9i/10g - Sample Programs
  
• Oracle REF CURSOR - 1
  
• Oracle REF CURSOR - 2
  
• Oracle REF CURSOR - 3
  
• Oracle Tips and Tricks--SQL-I
  
• Pivoting
  
• Pivoting - 1
  
• Pivoting - 2
  
• Pivoting - 3
  
• PL-SQL Tips (SINGLE ROW FUNCTIONS)
  
• PL/SQL-CURSOR - 1
  
• PL/SQL-CURSOR - 2
  
• PL/SQL-CURSOR - 3
  
• PL/SQL-CURSOR - 4
  
• PL/SQL-CURSOR - 5
  
• PL/SQL-FUNCTIONS - 1
  
• PL/SQL-FUNCTIONS - 2
  
• PL/SQL-PACKAGE - 1
  
• PL/SQL-PACKAGE - 2
  
• PL/SQL-PACKAGE - 3
  
• PL/SQL-PACKAGE - 4
  
• PL/SQL-PROCEDURES - 1
  
• PL/SQL-PROCEDURES - 2
  
• PL/SQL-PROCEDURES - 3
  
• Ranking Function
  
• Reporting Function
  
• Sending mail using UTL_SMTP.
  
• SQL Tuning tricks
  
• Table Partition Performance analysis
  
• The function return amount of data at a time (Oracle)
  
• TRIGGERS - 1
  
• TRIGGERS - 2
  
• TRIGGERS - 3
  
• USING EXTERNAL TABLE
  
• Using Merge command
  
• Using Partition -1
  
• Using Partition -2
  
• Using PRAGMA - I
  
• Using PRAGMA - II
  
• Using Subqueries - 1
  
• Using Subqueries - 2
  
• WIDTH_BUCKET Function
  
• Windowing Function - 1
  
• Windowing Function - 2
  

SQL Server / MSSQL Howtos

• Delete Duplicate record from SQL Server2000
  
• Eliminating Duplicate Rows In SQL SERVER 2000
  
• SQL Server 2005 T-SQL XML Parser
  

PostgreSQL Howtos

DB2 Howtos

• CHAR to VARCHAR conversion in DB2(iSeries)
  

IIS Howtos

Networking Howtos

• Multi-threaded TCP/IP Server without .NET Socket Class
  
• [MACOSX] Fixing NetInfo Errors on the Command Line
  

Windows Howtos

• Bootscreens and Logons for XP
  
• Creating Shortcuts that Microsoft Left Out on XP
  
• Dealing with USB flash drive issues
  
• Flaws in Application Layer Gateway Service (alg.exe)
  
• Keyboard Shortcuts
  
• Pen drive - Virus Removal
  
• Retrieving Registry info & Outlook data after crash
  
• Troubleshooting Driver Problems
  

Software Development Howtos

• Egoless Programming: The Ten Commandments
  
• How to find modulus of a very large number
  
• MS SQL Server 2005 Vs MySQL 5.x
  
• Standby Database Monitoring & Protection Modes (9iR2)
  
• Visualization table