Subscribe
Tutorial search

ASP Database Tutorials


We hope that you will enjoy our ASP Database tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own ASP Database tutorial to our site. Thank you !

Sort by:
MS SQL Stored Procedures and Classic ASP
MS SQL Stored Procedures and Classic ASP
Stored procedures offer an extra layer of security when interacting with a SQL database, they allow you to reuse frequently used database queries whilst avoiding duplicating statements throughout your site, and they offer a big performance increase over passing a string of SQL to the server.
Difficulty:
Display Top N records from MS Access
Display Top N records from MS Access
This sample ASP code will give us a good idea how to display top 10 records, if we are using MS Access. Because MS Access database has got some limitations which we can not choose a limited data rows from complete database table. Of couse if you using SQL server, there is no any limitations
Difficulty:
Using GetRows To Get All Records From Table
Using GetRows To Get All Records From Table
Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.
Difficulty:
Storing Images to Database and Retrieving to GridView
Storing Images to Database and Retrieving to GridView
Storing Images to Database and Retrieving to GridView
Difficulty:
Database Connection Strings
Database Connection Strings
Learn how to connect to different kinds of databases in ASP.
Difficulty:
Edit - Edit database information using Dreamweaver and ASP
Edit - Edit database information using Dreamweaver and ASP
Edit - Edit database information using Dreamweaver and ASP
Difficulty:
ASP.NET Delete - Delete Information stored in a database
ASP.NET Delete - Delete Information stored in a database
ASP.NET Delete - Delete Information stored in a database
Difficulty:
Retrieving Column Names with values
Retrieving Column Names with values
This tutorials based on a bit of knowledge on SQL. Sample code displays us how to get and show name of columns with values.
Difficulty:
Executing Transact-SQL UPDATE statement
Executing Transact-SQL UPDATE statement
In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database .
Difficulty:
Counting Records In A Database Table
Counting Records In A Database Table
We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset. .
Difficulty:
Executing Transact-SQL INSERT statement
Executing Transact-SQL INSERT statement
In this example, we will add some records to a database. This source code helps us to adding records to database without slowing down database. .
Difficulty:
Executing Transact-SQL DELETE statement
Executing Transact-SQL DELETE statement
In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database.
Difficulty:
An Useful Method : RecordSet.Filter
An Useful Method : RecordSet.Filter
Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Filter method is advantage working on recordsets after querying on SQL command.
Difficulty:
Introduction to ActiveX Data Object (ADO)
Introduction to ActiveX Data Object (ADO)
This tutorial provides you a quick introduction of ActiveX Data Object (ADO), and a simple example of using ADO to work with MS Access database.
Difficulty:
Using MS Access Databases
Using MS Access Databases
This tutorial will help you understand: Connecting ASP Pages to MS Access Databases; Persisting Data to MS Access Databases; Protecting Data in SQL Statements.
Difficulty:
Total Tutorials in Category: 111