DevX Tips Bank: Data Management

Remove DataLinks in an Excel Workbook Programmatically

This is useful when you have an object such as a Chart in a workbook that depends on data …

Creating Tables in the Default Tablespace

Most users typically create tables in the default tablespace. Most of them are not …

A Quick Way to Obtain create table Statements

Learn about this quick, easy way to obtain create table statements in the table …

Use Oracle and Triggers to Secure Table Data

Ever deleted some tables accidently and had to waste your time doing them all over again? …

Make Cell Data Visible with a MouseMotionListener

Learn how to use a MouseMotionListener to render the contents of a cell visible.

Using Insert Iterators

Insert iterators come in very handy when you need to populate a container using an STL …

Read Time Zone Names Stored in the Registry

The following code reads the time zone names stored in the registry and places those names …

Generating a Sequence of Numbers in SQL Server

This tip shows you how to fill the dropdown lists on a Web page, Combo box, or List box in …

List All the Tables with a Foreign Key Constraint

Use this code in Query Analyzer to list all tables with foreign key constraints.

Use Oracle's VARRAY Through JDBC

This code snippet demonstrates how to use Oracle's VARRAY through JDBC.

Uploading a Large Number of Records in DB2

A myriad of database configuratrion issues can pop up while you're performing …

Look Up a DataSource Object in Your Web Server

This code demonstrates how to look up a DataSource object in your Web server using JNDI …

How to Use an XPath on a DataSet

This tip shows you the used classes, the XML file, the code and the output for using an …

Using XPathDocument in XPath Queries

This tip shows how to use the .NET class XPathDocument instead of …

Create a Sortable Column Dynamically

Learn how to customize the sorting of your resultset using the CASE function.