|
|
| Top 101 to 150 Database Tools - ASP scripts |
Scripts are listed afer popularity. To display the scripts after name please click here
|
101)
Web SQL Console
This tool provides the services like, datahosting and webhosting. This utility is helpful for webmasters to create their website with database table to allow their site visitors to enter their data inside the database.
102)
Speedup Database Access using GetRows
The main theme of this online tutorial tells about the usage of Recordset.GetRows method and explains the easy and fastest method to close the database connection.
103)
Delete Record with SQL statement
This tutorial helps users to delete the records using the SQL statement. Users can delete any number of records from the database table using the single SQL statement.
104)
Using the ADO Stream Object to Determine Properties of any type of file
It is an tutorial in which author explains about defining the properties for any type of files using ADO stream object. The programmers can learn about the source code which executes the above said process.
105)
Duplicate records using SQL query
This article explains about how to find duplicate records using SQL statements like SELECT FROM and WHERE. The definitions are given in a simple form.
106)
Custom Formatted Database Tables
Through this simple online tutorial the author explains about how to display results in newspaper style columns. The entire process of this experimentation is given along with its code.
107)
Mastering getrows
It is an article which deals with array manipulation with the help of getrow function. In this article author describes about the two loops which controls the two dimensional arrays.
108)
Paging through Records using a Stored Procedure
The main objective of this online tutorial is to teach the webmasters about paging results of a database query. The author shows this task with an example in this article.
109)
ASP DB Admin Control
ASP DB Admin Control is a simple database administration code that helps webmasters to have a login area using MS Access database on their ASP supported websites.
110)
Calling MS Access Parameterized Queries from ASP
This tutorial site helps the users to know how to call MS Access parameterized queries from ASP and this tutorial shows how to activate SQL queries to access Access database through ASP.
111)
Using GetDate Function in an SQL Statement
This article guides the users to retrieve date and time of SQL server using GetDate Function in SQL statement. It offers sample code snippets for the users.
112)
Making the Switch From ODBC to OLE DB
Through this online tutorial the webmasters can analyse the concept of both ODBC and OLE DB. Then finally the author emphasises the importance of OLE DB.
113)
Counting Records In A Database Table
This ASP tutorial is easily understable by the novice. You can display the number of records in the database table with the help of this tutorial.
114)
ASP and VBS, ADO and DBF file database connection
This online tutorial deals mainly with ADO and DBF file database connections. The author explains the entire process in this article and discusses more about each function keys.
115)
SQL SELECT Command
This online tutorial explains about the SQL SELECT command. The author describes the SELECT command implementation in SQL with examples and sample source code.
116)
Fastest way of Database Access : Caching Records in Memory
Displaying records from the database is the main topic discussed in this online tutorial. The author explains this concept through an example which is more faster in accessing than the rest.
117)
Easy SQL Apostrophes Bug Fix
This tutorial discusses about the usage of apostrophe in SQL statements and also it explains them where the error occurs while passing variable to SQL statements using apostrophe.
118)
Searching and sorting records in a recordset from the database
This tutorial provides basic steps to the users for facilitating their database or website with searching and sorting recordset in a reliable manner.
119)
Removing single quotes for SQL statements
In this online article the author defines about one of the common problem in SQL statements and its remedy. The issue deals with the problem of using single quote in SQL and the remedy for it.
120)
Running Stored Queries in Access Database
This article instructs elaborately about running stored queries in MS Access database to retrieve data from database.
121)
Pagination to columns for large query
This online tutorial discusses about the pagination to columns for large query. The author explains this concept with an example through this article.
122)
How do I deal with an apostrophe (') in a SQL statement?
This tutorial discusses and teaches the users about the functions of apostrophe in SQL statements and it demonstrates its functions with sample codes.
123)
MagicGrid
This online tutorial helps the webmasters to add, update and erase items in all levels. Further the author describes about the usage of drag and drop and creation of a web interface.
124)
Replace text string in single record
This is a tutorial that deals with replacing a text string in a single record in a database. This article is provided with appropriate sample codes.
125)
A Nifty Way to Create Connection Strings
The main theme of this online tutorial is all about generating DSN Less connection strings. The author explains the basic categories of the connection string.
126)
Search db by Field
This tutorial explains about how to search DB by field. From this article users can search their targeted data from the database easily.
127)
QUICK TIP: Getting Identity without Stored Procedure
This is a simple tutorial for the readers. In this tutorial author cleary explains how to get the autonumber of the last record without using the stored procedure.
128)
Parameterized Queries Using Visual InterDev 6.0 Design Time Controls
This article provides few techniques that the users to follow for parameterizing queries with the help of visual interdev design time controls.
129)
Counting Records with SQL and ASP
This is an ASP tutorial that generates you the code for counting the number of records in your database table. You can copy the sample code generated by this tutorial in your application.
130)
DSN vs DSN less Database Connections
By the end of this online tutorial the developers learn about the two unique ways of connecting database with and without Data Source Name. The author gives the complete structure of these two connections.
131)
UPDATE RECORD
Updating a record in a database is the main objective of this online tutorial. In this article the author gives a solution for the clients to change their password.
132)
Utilizing the INNER Join
This article explains about how to work with SQL database and how to make an ASP page interact with SQL server to store data using SQL statements.
133)
Select List Thingy
This is an useful tutorial that is esily understandable by all the users. This tutorial demonstrates you about how to create a dropdown combo box and list the items in it.
134)
DSN-less Database Connections
The author proves the simplicity in linking to a database in an ASP script. This article deals about opening an Access database using a DSN Less connection.
135)
Paging records in ASP
In this simple online tutorial, the author explains the webmasters about paging records in ASP.
136)
Displaying information from a database
Displaying information from a database is an article that contains more information about how to display records from the database table using vaious methods.
137)
Paging: Use ADO, getrows, or a Stored Procedure?
The main core of this online tutorial is about programming within a stored procedure. Through this article the author proves that using stored procedure for paging is the best to deal with huge volume of data.
138)
DataBase Editor
DataBase Editor is an ASP based script that allows you to manage your website database from the browser. Demo available.
139)
Utilizing Parameters in SQL Stored Procedures
From this tutorial section users can refer and understand how to use parameters in SQL stored procedures. Examples has also been given to the users.
140)
Simulate an MS Access Datasheet in ASP (Part I)
The main objective of this online tutorial is to teach the learners how to display records from an MS Access table and how to store the changes made by the clients.
141)
Apostrophes in SQL statements
Through this simple online article, the author explains about the problem of using apostrophes in SQL statement.
142)
SQL Reserved Words
This simple online article helps the webmasters to identify the SQL Reserved word before naming a database field. The author gives the SQL Reserved words for the reference of the developers.
143)
Use ASP to create an HTML table that supporting paging and sorting
This online article deals mainly about generating an HTML table which accepts paging and sorting. The author describes the above said topic with an example.
144)
Next 5 records
The main core of this online article deals with controlling the number of records which is returned from a recordset. The author explains about all the process with an example.
145)
Generating Spreadsheet-Like HTML Tables
The main objective of this online tutorial is to show how easy to give the database details to an HTML table by generating Spreadsheet. The author explains this concept with an example.
146)
EVAPI
A more useful program for the web developers in ASP to guide them to create scripts to handle database, forms, validation process, etc., to build a professional website.
147)
Insert New Record
This simple tutorial shows you how to add the records in a database table. This tutorial demonstrates it with an example to the users. This is an useful tutorial for all the users.
148)
MX Query Builder
Create Visual SQL Queries in Dreamweaver MX and MX 2004 - For a dynamic web application developer, who needs create recordsets from multiple tables and is not an SQL expert, QuB is the tool that allows table relation management, automating SQL query generation.
149)
ASP-Oracle Connectivity Using OO4O
This online tutorial deals about the connectivity of Oracle with ASP using oracle object for OLE(0040). The author further explains the task of passing through Package, Procedure and SQL from ASP.
150)
Retrieving Recordsets From an Oracle Stored Procedure
This article describes fundamentally about how the users can retrieve their recordsets from Oracle using stored procedure. This tutorial has been provided with full descriptions about Oracle stored procedures.
Browse Pages: [1] [2] 3 [4] [5] [6] [7] [8] [9] [10] [11] |
|
