Home

Submit

Source

Feeds

Home » ASP » Database Integration ::

ASP Database Integration
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.
Related Tutorials
ASP Database Integration
Paging Records using GetRows
ASP / Database Integration
This article explains how to use GetRows to page through the records that you recieve from the SELECT. It's much faster than MoveNext, because it closes the database connection immediately whereas MoveNext loops through the records with the overhead of the database connection.

Site: www.devhome.org Report - View Tutorial

ASP Database Integration
Counting Records In A Database Table
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Counting Records In A Database Table
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Limit query results with the Recordset object
ASP / Database Integration
Here is an invaluable program that you can use to view and control the presentation of records in your database. We will use the Recordset object and the MaxRecords property via ADO, to set the number of records to return to the recordset and therefore to your screen. This is like a table in memory, holding records which are subdivided into individual fields.

Site: authors.aspalliance.com Report - View Tutorial

ASP Database Integration
Advanced SQL Techniques - Part 1: Analyzing Duplicate Records
ASP / Database Integration
In the first of this four-part describes a quick and efficient way to delete duplicate records from a table.

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

ASP Database Integration
Display Table on Web Page by Charles Carroll
ASP / Database Integration
This page demonstrates the capabilities how to display a table from a SQL statement. It illustrates not only how to display the table, but also how to detect that no records were returned from a query, and how to detect null and blank values in the data.

Site: www.learnasp.com Report - View Tutorial

ASP Database Integration
Deleting Records Using Stored procedure
ASP / Database Integration
We will continue working on our sample table. Now we will delete some records using stored procuder. To work on the code create a sample database and run this sql script.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Using Data Shape to create hierarchical recordsets
ASP / Database Integration
In this code code snips; we will create hierarchical recordsets using data shaping. We will create a new table using two data table. We will list results of one table with sub-records related to master table. Data shaping is an advanced technic to spend less server memory.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
How many records do I have in database table?
ASP / Database Integration
Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Updating Records Using Stored procedure
ASP / Database Integration
This code source is focusing on creating a simple stored procudure updating records in a table. Code is simple and clear, you may modify this code to use in your applications. To work on the code create a sample database and run this sql script .

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Display Top N records from MS Access
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP XML and ASP
ASP XML Admin Control
ASP / XML and ASP
This is a small Web Application, this contains basic XML functions using ASP including a XML driven user authentication, adding new records, viewing records, editing and deleting records.

Site: www.sourcesystems.net Report - View Tutorial

ASP Database Integration
How to Connect to Database using a Connection String
ASP / Database Integration
In this tutorial we will show you how to connect to our Access database called 'examples.mdb' and retrieve all the records from the table 'cars'.

Site: www.webcheatsheet.com Report - View Tutorial

ASP Database Integration
Fastest way of Database Access : Caching Records in Memory
ASP / Database Integration
In this step by step tutorial I will guide you to build the fastest method to display records from the database using plain ASP. The technique we are going to use is based on a simple fact that you don't have to hit database every time you want to display records.

Site: www.stardeveloper.com Report - View Tutorial

ASP Database Integration
Generating random records from the Database
ASP / Database Integration
In this article we will learn how to display random records from the database. From the articles so far, you will be able to display records from the database in a variety of ways and do a lot with them.

Site: www.stardeveloper.com Report - View Tutorial

 
Site Search

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