MSSQL & ASP

TO USE OR PRINT this presentation click : http://videosliders.com/r/31

==============================================================
MSSQL&ASP
,MSSQL & ASP Client-Server Relationship
HTML Basics Scripting Basics Examples ,Client-Server Relationship Client – user of an application
Sends requests to the server for a specific tasks (process data, obtain data, etc)
Uses HTML to tell web browser how to display data ,Client-Server Relationship Server – more specifically, ASP (Active Server Pages)
Receives requests from the client to perform a certain task
Processes data and sends results back to the client Uses scripting languages to process data (VBScript,PHP,JavaScript) ,HTML Basics HTML performs two essential tasks
Displays data
Submits data to be process ,HTML Basics Tags
HTML uses tags to format data
Tag Format: <command attribute1=“” attribute2=“”…> Some text here (optional) </command> Save in a text editor (or web editor like Dreamweaver) and open with IE, Netscape, etc. ,HTML Basics Example:
<html> <body> <p>This is a paragraph.</p> <p>This is a paragraph.</p> <p>This is a paragraph.</p> <p>Paragraph elements are defined by the p tag.</p> </body> </html> ,HTML Basics Common tags
<html> - starts all documents
<body> - all text is placed here <a> - links to other pages. Example: <a href="http://www.w3schools.com/">This is a Link</a> <table>,<td>,<tr> - formats data in table form <form> - allow the user to enter information (explained in next slide) Other tags - http://www.w3schools.com/html/html_reference.asp ,HTML Basics Forms - A form is defined with <form> tag
Structure: <form> <input> <input> </form> ,HTML Basics Form Example:
<form name="input" action="html_form_action.asp" method=“post"> Username: <input type="text" name="user"> <input type="submit" value="Submit"> </form> When user selects the “submit” button, the information in the form is submitted to the page “html_form_action.asp”.
Other form elements: http://www.w3schools.com/html/html_forms.asp ,VB Script Basics VB Scripts
Lightweight version of Visual Basic programming language
Can be placed anywhere in html code Run by server and sent back to client <% denotes beginning of the script %> denotes end of script Files with .asp extension will hold scripts (usually) ,VB Script Basics Example Script:
(saved as “example1.asp”) <html> <body> <% dim name name="John Harney" Response.write("My name is:<b>" & name & “</b>”) %> </body> </html> Dim – dimensions a variable (can be any type)
Response.write – writes html content to the html page Response Examples: http://www.w3schools.com/asp/asp_ref_response.asp ,VB Script Basics Example Form:
(saved as “example2.html”) <html> <body> <form name="input" action="example2.asp" method="post"> Grade: <input type="text" SIZE="3" name="grade"> <input type="submit" value="Submit"> </form> </body> </html> Form is “posted” to “example2.asp” with the text information “grade” when the user clicks submit
,VB Script Basics Example Form:
(saved as “example2.asp”) <htm "
Aucune note. Soyez le premier à attribuer une note !

Ajouter un commentaire

Anti-spam