- 1,251 categories
- 40,829 scripts
- Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is...
- 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 ...
- Outputting data from two tables is almost as easy as displaying from one. This example utilizes two
tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each sta...
- You can connect to an Access database within an ASP page with different methods. This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine.
- Multiple level select boxes tackled with hierarchical data! This sample illustrates the concept using a hierarchy consisting of geographical region, country, and state data. The code expects a system DSN by name &"Hierarchy&" and ac...
- The purpose of this article is to show how to get records from an html form and submit that form to an ASP page. This ASP page will then use SQL to enter the records into the database.
- Now everybody can connect to a database. Simple database access is a huge feature of ASP and one of the most widely used by developers but when you are first learning, it s hard to separate the database stuff from the rest of the code so I made this ...
- This is an introductory tutorial on ASP data access. It covers Connection Object, Command Object, and Recordset Object.
- Complete tutorial on editing and updating records in the database. Each and every step explained in detail for ASP beginners. Both Connection and Recordset Objects discussed.
- This is a complete tutorial on adding records to the database via ASP for beginners. Both Connection and Recordset Objects discussed. Also get an insight on ''insert'' SQL statement.
Page: