1 / 18

MSSQL & ASP

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

ostinmannual
Download Presentation

MSSQL & ASP

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MSSQL&ASP

  2. MSSQL & ASP • Client-Server Relationship • HTML Basics • Scripting Basics • Examples

  3. 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

  4. 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)

  5. HTML Basics • HTML performs two essential tasks • Displays data • Submits data to be process

  6. 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.

  7. 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>

  8. 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

  9. HTML Basics • Forms - A form is defined with <form> tag • Structure: <form> <input> <input> </form>

  10. 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

  11. 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)

  12. 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

  13. 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

  14. VB Script Basics • Example Form: (saved as “example2.asp”) <html> <body> <% Dim grade entry = Request.Form("grade") If entry > 90 Then Response.write "<h3>You have an A</h3>" elseif entry > 80 Then Response.write "<h3>You have a B</h3>" elseif entry > 70 Then Response.wrtie "<h3>You have a C</h3>" else Response.write "<h3>You have an F</h3>" End If %> </body> </html> • Request.Form is the “posted” information from the form in “example2.html” • “grade” is the name of the text that was submitted

  15. ASP • ASP • Combines html and scripting with a database • Accesses the database and uses the information in data processing

  16. ASP • ASP – commands for accessing database <% set adocon = server.CreateObject("ADODB.Connection") set adorec = server.CreateObject("ADODB.recordset") adocon.Open("dsn=cscmssql1; uid=username; pwd=password;") adorec.ActiveConnection=adocon %> • After connection is made, enter the sql command and use it: <% sqlText = “select * from database” Adocon.Open sqlText %>

  17. ASP • ASP Example – Sporting Goods Retailer • Contains the following 3 tables: • Product (prodID,name,quantity,cost) • Customer (custID,name,cardNo) • Cp (custID,prodID)

  18. References • www.w3schools.com – HTML,VB,ASP • www.learnasp.com – ASP validation and cookies • www.uncg.edu/mat/DatabaseProjects - Mathematical Science Database Page • Email: jfharney@uncg.edu • Office: Bryan 384 (W F 1-5)

More Related