Tuesday, September 15, 2009

Reflection on the 1st Class Activity ~ Registration Page

Hello friends :) this is my simple reflection on our first class activity using Dreamweaver which is Registration Page..We used ASP (Active server pages)..
First of all,we must install Dreamweaver CS3 software :) Below are the steps needed in order to built this application..

Step 1:Setup a site
- Create new site using Site>New Site
- Then, set up the HTTP Address (URL)
- You need to use ASP VBScript server technology.
- Don't forget to test your URL.

Step 2:Setup the Database file in Access
- Open Misrosoft Access,then click at Database to create new database.
- File will be save at C:/inetpub/wwwroot/file name
- Save it with .mdb file extension.
- Then you can create your application in the table.
- Save your work as Table 1.

Step 3:Setup the connection
- Open ASP page in Dreamweaver.
- Then click Window>Database to open Database panel.
- Enter the connection string to the database.
- After that, don't forget to Test your connection.

Step 4:Setup the contact form
- Create new page by clicking File>New>Blank Page>ASP VBScript>Create
- Insert Form.
- Using Labels, Text boxes and text area layout, form the application.
- Remember to insert Submit button in your form.
- Then, Save it as contact.asp.

Step5:Writing a data into a database using the Insert Record
- Insert Record is a server behaviour taht will be used to store data into a database file.
- Before install the extension, close all file in Dreanwesver.
- Then, click Site>Advanced>Remove Connection Scripts. Close Dreamweaver. Open Adobe
Extension Manager CS3.
- Activate Server Behaviors tab and click Plus (+) button. Then select Insert Record.
- When the form appears, make sure i the form elements section, each text field will be inserted
into the correct field in MS Access. Then click OK.
- Save your file.

Step6:Reading a data from a database using the RecordSet.
- RecordSet is a server behavior that will be used to read back data from a database file.
- Create the application using Table.
- Activate Server Behaviors tab. Click plus (+) button on the panel, select RecordSet (Query).
- When the dialog box appears, select the connection taht you had created before.
- Next, activate Bindings tab. Click plus (+) button on the panel, select RecordSet (Query).
- Drag your data into the cell in the table that you created in view.asp.
- Draw a line below the table.
- Highlight the table including the line. Click plus (+) button on the panel, select Repeat Region.
- Then, click OK. Don't forget to save your file.

Step 7:Execute the file.
- Open back your contact.asp file.
- Double click Insert Record behavior in Server Behavior window and add view.asp in after
inserting go to:section. Click OK.
- Save your contact .asp file.
- Click at Preview in Browser icon.
- Finally, your application is done if it is running smoothly :)