ASP Databases

<< Main ASP Directory
Page : 1 | 2 | 3 | 4 | 5 | 6 | 7
No HTML insert  
With this simple code, al html will be displayed as normal tags. This way your users are not able to use HTML statement which can be very damaging for your site.  

Paging through Recordsets  
Paging is a very useful way of presenting data. It allows you to show 5, 10 or whatever number of records you want per page and then show typical 'first page', 'last page', 'previous page', 'next page' etc buttons to navigate between pages. 

Running Stored Queries in Access Database 
In this tutorial we are going to talk about yet another powerful feature of database programming, Stored Queries. Most of the time we use ASP pages, we use them to retrieve or manipulate records in the database. These database connections are resource heavy and every query takes time on part of the server. Thus we should try to make use of everything possible to optimize and speedup database access as much as possible. One of the ways is to retrieve records as arrays which I discussed in my article ' Speeding up Database Access' earlier. Now we are going to talk about Stored Procedures which provide another way of optimizing database access. 

Simple Database 
I'm always getting requests for simpler DB samples... well this is about as simple as they get. It just reads the values from the table and puts them in an HTML table. 

Speed up Database Access using GetRows  
In the tutorials so far in the ASP & Database section, we have learned from connecting to the database via ASP to inerting, updating and selecting data from the database. 

SQLServerTools Object v1.0 
This one's like a double whammie! Welcome to the world of hard core SQL Server stored procedures and to the NextRecordset method of ADO's recordset object... Before we go on, this requires SQL Server. WON'T WORK WITH ACCESS.  

Turning numbers into graphs with ASP 
Ok so now you probably know how to get data from databases, text files, forms etc. But when it comes to displaying that data people mostly use tables or listings. 

Universal Table Editor 
Universal Table Editor is an ASP (Active Server Pages) application that can be used for every table in every database you can reach from your IIS (Internet Information Server) on Win NT-Server or PWS (Personal Web Server) on Win NT-WS / Win9x 

Update record  
Update a record in your database. The connection to the database is made in the include file and is called conn. Remember not to update autonumber fields that are primary key!!!  

Updating Records in the Database  
We have already discussed how to create DSN and show database contents in the ASP page in our tutorial Accessing Database from ASP. Then we moved on to learn how to add records to the database in the tutorial Adding Records to the Database. We will now see how to update the records in the database. 

Page : 1 | 2 | 3 | 4 | 5 | 6 | 7

Get the best ASP hosting with DiscountASP.NET - great value, money back guarantee.

Advertisements



MembersPro

MembersPro PayPal - ASP Membership software

Plug and play ASP membership script that integrates with PayPal to let you charge recurring membership fees.

Global ASP.NET Hosting Leader - Click Here