August 3, 2005

Add Line Numbers in Your VS.NET Code Window

To add line numbers in your VS.NET code window: Go to VS.NET?>Tools?>Options?>Text Editor. Choose the language of your choice and select the Line Number checkbox under Display. This will add the line numbers to the code window.

Prevent Empty Parameters from Automatically Converting to Null

You can define parameters for the SqlDataSource control. If a parameter value is an empty string, the driver automatically converts that into a NULL value, which can lead to unexpected query resultsand sometimes to no query results at all. To avoid this automatic conversion, set the ConvertEmptyStringToNull to equal false

Combining a Conditional Update with a Single Statement in a Cursor

Oftentimes, cursors are used to concatenate multiple columns into one string. For instance, you may want something like this to show as ‘A,B,C’ on your report (Table table_A): Id Char_Value1 ‘A’2 ‘B’3 ‘C’ In a cursor, rather than checking for values and using an exists condition and having an if/else

A List of JDBC Drivers

If you need to access a database with Java, you need a driver. This is a list of the drivers available, what database they can access, who makes it, and how to contact them. IBM DB2 jdbc:db2://:/ JDBC-ODBC Bridge jdbc:odbc:sun.jdbc.odbc.JdbcOdbcDriver Microsoft SQL Server jdbc:weblogic:mssqlserver4:@:weblogic.jdbc.mssqlserver4.Driver Oracle Thin jdbc:oracle:thin:@::oracle.jdbc.driver.OracleDriver PointBase Embedded

Retrieving Only Unique Elements from Two Sets

This algorithm helps you to retrieve all the elements contained in the first set (set1), but not in the second (set2). Here’s the template: templatevoid Diff(const T& set1, const T& set2, T& res) { T temp; typename T::const_iterator it = set1.begin(); if (&set1 == &set2) return; else { while (it

The Work Manager API: Parallel Processing Within a J2EE Container

orporations encounter various scenarios in which they need parallel processing to achieve high throughput and better response times. For example, various financial institutions perform reconciliation as batch jobs at the end of each day. In these cases, a company may need to process millions of units of work to reconcile