Sponsors
Database Management
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. Fileter method is advantage working on recordsets after querying on SQL command.
Price: Free Rate:
0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 Displaying Records From An Excel Database
Aim of this articles is to display records from an Microsoft Excel in an ASP. We could use general SQL command while retreving data from an excel sheet. All we need to know how to connect Excel file.
Price: Free Rate: 0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 Simple database techniques
When you start using ASP, you will begin working with databases. Interacting with databases can be very important. In this tutorial, we will be using a Microsoft Access Database along with technologies like ADO and the Connection and Recordset objects.
Price: Free Rate:
5.0(out of 5) Vote:1
5.0(out of 5) Vote:1 How to connect to database using a connection string
The power of Active Server Pages comes through when we tie databases to our web sites. To connect to a database, ASP uses what is called ActiveX Data Objects, or ADO for short. ADO comes with ASP, and can be used easily from your ASP pages. In this tutorial we will show you how to connect to Access database and retrieve all the records from the table.
Price: free Rate: 0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 Import text file to MS Access
This article will explain how to import the contents of a text file (.txt) to an Access Database when using MS text or OLE DB Drivers wont do! We will be using the FileSystem and TextStream objects in this article!
Price: free Rate: 0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 Make database access safer with transactions
You can use transactions in ASP as a kind of insurance policy for your database activities, making them safer and providing better error recovery. Transactions are most useful when doing multiple actions on multiple tables. The example below shows just how easy it is to use transactions from ASP, inserting a record into a table and doing a "rollback" if there's a problem
Price: free Rate: 0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 Delete Duplicates from a Database (MYSQL, MSSQL)
An easy way to delete duplicate data from a database such as MYSQL or MSSQL.
Price: free Rate: 0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 How to Encrypt Passwords in the Database
If you are developing a password-protected web site, you have to make a decision about how to store user password information securely. This article will show you how to encrypt user passwords with md5 algorithm and how to start using encrypted passwords if you already have users' database ready.
Price: free Rate: 0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 ASP Speed Tricks
This article describes practical methods of optimizing the performance of ASP pages which retrieve and display tabular data from a database. Test results of each coding technique show the potential for dramatic speedups of dynamic web pages.
Price: free Rate: 0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 How to delete database record in ASP - 3 simple steps
This tutorial shows how to delete database records using just the Connection Object, without the need to create a Recordset Object. Moreover, it explains why using a Recordset is bad practice for queries such as INSERT, UPDATE and DELETE.
Price: free Rate: 0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 Pages : 1 2