This database class handles Select, Insert, Update, and Delete. It also takes steps to ensure your SQL syntax is valid, and that memory leaks / errors are prevented. Tutorial comes with demo, downloadable code, and an in depth explanation.

Category:

ASP > Tutorials > Database-related

Date Added: Aug 24, 2005 Hits: 441 Rating: 4.67 Votes: 3

Learn how to search a database with keywords.

Category:

ASP > Tutorials > Database-related

Date Added: Jul 17, 2005 Hits: 391 Rating: 2.00 Votes: 1

It is very common operation to request one field of information via a database query. This is called a singleton query. ADO.Net has specific functions for singleton queries, but not ADO (ActiveX Data Objects). This article describes how to use an ADO command object to perform faster singleton queries.

Category:

ASP > Tutorials > Database-related

Date Added: Jul 23, 2005 Hits: 222 Rating: 0.00 Votes: 0

Learn how to get a stored image from a database and display it on a page.

Category:

ASP > Tutorials > Database-related

Date Added: Jun 8, 2005 Hits: 964 Rating: 4.00 Votes: 1

This writing will discuss several things to do to ensure the application migration carried on in a good way, particularly for ASP Database applications and to overcome possible problems might occurred. Basically, migrating ASP to Linux means you have to convert to database supported by Linux platforms. Currently, Chili!Soft ASP is already supporting MS Access but not all web hosting companies install this feature. They prefer to use more common database in Linux such as MySQL and PostgreSQL. Pay attention to some Chili!Soft specific ADO methods and properties, since there are slight differences with IIS ASP. You might need to convert some codes in your applications to make it run in Chili!Soft ASP.

Category:

ASP > Tutorials > Database-related

Date Added: Aug 6, 2005 Hits: 357 Rating: 5.00 Votes: 1

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.

Category:

ASP > Tutorials > Database-related

Date Added: Jul 19, 2005 Hits: 630 Rating: 5.00 Votes: 5

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.

Category:

ASP > Tutorials > Database-related

Date Added: Jun 22, 2005 Hits: 711 Rating: 3.25 Votes: 4

Sometimes you need the learn new record number while your are adding a new record. Following example adds a new records to a table and gets the the autonumber or identity of that records.

Category:

ASP > Tutorials > Database-related

Date Added: Jul 17, 2005 Hits: 852 Rating: 2.75 Votes: 4

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.

Category:

ASP > Tutorials > Database-related

Date Added: Aug 10, 2005 Hits: 714 Rating: 0.00 Votes: 1

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

Category:

ASP > Tutorials > Database-related

Date Added: Jun 26, 2005 Hits: 906 Rating: 3.00 Votes: 1