The Latest

DevX - Software Development Resource

GetFileIcon – Retrieve the icon associated to a file

Private Const MAX_PATH = 260Private Type SHFILEINFO hIcon As Long iIcon As Long dwAttributes As Long szDisplayName As String * MAX_PATH szTypeName As String * 80End TypePrivate Declare Function SHGetFileInfo

DevX - Software Development Resource

Create a GUID from ASP using SQL Server

At times you may need to create a GUID from ASP, for example when assigning unique IDs to users that are visiting your site for the first time. While you

DevX - Software Development Resource

Tame Beastly Data with Summary Tables

anagers loved Eddie; he always had the answers on-hand. Eddie was a production supervisor in the pre-computer era. He received comprehensive hourly production reports on paper. He also received urgent

DevX - Software Development Resource

Document Your XSLT

“Document Your Code! Document Your Code!!” This is one of those lessons hammered into most Computer Science majors about three days into their first code class–and one quickly forgotten by

DevX - Software Development Resource

The ADOSPCode Utility

ADOSPCode is a template driven program for generating VB code from SQL Server stored procedures. With this program you can Open/Edit connection to reach your SQL-Server database and display list

DevX - Software Development Resource

Create UDL files the easy way

The standard way to create a UDL file is to right-click in the directory where you want to create it and select the New-Microsoft Data Link menu command. Unfortunately, on

DevX - Software Development Resource

Access Class Members From a Thread Function

Suppose you have a thread function ThreadFunc in a class CMyClass and you want to access a member of that class. Here’s what to do: Declare the thread function as

DevX - Software Development Resource

Conversion From Numeric to String

#include void main(){ char cBuf[96]; float fVar=5.678; int nVar=78; //Conversion from float to char* sprintf(cBuf, Related Posts Masdar Acquires Hybrid Renewable Projects in PolandHarnessing AI, data, and cloud for growthApple

DevX - Software Development Resource

Fast Execution of SQL Statements

Let’s start with a code fragment: Statement stmt;Connection con;Class.forName( Related Posts Why TDD Is KeyCan’t use the “Between” Keyword in a LINQ QueryBranson’s brave sale of Virgin Records safeguarded Virgin

DevX - Software Development Resource

Handling Data Inconsistency

Many times in DB programming, a situation occurs when one operation, depends on the result of the other, but there is no way to communicate that result to the first

DevX - Software Development Resource

Determining the Last Date Of a Month

It’s common when working with dates to be able to determine the last date of a particular month. I’ve seen solutions to this problem that range from using arrays or

DevX - Software Development Resource

Encrypting Stored Procedures

When creating stored procedures, there will be occasions where a certain procedure definition should not be viewed. Using the WITH ENCRYPTION clause stores the procedure definition in an unreadable form.

DevX - Software Development Resource

Encrypting Database Views

Using the WITH ENCRYPTION clause when creating views ensures that they remain secure by keeping the view definition hidden. Sample code:————— Create view Procedure ————–create view Related Posts Revolutionary US

DevX - Software Development Resource

A Beginner’s Checklist

Beginners and even experienced programmers who switch to a new compiler suddenly discover that their programs don’t compile anymore. Sometimes the programs compile but produce numerous warning messages. In most

DevX - Software Development Resource

MS Default Pointer Value

Don’t forget that MS compiler initiates pointers with 0xCCCCCCCC value. In this case: void *p; … //do something here… if (p!=NULL) delete p; // Memory violation The right way void*

DevX - Software Development Resource

I/O Formatting With Stringstream

The sprintf() function isn’t type-safe, it doesn’t support user-defined types and it’s a common source of buffer overflow bugs. In C++, there’s a better alternative to sprintf(), namely stringstream objects.

DevX - Software Development Resource

Different Uses For Sizeof Operator

Sizeof is a useful operator because it reports both the amount of memory that data items take and the number of bytes that data types. For instance: cout