Home

Submit

Source

Feeds

Home » ASP » Database Integration ::

ASP Database Integration
Security issues became more damageful if you're not protecting your web forms. Following example is a good idea to protect our ASP pages against SQL injection attacks. This small ASP code secures and validates all information coming from your forms.
Related Tutorials
ASP Database Integration
SQL In Simple English - Part II
ASP / Database Integration
This article mainly deals with SQL Joins and SQL sub-queries. Both of these are extremely useful SQL constructs and should be learnt by all beginners.

Site: stardeveloper.com Report - View Tutorial

ASP Database Integration
Using SQL-DMO To Backup and Verify a Database
ASP / Database Integration
This article "Using the SQL Distributed Management Objects", provided an overview of SQL-DMO. This article expands upon those concepts by showing you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database.

Site: www.asp101.com Report - View Tutorial

ASP Database Integration
SQL In Simple English - Part 1
ASP / Database Integration
Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more.

Site: stardeveloper.com Report - View Tutorial

ASP Database Integration
SQL Reserved Words
ASP / Database Integration
Many times people will make the mistake of naming a database field with an SQL Reserved word. This is an easy mistake to make. It's hard to remember EVERY single one. Here's a concise listing of SQL Reserved words to help you along.

Site: pacosdrivers.com Report - View Tutorial

ASP Database Integration
Fun With Stored Procedures
ASP / Database Integration
A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others ... A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates... as an added bonus, it further separates the sql statement from your asp leaving you with more readable code. So let's get on with it.

Site: www.aspemporium.com Report - View Tutorial

ASP Database Integration
Basic ADO and SQL Tutorial
ASP / Database Integration
Learn how to use the ADO Connection, Command, and RecordSet object with simple SQL statements with ASP (Active Server Pages).

Site: aspalliance.com Report - View Tutorial

ASP Database Integration
AddCriteria Simplifies SQL Queries
ASP / Database Integration
The AddCriteria function (listed later) elegantly encapsulates the logic to build an SQL statement by adding optional criteria only if the user posted data for a field.

Site: www.15seconds.com Report - View Tutorial

ASP Date and Time
Returning Month of Date in an SQL Table
ASP / Date and Time
This is an useful but not known functions. If you wish to learn month of date stored in a database, you may use this function placing in a 'SELECT' sql statement.

Site: www.dotnetindex.com Report - View Tutorial

ASP Scripts
SQL Script for Stored Procuder Samples
ASP / Scripts
This sql script creates a sample table to use for some code snipts. First create a database and run this code in Query Analyzer.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Upload - to database, or not to database?
ASP / Database Integration
To database or not to database? What to do with uploaded files on server-side? This article contains performance tests of several store-file methods in server-side ASP.We test store files to disk, to MDB file using ADO recordset, to MS SQL 2000 using ADO recordset and to MS SQL 2000 using SQL UPDATETEXT command.

Site: www.motobit.com Report - View Tutorial

ASP Database Integration
Add records with sql statments
ASP / Database Integration
Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.

Site: nuts4asp.com Report - View Tutorial

ASP Database Integration
Edit records with sql statements
ASP / Database Integration
Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.

Site: nuts4asp.com Report - View Tutorial

ASP Database Integration
Getting Your Quotes Right In SQL For ASP
ASP / Database Integration
It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedence? This article will answer these questions.

Site: www.webdevelopersjournal.com Report - View Tutorial

ASP Scripts
Custom Paging in ASP - Fast And Easy
ASP / Scripts
This source code displays results dividing to pages. Code provides Next Previous page links with numeric page numbers. You may modify source code to use with MS SQL or MS Access database. For this example, we have used MS SQL Server using sample database Northwind.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
How to create DSN for Microsoft SQL Server
ASP / Database Integration
This article will help you to create a System Data Source Name (DSN) for Microsoft SQL Server on your local machine.

Site: www.devasp.com Report - View Tutorial

 
Site Search

 
Categories
2D Graphics 3D Graphics Office Applications Databases Desktop Programming Web Development
 
Advertisement