Home arrow ASP arrow Page 5 - Real Time Data Grid Part 2/2

Real Time Data Grid Part 2/2

In this article Annette wraps up the details of the real time data grid that she started to describe in part one of this two-part article. She looks at the JavaScript code that contacts our database server and allows us to update data in a database without actually refreshing the page.

Author Info:
By: Annette Tennison
Rating: 5 stars5 stars5 stars5 stars5 stars / 21
February 08, 2002
  1. · Real Time Data Grid Part 2/2
  2. · The JavaScript code
  3. · The JavaScript code (contd.)
  4. · The doDel JavaScript function
  5. · Using our DynamicGrid class
  6. · Conclusion

print this article

Real Time Data Grid Part 2/2 - Using our DynamicGrid class
(Page 5 of 6 )

Because everything we need to use our DynamicGrid class is encapsulated into one ASP file, all we have to do is make a slight modification to the file in order for it to work. Make sure the strConnectionString variable is set to connect to your SQL Server 2000 database correctly. If you want to test it with your own database, then change the value of the "Initial Catalog" part of the connection string to match the name of your database. Also make sure that the user ID and password fields are correct for your server.

Create a new ASP page called testgrid.asp and save it in the same directory as dynamic.datagrid.asp in a directory that IIS can access. Enter the following code into testgrid.asp:

<!-- #INCLUDE file="dynamic.datagrid.asp" -->


Dim dg1

Set dg1 = new DynamicGrid

dg1.TableName = "authors"


dg1.DisplayGrid "100%", 1, "#E7E3E7", "#BDDBFF", false, false


That's all the code we need to use our DynamicGrid class in any ASP page. As you can see, I've made the CanEdit and CanDelete arguments false, so when the page is displayed we don't have the option to update or delete records:

Showing our grid without the ability to update or delete records
blog comments powered by Disqus

- Central Scoreboard with Flash and ASP
- Calorie Counter Using WAP and ASP
- Creating PGP-Encrypted E-Mails Using ASP
- Be My Guest in ASP
- Session Replacement in ASP
- Securing ASP Data Access Credentials Using t...
- The Not So Ordinary Address Book
- Adding and Displaying Data Easily via ASP an...
- Sending Email From a Form in ASP
- Adding Member Services in ASP
- Removing Unconfirmed Members
- Trapping HTTP 500.100 - Internal Server Error
- So Many Rows, So Little Time! - Case Study
- XDO: An XML Engine Class for Classic ASP
- Credit Card Fraud Prevention Using ASP and C...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials