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.
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#"

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).

Color and Web Design

This chapter introduces the basics of color theory, choosing color schemes that work, and good practice when dealing with color on the Web.

 

 

This sample is taken from Chapter 2: "Colors" of the Glasshaus Title "Web Graphics for Non-Designers"

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
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.

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"

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"

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.
Retrieve inserted ID with Stored Procedure and @@identity
Here's a quick and dirty tut on how to retrieve the just inserted records ID with the use of Stored Procedures in SQL Server using the @@identity function
Newer articles Older articles