The Latest

DevX - Software Development Resource

Explore the File System from T-SQL

The Indexing Service should be started before using the following code.The File content search relies on the Microsoft OLE DB Provider for the IndexingService. The following query lists all the

DevX - Software Development Resource

Remove Duplicates from Delimited String in T-SQL

Use this snippet to remove duplicates from a delimited string: DECLARE @mystring varchar(1000), @myword varchar(50),@CachedStringvarchar(2000)set @CachedString=”DECLARE @i int,@j intSELECT @mystring = ‘cat dog fox cat chicken hen goose cat bird

DevX - Software Development Resource

Get the Deep Copy of Any Object

This generic class will help to obtain a deep copy of any object and cast it to the Object Type: public class ObjectCloner{ private ObjectCloner(){} // returns a deep copy

DevX - Software Development Resource

Schedule Events with The Timer Class

Scheduling recurrent or future events can be a hassle, but the Timer class can make it a lot easier. With a couple of simple calls, you can create any number

DevX - Software Development Resource

Append an Exception Trace to a Log File

If you want all exceptions to go to the same file, use this code: import java.io.*;import java.util.Date;public class Logger{public static synchronized logException(Exception ex){try {RandomAccessFile ff = new RandomAccessFile(“c:\name.log”,”rw”);// to append

DevX - Software Development Resource

Creating a Parameterized SQL Query Using PreparementStatement

// conn – having a database connection alreadyPreparedStatement stmnt = null;ResultSet rs = null;try{ // ‘?’ indicates placement of a parameter. stmnt = conn.prepareStatement(“SELECT firstName FROMemployees WHERE salary > ?”);

DevX - Software Development Resource

How to Print an __int64 Number in VC++

You can use the printf() function as in the following example: #include using namespace std;int main(){ __int64 i64 = 4294967296; printf(“%I64d “, i64); //in decimal printf(“%I64x “, i64); //in hexa

DevX - Software Development Resource

Efficient Storage of and Access to Adjacency Lists

Large graphs are stored as adjacency lists to save space. Traditional mechanisms based on arrays of pointers waste space. The following scheme is based on array of indices, which saves

DevX - Software Development Resource

How To Capture a Mouse Without SetCapture

typedef BOOL ( CALLBACK *REPEATUNTILRELEASECALLBACK )( POINTptScreen, LPARAM lParam );BOOL RepeatUntilRelease( HWND hWnd, REPEATUNTILRELEASECALLBACKfctRepeatUntilRelease, LPARAM lParam, RECT* prtClipping, UINT vk ){ MSG message; ZeroMemory( &message, sizeof(message) ); if ( IsWindow(

DevX - Software Development Resource

Executing a Member Function After main() Terminates

You can execute any member function or any other execution after a termination of main() function by using “#pragma exit.”Here’s the syntax: #pragma exit [priority] //withoutsemicolon Now, here’s an example:

DevX - Software Development Resource

Update SQL Server records via HTTP

Thanks to the SQL Server extensions for the Web and XML, it is now possible to query a SQL Server database (and get the result as XML) as well as

DevX - Software Development Resource

3 Key Coding Tips for BREW Developers

Tip #1: Code for the phone, not the emulator. Handsets are small form factor, constrained devices ? so relative to what you’re used to on the desktop, phones have limited

DevX - Software Development Resource

Create zero-elements arrays

The .NET framework lets you create two types of “empty” arrays: unitialized arrays and arrays that are initialized with zero elements. Uninitialized arrays are actually array variables that are set

DevX - Software Development Resource

A For Each loop that iterates in reverse order

The For Each loop always iterates orderly on all the elements of an array or a collection (more precisely, on all the elements of a class that implements the IEnumerable

DevX - Software Development Resource

A generic benchmark routine

You often need to benchmark a piece of code, which you usually do as follows: Dim start As Date = Now’ insert here the code to benchmarkDim elapsed As TimeSpan

DevX - Software Development Resource

Retrieve file version information

The System.Diagnostics.FileVersionInfo class lets you easily read file version information without having to call Windows API functions (as you have to do under previous VB versions). This class has a

DevX - Software Development Resource

Reduce context overhead for COM+ components

Instances of configured components, that is, components configured in COM+, get runtime services owing to context objects. When you instantiate a COM+ component, your instance will live in a context

DevX - Software Development Resource

Keep Your Projects Intact

VB has always gone out of its way to take care of mundane housekeeping tasks without bothering you with the details. But sometimes the best intentions can create unintended problems.

DevX - Software Development Resource

A New Look at the Select Case

Who says the Select Case can evaluate only one statement? Try Select Case True instead of the If Related Posts Are Design Patterns Really Useful?What Android M Means for the

DevX - Software Development Resource

Split Strings Cleanly, Redux

What if you want to split an array on more than one delimiter? Adding a few lines of code and using recursion can enhance the function to handle multiple delimiters.When