Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

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

Data Access And Management - Page 4

61-80 of 730     Previous     Next
Close Connections When You Are Finished With Them
by Trong Ha
By proactively closing connections when they are no longer needed, you reduce demand on the database server and make resources available to other users. Connections are closed when they go out of ...
Setting the Expiration Date in ASP
by Pratibha Gupta
Records can be deleted depending upon an expiration date in ...
Converting Strings Into Integers and Vice Versa
by Quan Tran
1) To convert a string into an ...
Another Way To Compare Strings
by Quan Tran
When comparing a string, you can use ...
Determine the RecordCount of a Forward-Only Recordset
by Michael Goligorsky
Using the ADO Asynchrous Option
by Michael Goligorsky
Sometimes you have a stored procedure that takes 2 to 5 minutes to execute. Applications that lock up frequently frustrate users and waste their time and resources. The ADO asynchrous option can ...
List the Fieldnames of a Recordset in Runtime
by Andreas Hillqvist
To list the fieldnames of a recordset in runtime, break the code in the procedure after the recordset has been initialized and enter the following lines into the debug window. Then press enter ...
Right-Justification of Output
by Danny Kalev
To right justify the output of cout, call the width() function with the size of the output screen (in characters) as an argument. In the following example, the program calls width() to ...
Alternatives to ios::nocreate and ios::noreplace
by Danny Kalev
In pre-standard C++, certain implementations of <fstream.h> offered the flags ios::nocreate and ios::noreplace for controlling file creation. These flags were too platform-specific and ...
Filtering Input in scanf()
by Danny Kalev
You can force scanf() to read only specific characters from the input source while ignoring all the rest. Alternatively, you can force scanf() to read all input characters except the ones ...
If Your Compiler Doesn't Support snprintf() Yet
by Danny Kalev
Sometimes, sprintf() is unavoidable. For example, when compatibility with C is paramount, Sprintf() has a safer version called snprintf(), which doesn't write past its buffer's limits. However, ...
Using Addbatch and Executebatch
by Tri Do
If you insert/update/delete multiple times to the database, you ...
How to Compact Databases Using ADO
by Filipo Mor
To compact MDB databases using ADO, just include a reference to the 'Microsoft Jet and Replication Objects 2.6 Library' (distributed with the MDAC 2.6 package) in your VB project. The code ...
Fast Execution of SQL Statements
by Nitin Kumar
Let's start with a code ...
Converting Strings From One Character Set To Another
by Espen Andersen
The following function is an efficient way of converting strings from one character set to another. Using an array of 256 characters as a conversion table, the attached function replaces any ...
Creating an MSACCESS Database through VB
by Nazmul Siddiqui
I have frequently seen bulletin board requests on how to create MSACCESS databases with VB. To do this, add a reference to the Microsoft DAO _._ Object Library (I am using Version 3.6 for the ...
Optimizing String Classes in Java Code
by Naveet Gupta
The String class is probably one of the most used classes in Java. String concatenation via the
Another Way of Handling Null Database Fields
by Stuart Hallows
A compact way of handling null database fields is as ...
<iostream.h> or <iostream>?
by Danny Kalev
Although the <iostream.h> library was deprecated for several years, many C++ users still use it in new code instead of using the newer, standard compliant <iostream> library. What are the ...
Octal and Hexadecimal Output
by Danny Kalev
By default, cout displays integral values as decimal numbers. You can override this setting and have integral values displayed in hexadecimal and octal notations by using the 'hex' and 'oct' ...
61-80 of 730     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date