The Latest

DevX - Software Development Resource

Deconstructing Add-In Architecture in Visual Studio .NET

isual Studio .NET provides an incredible leap forward from its predecessor in terms of functionality, but eventually, every developer finds a sought-after feature that just seems overlooked. VS .NET provides

DevX - Software Development Resource

Hearts and Minds

rom the time Visual Studio.NET was first in beta there has been a constant debate about a subject that is near and dear to all Visual Studio .NET developers. This

DevX - Software Development Resource

The Mind of an Angry Coder: I Take Exception to That

y favorite source code repository is SourceGear’s Vault. Besides being written in .NET, it is highly optimized for remote development scenarios. I was installing a new instance of Vault on

DevX - Software Development Resource

ADO.NET Best Practices

o get the most out of ADO.NET classes, developers must fully understand the model and study a few best practices. Based on years of real-world experience with ADO, ADO.NET provides

DevX - Software Development Resource

Longhorn and Mozilla: Birds of a Feather

oftware technology goes forward in fits and starts. Bigger advances can cause plenty of information indigestion for technologists. At each leap, a new understanding gap opens up. Such a gap

DevX - Software Development Resource

Find and Replace a String in a Table

The folowing stored procedure will find and replace a string in a table: CREATE PROCEDURE [dbo].[sp_st_FindANDReplaceString]@Tablename varchar(20),@FieldName varchar(20),@FindString varchar(30),@RepalceString varchar(30)ASdeclare @sqlstring varchar(8000)Select @sqlstring = “Update ” + @Tablename + “

DevX - Software Development Resource

A Fabricated ADO Recordset

A disconnected recordset is a recordset which does not hold an active connection. A fabricated recordset can be viewed as a variation of a disconnected recordset. The variation in the

DevX - Software Development Resource

Get the Current Host Info

This program prints out the name and the address (in both textual and numerical forms) of the machine on which its run, using the InetAddress singleton. import java.net.*;public class CurrentHost

DevX - Software Development Resource

Replace All Occurrences of One String with Another String

All programmers?especially database programmers?require a function that replaces all occurrences of one substring with another string. For example, they need to replace the single quotes in strings passed to an

DevX - Software Development Resource

Serialize Data Using a PropertyBag

You can serialize your data quickly by placing it into a PropertyBag object, then reading the PropertyBags Contents property. This property is really a Byte array that is a serial

DevX - Software Development Resource

Manage Errors with Sparse Line Numbering

You might have used line numbering to track error locations, but this technique can be a pain (and ugly) to use for every line. Sparse line numbers help you locate

DevX - Software Development Resource

Make an Object Appear Like a Pointer

You can make an object appear like a pointer with a smart pointer. If a class overloads the operator ->( ), then any object of that class can appear like

DevX - Software Development Resource

Spell Checker Add-In for VS.NET 2003

This Visual Studio 2003 add-in provides a multi-language spell checker for your comments and string literals. It uses a procedure similar to MS-Word but provides additional features useful for programmers.

DevX - Software Development Resource

BlobToFile – Saving a BLOB field to a file

‘ Reusable routine that save a BLOB field to a file’ Requires Imports for System.Data and System.Data.Common’ Example: BlobToFile(dr, 2, “c:xxxx.bmp”)Sub BlobToFile(ByVal dr As IDataReader, ByVal fieldIndex As Integer, _

DevX - Software Development Resource

FileToBlob – Loading a file into a SQL Server’s BLOB

‘ Reusable routine that loads a file into a SQL Server’s BLOB.’ Requires Imports for System.Data and System.Data.SqlClient’ (It supports only tables with one key field.)” Example:’ FileToBlob(cn, “pub_info”, “logo”,