Home

Submit

Source

Feeds
Tutorials » ASP » Database Integration

ASP Database Integration Tutorials

ASP Database Tutorials

ASP Database Integration
How to connect to MS SQL Server database
ASP / Database Integration
In this tutorial we will show you how to connect to MS SQL Server database.

Site: www.webcheatsheet.com Report - View Tutorial

ASP Database Integration
How to set up a system DSN
ASP / Database Integration
This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine.

Site: www.webcheatsheet.com Report - View Tutorial

ASP Database Integration
How to connect to an Access database with a DSN
ASP / Database Integration
DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. In this tutorial we will show you how to connect with a DSN to an Access database called 'examples.mdb' and retrieve all the records from the table 'cars'. Everything is commented so you won't have trouble.

Site: www.webcheatsheet.com Report - View Tutorial

ASP Database Integration
ADO and ADO.NET Connection Strings
ASP / Database Integration
This tutorial was created as an easy reference of various ADO and ADO.NET connection strings for the most popular database types. Connection strings are string variables which contain database connection information and then passed to ADO(ActiveX Data Objects) which will interpret them and act accordingly. Since there are going to be passed to ADO, they need to be in a comprehensible for ADO format.

Site: www.webcheatsheet.com 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
An Useful Method : RecordSet.Filter
ASP / Database Integration
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. Fileter method is advantage working on recordsets after querying on SQL command.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Filling Data into Select List
ASP / Database Integration
In this short ASP source code, we will pull some data from a database and fill it into a select list. We will create a custom and dynamic output.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Fight Against SQL Injection Attacks
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.

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
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 Database Integration
Creating Access Database Connection String
ASP / Database Integration
This tutorial contains a better and clean ASP code to create a sample connection string to an Access database. You may use this sample code in your applications.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Using GetRows To Get All Records From Table
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
How to Get Identity of New Record
ASP / Database Integration
Sometimes you need the learn new record number while your are adding a new record.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Using SUM Function in An SQL Statement
ASP / Database Integration
Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Compacting an Access database from ASP code
ASP / Database Integration
This source code can compact and repair your MS-Access database files. If you compact your access files regularly, it will work more faster and secure. Also you will save some hard disk space.

Site: www.dotnetindex.com Report - View Tutorial

 
Site Search

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