MSSQL and ASP - PowerPoint PPT Presentation

mssql asp l.
Skip this Video
Loading SlideShow in 5 Seconds..
MSSQL and ASP PowerPoint Presentation
MSSQL and ASP

play fullscreen
1 / 18
Download
Download Presentation

MSSQL and ASP

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)