Finally we manage to complete the assignment...
1. Open ASP VBScript in Dreamweaver, create < New Site and name your site. Before that you
must make sure that your computer has inetpub and functioning as well.
2.**Remember not to create your inetpub manually, it doesn't help at all...
3. Follow all the instruction in the handout.
4. Create new blank page in Access, name your file and save it in inetpub by using Access
2002-2003 with .mdb file extension.
5. Type in the information for your form in Access, in this activity we create a Registration Page
with the details below:
i. Name
ii. Username (make sure no spacing between user and name)
iii. Password (click on password button in properties so that it would be hidden when viewed)
iv. Remarks (make sure the data type is in memo form)
6. Setting up connection is a crutial part where it determine whether you can continue or not.
Open an ASP page in Dreamweaver, Window>Database, click the + button on the panel, select
CCS from the menu. Type the connection name as 'dmx' and the connection string. (you may
use the connection from e-learning "Driver={Microsoft Access Driver (*.mdb)};DBQ="&
Server.MapPath("/data2/data2.mdb"), change the bolded word to your file name. Click
'Test'.
7. If the connection is successful, we can continue...
8. Setup the contact form. Create a new page in Dreamweaver. File>New>BlankPage >ASP
VBScript>Create.
9. Insert Form, type in "Registration Page and the intruction", insert table where it contained 4
rows and 2 columns.
10. Type in the details
i. Name
ii. Username
iii. Password
iv. Remarks
11. For each column, insert < form < text field, change the name in properties and the characters
width. For "Remarks", we need to use multiline in properties where our group choose 5 lines
for remarks in 'Num lines'. Insert < form c:\inetpub\wwwroot\sitename\
12. Go to Dreamweaver >Application > Server Behaviors > click (+) , click 'Insert Record', a pop
up window will appear, make sure the connection is 'dmx' or other connection name, 'Table1'
will appear. We can also insert the 'view.asp' in the window beside "Browse". Save the file.
13. Create a New ASP VBScript, save the file as 'view.asp' in the same location with contact.asp file. Create layout using table like just in Access.
14. Activate Server Behaviors, click (+) button > RecordSet(Query).
15. A dialog box will appear, select sort, type in name and ascending to sort the data (viewing).
16. Click Test. Click OK in the dialog box and click OK again.
17. Activate Binding tab, click (+) on the panel , select RecordSet and we will see all the fields in
the database. Drag all the details to the related text field in the columns accordingly in
view.asp file.
18. Draw a line below the table. Highlight the table and the line. Click (+) button and select
'Repeat Region'. Make sure the Recordset1 is selected and choose All Records and click OK.
(File < Save).
19. Open back contact.asp file, double click insert Record Behaviors window, click preview with
firefox in Browse icon.
20. Type any data and click 'Save' button.
21. The view.asp file will be displayed and the data that you type will be viewed.
22. View contact.asp file agian and type other name and details. The next data will be viewed in contact asp file.
Tuesday, September 15, 2009
Dreamweaver .....
Hi,
I don't know if there is anybody like me, feeling rather stressed with it. Not so sure with the concepts and steps. really need to work harder...
I don't know if there is anybody like me, feeling rather stressed with it. Not so sure with the concepts and steps. really need to work harder...
Subscribe to:
Posts (Atom)