Back to Top
The nuts and bolts for
Creative web development

Scripting a Database

A short SQL Server 2000 tutorial explaining how to script a complete database with roles and logins and all other objects for a future empty database that resides in a single .sql text file.

The project used is the upsized Access database that comes with the Dreamweaver Learningsite command.

December 17, 2002 Author: Dennis van Galen Rating:

Index Tuning Wizard

A short SQL Server 2000 tutorial explaining how to use the SQL Profiler in combination with the Index Tuning Wizard to optimize your database.
December 17, 2002 Author: Dennis van Galen Rating:

Windows Forms Data Binding

One of the most powerful aspects of .NET and Windows Forms is data binding. Historically, data binding was used to bind views to data stored in databases. Some database management systems, such as Microsoft Access, have provided GUI APIs to help developers quickly bind to data.

 

This sample is taken from Chapter 6: "Windows Forms Data Binding" of the Blue Vision Title "Developing .NET Custom Controls and Designers using C#"

December 13, 2002 Author: James Henry Rating:

Preview Image with File Field

This short tutorial will show you how to attach a pre-view button to your file field, so you can see what image your uploading before actual hitting the upload button.

Note: the script view below gets truncated due to the width of the page, please copy/paste the javascript from the example (right-click>view source).

December 12, 2002 Author: Marcellino Bommezijn Rating:

Alter a DB Online

If you develop ASP Websites using an Access database, you have probably been faced with the need to change the structure of your database, so what do you do?  First you download your database to your local environment, then you make your changes, then you upload your changed database to your Web server.  Easy enough except sometimes this is not pratical, for instance:

  • Your website/database is in constant use
  • Uploading your database while someone is accessing it can have unpredictable results
  • Database transactions can be lost or corrupted
  • Your database is extremely large

There is an alternative way to alter your database using ASP and SQL.  I will show you some basics:

  1. We will create a database table
  2. We will add a primary key to it
  3. We will add a unique index to it
  4. We will create a view or query
December 3, 2002 Author: Jesus Torres Rating:

Advanced Mailer and COM Program Test

This advanced mailer component test will not only show you which components are installed on the host server, but can also test to ensure that the mailer components are configured correctly by attempting to send an email with each mailer component you specify.

Mailer Components Supported:

  • CDONTS/Chili!Mail
  • ASPMail
  • ASPQMail
  • JMail
  • SA-Smtp Mail
  • ASPEmail

There's a further 308 COM objects that you can check on your host server.

November 22, 2002 Author: James Harris Rating:

Credit Card Validation and Verification

This chapter goes through credit card validation and verification, such as is vital during the checkout procedure of an online shopping application. The chapter as a whole covers all aspects of the checkout procedure in detail.

This sample is taken from Chapter 7: "Credit Card Validation and Verification" of the Glasshaus title "Usable Shopping Carts"

November 21, 2002 Author: George Petrov Rating:

Wireframing

This chapter introduces you to the concept of making wireframes of web site projects, and how to create them. The rest of this chapter looks at creating UI specs and prototypes. These three topics are important when designing a professional web site to allow you to keep the client and the rest of your team clear about how the design is progressing, and to be able to communicate requested changes.

This sample is taken from Chapter 3: "Wireframes" of the Glasshaus title "Usable Shopping Carts"

November 21, 2002 Author: George Petrov Rating:

Dynamic DHTML Scroller

The tutorial will explain the process of creating a Dynamic DHTML scroller with data drawn from a database. The tutorial is easy to follow and you will not need to code either ASP or DHTML. Dreamweaver and it's extensions will do the job for us. We will use ASP, VBScript with Access2000 database for behind the scenes jobs and use Cross Browser Autoscroller to achieve the DHTML effect.
November 20, 2002 Author: ranjan datta Rating: