Advertisment

Professional C# 2nd Edition : Data Access with .NET

Complete Online Chapter 'Data Access with .NET' from Wrox Press book 'Professional C# 2nd Edition'. Topics covered include...

Views: 0 | | by Mathew
ASP - Database Related

SQL In Simple English - Part 1

Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more.

Views: 682 | | by Steve
ASP - Database Related

Connecting to your SQL Database

If you have an SQL database set up with your web host, a useful tip to know is how to connect to your SQL database via Enterprise Manager. The...

Views: 703 | | by Source
ASP - Database Related

Compact & Repair Access Database

Compact and repair your access database online from ASP code. This is example code of how this can be done.

Views: 708 | | by Sarah
ASP - Database Related

Analyzing Duplicate Records

This is the first of the four-part 'Advanced SQL Techniques' series, which describes a quick and efficient way to delete duplicate...

Views: 670 | | by Stephen
ASP - Database Related

Using Triggers to Track Database Action History

This article describes how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular database table in...

Views: 678 | | by David
ASP - Database Related

Randomizing a Recordset

This article describes several ways to use a SQL calculated field and the ORDER BY clause to arrange a recordset in random order. It provides a...

Views: 742 | | by Donald
ASP - Database Related

Using Multiple Recordsets

This article explains a solution on how to increase the performance of your ASP pages that rely on gathering data through several different...

Views: 675 | | by Marry
ASP - Database Related

Fastest way of Database Access : Caching Records in Memory

A step by step tutorial on caching data in memory. This tutorial goes one step further from simply caching data in memory to allow you to set a...

Views: 595 | | by Simon
ASP - Database Related

Using Disconnected Recordsets

This article covers rarely discussed feature of ADO Recordsets, disconnected Recordsets. It examines what disconnected Recordsets are, how to use...

Views: 662 | | by Simon
ASP - Database Related

Printing Headers on every page of a report (from a database)

The author writes 'Recently I was asked to develop a web based report that would collect data from a database, format it in an HTML page and...

Views: 661 | | by Nick
ASP - Database Related

Interrogating a Stored Procedure with ADO

This article describes how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. It shows how to create the...

Views: 696 | | by Jarry
ASP - Database Related

SQLServerTools Object

This example shows how to get a list of all current tables in the database, get a list of dependent stored procedures for each table and do it all...

Views: 636 | | by Steve
ASP - Database Related

AddCriteria Simplifies SQL Queries

AddCriteria is a small function that simplifies the code needed to produce a SQL query from a set of optional criteria posted by a user. This...

Views: 716 | | by Daniel
ASP - Database Related

Database Editing Sample

This is a quick sample code which combines a number of database functions into one script. Includes functions to add, delete, and edit records in a...

Views: 719 | | by Daniel
ASP - Database Related

Creating Custom Hierarchical Recordsets

This article covers two advanced ADO topics: creating hierarchical Recordsets (via data shaping) and creating custom Recordsets. Specifically, this...

Views: 692 | | by Donald
ASP - Database Related

Using SQL-DMO To Backup and Verify a Database

This article shows you how to use SQL-DMO to create an Active Server Pages application to backup and verify a SQL Server database. The SQL...

Views: 596 | | by Tutorial
ASP - Database Related

Turn foreign keys into list boxes

The author writes 'CoverYourASP's original database administration tool didn't look for foreign keys, and just displayed a confusing...

Views: 713 | | by Donald
ASP - Database Related

What's in an ADO Connection String?

This article explains ADO connection strings and parameters. By the end of the article you should be able to build appropriate ones on your own...

Views: 0 | | by Adam
ASP - Database Related

Name Search & Hyperlinks to Detail

This is an example code showing how to conduct searches on a database to display hyperlinked summaries that can be clicked on to display detail data.

Views: 713 | | by Marry
ASP - Database Related