Tip Bank

DevX - Software Development Resource

Download Files of Any File Type

You may encounter a situation where you need to open a “Save As” dialogue box for downloading files of different types on to the client machine. You might have found

DevX - Software Development Resource

Send Mail Using a VC++ Application

Import the complete path of the following files in your application using the #import statement: MSO9.DLL msoutl9.olb HRESULT hr;CComBSTR inputStr;inputStr = CString(“MAPI”).GetBuffer(0);CoInitialize(NULL);Outlook::_ApplicationPtr xyz(“Outlook.Application”);_bstr_t name(inputStr, true);Outlook::_NameSpacePtr nsp = xyz->GetNamespace(name);CComBSTR cTo =

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