Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips
Tip Bank > Application Design > Data Access And Management

Data Access And Management

1-20 of 730     Previous     Next
Dealing with Windows File Security Permission Rules for Copying Remote Files
by Boris Eligulashvili
This article presents a programmatic solution to the problem based on adding permissions to the files.
Remove DataLinks in an Excel Workbook Programmatically
by Srinath MS
This is useful when you have an object such as a Chart in a workbook that depends on data from another workbook.
Creating Tables in the Default Tablespace
by MS Sridhar
Most users typically create tables in the default tablespace. Most of them are not familiar with the actual tablespaces concept and are not aware that this is responsible for the issues they encounter when large data is pumped into said tables.
Find the Total Number of Tables in an MS Access Database
by Jaya Nehru Kumar
Use the code in this tip to find the total number of tables in an MS Access database.
Connecting to Oracle without Configuring the tnsnames.ora File
by Bill Cressman
Learn how to avoid configuring Oracle's pesky tnsnames file when connecting to a database.
Storing Request-specific Data Without Using ServletRequest
by Anton Spaans
Find out how you can work around storing request-specific attributes when you don't have access to the current request's ServletRequest instance.
A Quick Way to Obtain create table Statements
by Sriram Swaminathan
Learn about this quick, easy way to obtain create table statements in the table view of Enterprise Manager.
Use Oracle and Triggers to Secure Table Data
by Sridhar MS
Ever deleted some tables accidently and had to waste your time doing them all over again? Oracle, in conjunciton with Triggers, provides an easy solution to this problem.
Make Cell Data Visible with a MouseMotionListener
by Jeevan Joseph
Learn how to use a MouseMotionListener to render the contents of a cell visible.
Using Insert Iterators
by Saurabh Ramya
Insert iterators come in very handy when you need to populate a container using an STL algorithm which uses an assignment operator to fill in the data.
Read Time Zone Names Stored in the Registry
by Dinesh Asanka
The following code reads the time zone names stored in the registry and places those names in a combobox.
Generating a Sequence of Numbers in SQL Server
by Raj Chidipudi
This tip shows you how to fill the dropdown lists on a Web page, Combo box, or List box in a Windows application.
List All the Tables with a Foreign Key Constraint
by Parthasarathy Mandayam
Use this code in Query Analyzer to list all tables with foreign key constraints.
Get the End Date of a Financial Quarter
by Vijayanandraj Amaladoss
This function gets the end date of a financial quarter, relative to the date value passed.
Extract the Contents of ZIP/JAR Files Programmatically
by Amit Tuli
This code shows you how to extract the contents of .zip or >span class="pf">.jar files programmatically.
Use Oracle's VARRAY Through JDBC
by Vijayanandraj Amaladoss
This code snippet demonstrates how to use Oracle's VARRAY through JDBC.
Uploading a Large Number of Records in DB2
by Gautham Muthuravichandran
A myriad of database configuratrion issues can pop up while you're performing database-intensive operations. This tip outlines solutions to some common problems.
Create and Retrieve a Named DataSet
by Victor Stefanescu
Use this C# function to create and retrieve a named DataSet using an open connection and a command.
Look Up a DataSource Object in Your Web Server
by Sujata De
This code demonstrates how to look up a DataSource object in your Web server using JNDI Lookup.
How to Use an XPath on a DataSet
by Sonu Kapoor
This tip shows you the used classes, the XML file, the code and the output for using an XPath on a DataSet.
1-20 of 730     Previous     Next
Sitemap