Real-Time Data Grid Part 1/2
(Page 1 of 5 )
In part one of this two-part article Annette, show us how to create an ASP class that allows us to work with our databases through a web browser. It will allow us to update and delete records dynamically using JavaScript and XMLHTTP, without ever having to refresh the page.Data management applications allow us to modify data for a number of different data systems including databases, files, the Windows registry, etc. Data manipulation is an extremely important activity, and sometimes it's impossible to be in front of the computer where your data is stored if you are required to modify that data.
Fortunately, because of the wide and diverse range of technologies that are available to developers today, it's not too difficult to create a set of ASP scripts that allow us to update data in a Microsoft SQL Server 2000 database in real time.
In this two-part article we're going to take a look at how to create a class that will display rows from a database in a web browser. Each of the fields in these rows can be updated dynamically, and each row can also be deleted: without every refreshing the page in our web browser.
To use the class that we will be building in this article, you should have access to a Windows 2000 web server running IIS 5 and SQL Server 2000. Because the class will use client-side JavaScript and the MSXML4 library to dynamically update the server-side database, the client machine executing the ASP script should have Microsoft Internet Explorer 5.5 or above installed.
Next: Project Overview >>
More ASP Articles
More By Annette Tennison
/ 8 
