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.