> 
- Home Page
- > Script ASP
- > Script ASP Database
In this section script ASP for the management of the database
Query, recordset, images, paging technique, update other things useful to manage a database with ASP.
Script ASP Database
- SearchIt makes a query on a string of keywords.
- Recordset into a tableIt allows to insert the data coming from a recordset in a table of which it is possible to specify the number of the columns.
- DB with passwordTo open password protected database.
- RandUse of the Rand function to extract some random records from a database.
- To save ImagesTo save some images on a database.
- To manage Images To manage the images saved on a database.
- Cancel UpdateA script to cancel the update of the records of a database.
- Dynamic QueryDynamic Query with searches on more keywords coming from different fields of a form.
- SQL ServerA tool to convert, through of the page ASP a database from Access to SQL Server. Made of two pages: With the first one a table is created on SQL Server, with the same fields of the Access database, and with the second you copy the tuples from the access table to the SQL one.
- OrderByTo order the tuples of a database.
- BackupTo create a backup of a database with asp.
- Paging techniqueTo use paging for the visualization of database records.
- DSN-Less connectionsConnect to a database without konwing the paht of database and without using a system dsn.
- Query on the datesIt allows to make queries on the dates on database Access.
- AuthenticationConnect to password protected database.
- Connect to ExcelScript for excel connection as datasource.
- Min and MaxMinimum and maximum of values contained in a table.
- UnionTo join the result of query on more tables.
- AVGCompute the average of a table fields.
- SUMCompute the sum of a table fields.
- RecordCountTo know how many record contains a table.
- To compact a databaseA useful function to compact an access database.
- GetStringTo see the content of a database table
- OLE-DB connectionConnessione al database.
- Data insertionTwo pages: one is the form for the digitation of the data, the other the form for the insertion in the database.
- Data deletionData deletion from database.
- Reading dataGets the data present in a database, putting 10 each page.
