ASP → Tips and Tutorials → Database-related

Bullschmidt ASP Web Database Sample

This sample ASP Web database can give you ideas about tying everything together and can even be used as a starting point for a Web project.

• Platforms
  • Windows
• Licenses
  • Freeware

Using GetRows To Get All Records From Table

Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.

• Platforms
  • Linux
• Licenses
  • Freeware

Using SUM Function in An SQL Statement

Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.

• Platforms
  • Linux
• Licenses
  • Freeware

Suggestion Box

Sample implementation (source code)illustrating how to implement a &"Suggestion Box&" style form using ASP and MS Access. Easily installed, and customized.

• Platforms
  • Windows
• Licenses
  • Freeware

Compacting an Access database from ASP code

This source code can compact and repair your MS-Access database files. If you compact your access files regularly, it will work more faster and secure. Also you will save some hard disk space.

• Platforms
  • Linux
• Licenses
  • Freeware

Counting Records In A Database Table

We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset.

• Platforms
  • Linux
• Licenses
  • Freeware

Executing Transact-SQL DELETE statement

In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database.

• Platforms
  • Linux
• Licenses
  • Freeware

Executing Transact-SQL UPDATE statement

In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database

• Platforms
  • Linux
• Licenses
  • Freeware

Executing Transact-SQL INSERT statement

In this example, we will add some records to a database. This source code helps us to adding records to database without slowing down database.

• Platforms
  • Linux
• Licenses
  • Freeware

Custom Paging in ASP

This source code displays results dividing to pages. Code provides Next Previous page links with numeric page numbers. You may modify source code to use with MS SQL or MS Access database. For this example, we have used MS SQL Server using sample data...

• Platforms
  • Linux
• Licenses
  • Freeware

Page:

• Previous
• 1
• 2
• 3
• 4
• 5
• ...
• 15
• Next