Explains everything in detail you'll ever need to know about creating Stored Procedures in Access Database and then calling from within ASP. Select, Update, Insert and Delete Stored Procedures are described. Sample code and database available for download.

Learn how to search a database with keywords.

This example / tutorial explains how to use the LIKE operator to perform a partial match on an Access database.

Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value. In this example, utilizing our db of US States (state, statename, and capital) the user can search in any of three fields (by dropdown menu input) rather than the application targeting one specific table element. Note: The db only has 50 observations in it, so it is better to search on single or double letter combinations.

Want to add value to your current search? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also. The following example utilizes a db on U.S. State capitals. Upon the first search two radio buttons will appear indicating a search (default) or a search within the current results. Searching within the current results will take the first search and add it to the new search and so on.

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.

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.

Displaying specific subsets of data from a database is easy to accomplish in .asp. The following example utilizes an Access database of Mark "The Bird" Fidrych and displays all of his season statistics for 1976 contained in the database rather than displaying the entire db.

This is an article on using Recordset. It uses GetRows method to speedup database access. One of the fastest ways of displaying database records with ASP. Sample Database and Code available for download.

Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more.