Tuesday, May 3, 2011

ASP Exersice 1

** Hihi everyone, today i will share with you about the ASP exercise by using the Dreamweaver CS3. before we start, the most important thing that u need to do in your desktop or laptop is install Internet Information Services (IIS) from the CD that you usually used for installing window after formatting



** After you installing the IIS from your services pack CD, then the Inetpub folder will appear in your C-drive. then inside the Inetpub folder you can create a folder named project and data because later you will need these 2 folder in filling your product.

Steps:

1.
First of all create a new site in Dreamweaver CS3 by follow the note given by lec. Save the new site in c:\inetpub\wwwroot\project.

2. Then, 2. open Microsoft Office Access and create a database in Access like the procedure in note and save the database in the folder c:\inetpub\wwwroot\data. The database MUST save in MS Access 2002-2003 with .mdb file extension.

3. After setup the database, save again the data.mdb file and close Access window.

4. Then, go to Adobe Dreamweaver CS3 and open a ASP page, we want setup the connection string. my connection string is Driver={Microsoft Access Driver (*.mdb)};DBQ="& Server.MapPath("/data/data.mdb"). Then, click test to connect to database. 5. Create a new ASP VBScrip page. Insert a form. Insert a table and insert the text and text field like given in the tutorial1 lecture note.
6. Save the page in project folder as as contact.
7. Close your contact.asp first then open back your contact.asp and then Click Server Behaviors tab. Click the + button, select RecordSet. Select the connection that you had created.
8. Create another new ASP VBScript file, save this file in project folder also. Save the name as view.asp. Then draw the table for name, username, password and remarks.
9. Activate Bindings tab. Click + button select RecordSet. Click at + button sign in front of the RecordSet and you can see all the fields in the database.

14. Drag nama into cell 1 in column 2 in the table that you create in contact.asp. Drag other fields also into the following cell in column 2. Draw a line below the table. Next highlight the table including the line below the table. Click the + button on the panel, select Repeat Region. Click ok.
15. follow the steps in instruction note then u will produce your own ASP database.







No comments:

Post a Comment