Advertisements
 
 Advertisements
travelappsios lifestyleappsios utilitiesappsios

Database tools

Update Records  Update Records

 This is an online tutorial which guides the users to update records from database. It uses simple steps and followups to make easy for the users to update their own records from database. Sample source code is given in this tutorial for example....

Reuse ADO recordsets  Reuse ADO recordsets

 Now the webmasters could reuse ADO recordsets in their new SQL statement, which is explained in this online article. The author explains about reusing these ADO recordsets with an example. The author also discusses about destroying the recordsets. The sample source code is also available in this article....
Tags: online, code, source, sourcecode, author, sample, available,

Formatted Output from ASP  Formatted Output from ASP

 The main objective of this online tutorial is to print any set of database reports from the browser of the client. The author discusses about the working of MS Access, Acrobat Exchange, DataDynamic's Active Reports, Chili!soft's Chili!Reports, Crystal Reports and OmniForm Internet Publisher. At the end of this article the output display is presented. The entire sample source code for each task is given....

SQL Server Connection Pooling Myths  SQL Server Connection Pooling Myths

 This article makes the web developers to understand the real essence of connection pooling. The first section of this article contains few objective questions regarding the connection pool. The author explains this by generating an ASP page with more connections. All the answers for each question is explained along with the graphical description one by one. The sample source code is also given along with this tutorial. In a nut shell, this article explains the connection pooling through ADO....

How to Recover a Table Deleted from an Access Database  How to Recover a Table Deleted from an Access Database

 This is an useful tutorial for the application developers. You can learn how to recover the table that was deleted from the Access database with the help of this tutorial.This tutorial provides two methods for table recovery. Using Ctrl+z undo command you can recover the deleted table. This method works only if you haven't done any cut, copy and paste undo combination of actions before trying to restore the table. Alternative method is using the code provided with this tutorial for restoring the deleted table....
Tags: database, restore, copy, help, code, recover, application, using, learn, table, deleted, paste, tutorial, command, for, useful, method, undo,

Database Connection String using Microsoft Access Driver (DSN less)  Database Connection String using Microsoft Access Driver (DSN less)

 Through this online article the author shows the entire Connection string access. The article covers about Text or CSV Connection String using MS Text Driver(DSN less), Database Connection String using MS Excel Driver(DSN less), Oracle Database Connection String using MS Oracle ODBC Driver(DSN less) and SQL Server Database Connection String using MS SQL Server Driver(DSN less). The sample source code for each connection is given in this article....

Using Data Shape to create hierarchical recordsets  Using Data Shape to create hierarchical recordsets

 The main objective of this online tutorial is to show the webmasters how to build hierarchical recordsets with the help of data shaping. The main intention of using this data shaping is to spend less server memory. The author explains the entire process of this task along with the sample source code projected in this article....

Generic Combo Advantage  Generic Combo Advantage

 At the end of this article the learners comes to understand about the usage of dynamic combo boxes. Further the author discusses about the parameters passed to this function. The main usage of this function is to add or edit data from a database. The author explains about making two different calls. The sample source code is much helpful for the beginners....
Tags: data, edit, code, source, sourcecode, dynamic, function, usage, author, sample, for, combo,

Showing data from a database  Showing data from a database

 After reading this online article the webmasters can learn more about the procedures that help to show data from a database. The author explains this concept with an example in which the data from a table would be printed with columns. The sample source code is available for the beginner's reference....

ASP-Oracle Connectivity Using OO4O  ASP-Oracle Connectivity Using OO4O

 In this article the author explains about the Oracle Database connectivity from ASP with the help of 0040. The author further demonstrates the step by step process of executing a pass through SQL. The article explains the execution of Oracle procedure and execution of Oracle package all using 0040. Package used for demo is also displayed in this article....

Using Stored Procedures For Data Access  Using Stored Procedures For Data Access

 This is an online tutorial for database administrators which teaches them the way of accessing data using stored procedures. The basic function of this tool is it allows users to insert, update and delete data from database easily without any risk. The author also explains in detail the advantages of using stored procedures....

Use an include file for database connectivity!  Use an include file for database connectivity!

 At the end of this online article the developers feel easy and comfort as they don't have the necessity to retype all the task which they used on earlier pages. In this article the author comes with a proper solution of using an include file which stores all the command task used in the previous pages. This article helps the webmasters while using database connection method....

ADO Recordset Paging in ASP  ADO Recordset Paging in ASP

 Through this online article the webmasters could understand about record paging mechanism in ASP. The author make use of ADO for this implementation and explains the whole process of record paging. He generates a set of pages to find the items by the ItemName field and to display the result of the search....

How to manipulate a text file database  How to manipulate a text file database

 The main objective of this online article is to teach the beginners how to build and manipulate a text file database. Apart from that the author explains about the method of recording, retrieving, editing and deleting records and fields within the record. In the final part, the author describes about the method which accepts to encode database. The sample source code is downloadable....

Logon to a database mySql  Logon to a database mySql

 In ASP it is very simple to logon to a mySql database which is proved in this article. The author projects the syntax of task and gives the values of it. The sample source code is given in this article....

Utilizing Parameters in SQL Stored Procedures  Utilizing Parameters in SQL Stored Procedures

 This is an online stored procedure tutorial which simply and briefly explains about the usage of parameters in SQL stored procedures and from this article users can test and view the use of parameters in SQL stored procedure. Useful tutorial for beginners to make themselves strong in database development....

Database Lock Types  Database Lock Types

 The main objective of this online article is to demonstrate the task of lock system and lock types when a database query is executed. The author shows how this locktype property works during editing and helps to give more security and also stops the overwritten data. The sample source code projecting this task is given in this article....

SQLProcess - A Powerful SQL Statement Generator  SQLProcess - A Powerful SQL Statement Generator

 This online article describes the advantages of SQL process. The author quotes this SQL process as a powerful SQL statement generator which helps the developers to create SQL statements which could append, modify, search and erase records for all the individual tables. Till the end of this article the author suggests to use SQLProcess() to create SQL statements....

Three methods of opening an ADO Recordset  Three methods of opening an ADO Recordset

 In this online article narrates the three important methods in opening an ADO recordset and query details from the database. In this three methods the author suggests the first method as very simple and the best. The sample source code for all these three methods are given in this article....

Ploma Dbedit  Ploma Dbedit

 This is an ASP based program that can be used for two purposes one is for sorting date in the office web and another one is for placing a database online. This program will be useful for both company directors and IT professionals. Company directors can utilize this tool to facilitate their company staffs to surf the database having product lists of that company. IT professionals can use this program to let their database online for further data management including editing, inserting, exporting data....

 

 

Pages :  1 2 3 4 5 6 7 8 9 10 Next >>