asp database related

a tutorial

1. xecuting 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
Search Within Search Results 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 ...
Speed up Database Access using GetRows 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.
Randomizing a Recordset This article describes several ways to use a SQL calculated field and the ORDER BY clause to arrange a recordset in random order. It provides a simple tool for verifying that the results are uniformly random. Also shows a technique for bubbling records ...
An Useful Method : RecordSet.Filter Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Fileter method is advantage working on recordsets after querying on SQL command.
Multiple Form Selection (Where In) Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. This example utilizes our db on the career statistics of Hammerin’ Hank Greenberg. The years he played are available to se...
DSN-less MS Access connection In order to connect to an Acees database with ASP through ODBC using a DSN file, you'll need to have full access to the server to create the DSN file, something that can be difficult if your site is hosted somewhere. This lesson will teach you an altern...
Simple Web-Database System Application This article will show how to connect an Access database to your Active Server Pages using Microsoft FrontPage. This is a beginning-level article with plenty of screen shots to show how to connect via ODBC, generate a SQL query in Access and construct t...
An Easy Way Delete A Record Delete a record from your database quickly and easily without having to use a recordset. Deleting a record from a database table is a simple task. Answer four questions below and click submit. The sql statement will be generated for you.
Two Table Join 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 state wa...
P

asp date time | asp development | asp email systems | asp error handling

asp database related…