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.
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.
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.
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.
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.
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.
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.