A sample Web database can give you ideas about tying everything together and can even be used as a starting point for a Web project.

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0

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 our Access database called 'examples.mdb' and retrieve all the records from the table 'cars'.

At first we must create an instance of the connection object and feed it the location of the database we wish to connect to and the driver that we intend to use. For these purposes we will use a connection string. You can choose an ODBC or an OLEDB connection string. We will use OLEDB for our example as it's faster and more stable. Next, we should open the connection to the database:

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0

If you are developing a password-protected web site, you have to make a decision about how to store user password information securely.

What is "secure," anyway? Realize that the data in your database is not safe. What if the password to the database is compromised? Then your entire user password database will be compromised as well. Even if you are quite certain of the security of your database, your users' passwords are still accessible to all administrators who work at the Web hosting company where your database is hosted. Scrambling the passwords using some home-brewed algorithm may add some obscurity but not true "security." Another approach would be to encrypt all passwords in your database using some industry-standard cipher, such as the Message-Digest Algorithm 5 (MD5).

MD5 encryption is a one-way hashing algorithm. Two important properties of the MD5 algorithm are that it is impossible to revert back an encrypted output to the initial, plain-text input, and that any given input always maps to the same encrypted value. This ensures that the passwords stored on the server cannot be deciphered by anyone. This way, even if an attacker gains reading permission to the user table, it will do him no good.

MD5 does have its weaknesses. MD5 encryption is not infallible: if the password is not strong enough, a brute force attack can still reveal it. So, you can ask: "Why should I use MD5 if I know it is not the most secure?" The answer is fairly straightforward: it's fast, it's easy, and it can be powerful if salted. The greatest advantage of MD5 is its speed and ease of use.

It is vitally important to understand that password encryption will not protect your website, it can protect your passwords only. If your website does not have sufficient protection, password encryption will not make it safe from cracking. If your system has been cracked, a hacker can inflict a irreparable damage to it and also gain an access to confidential information, including passwords database. But if you store this information encrypted, hackers practically cannot make use of it. Cracking an encrypted password takes a large amount of time and processing power, even on today's computers.

There are no built-in MD5 functions in ASP. To enable MD5 encryption you should include md5.asp.


So, let's start. First of all, you need to add a new account to your database. The following code allows to do it.

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 3 Rating: 0.00 Votes: 0

This is called a singleton query. ADO.Net has specific functions for singleton queries, but not ADO (ActiveX Data Objects). This article describes how to use an ADO command object to perform faster singleton queries.

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0

sample code below and edit the tables to match yours.

You can store images in a Database to later access them. To do that,
you have to use the following code to get the image from the database.

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0

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.

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 4 Rating: 0.00 Votes: 0

You can upload your images to MS-SQL server with this simple script. To upload a picture to sql database, be sure Persist AspUpoad installed in you server.

Run create_image_table.sql on your sql server. This database holds some information about your image : size of image, width and height of image.

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 5 Rating: 0.00 Votes: 0

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.

In this example we have used our old database. There was a rating column holding the votes of our articles. We were using this simple script to check sum of ratings.

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0

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.

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0

some records to a database. This source code helps us to adding records to database without slowing down database.

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0