3024-Chap19 - 19. DYNAMIC WEB PAGES: INTERACTING WITH...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
19. DYNAMIC WEB PAGES: INTERACTING WITH DATABASES We’ve now seen how to construct static web pages and dynamic web pages for user input. The final step is to be able to interact with a database. In this chapter, we’ll see how we can connect with a database over the Web. We’ll do this by completing our Anna’s Books web site, again using VWD . 2010 John P. Shewchuk ISE 3024 Course Notes 19 – 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
o interact with databases we first need some language To interact with databases, we first need some language for adding/modifying data or generating queries. What can we use? Additionally, we need ome way to connect to the database generate our some way to connect to the database, generate our query and send it to the database, and retrieve the results. • some way to display the query results. 2010 John P. Shewchuk ISE 3024 Course Notes 19 – 2
Background image of page 2
WD rovides a set of Web controls called ata controls VWD provides a set of Web controls called Data controls which makes these activities very easy. They can be divided into two sets: Data source controls allow us to connect to a atabase send queries database, send queries, and receive results. ata isplay controls Data display Data display controls allow us to display the results. controls These controls can be found in the Toolbox , as hown at right Data source controls 2010 John P. Shewchuk ISE 3024 Course Notes 19 – 3 shown at right.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
he basic approach for employing these controls to interact The basic approach for employing these controls to interact with a database is always the same: 1. Select and drag a data source control to the web page. Se ec a d d ag a da a sou ce co o o e eb page onfigure e data source control (specify the Configure the data source control (specify the database, generate the query). 2. Select and drag a data display control to the web page. Bind the data display control to the data source control, configure the data display control (formatting, etc.). 2010 John P. Shewchuk ISE 3024 Course Notes 19 – 4
Background image of page 4
et’s go through these steps for each Anna’s Books web Let s go through these steps for each Anna s Books web page, from Chapter 18, which interacts with a database: CustomerBrowse.aspx CustomerSearch.aspx CustomerEdit.aspx CustomerEdited.aspx We also need (of course) a database. We have two Anna’s Books databases from our previous chapters: B k d b AnnasBooks.accdb AnnasBooksSQL.mdf 2010 John P. Shewchuk ISE 3024 Course Notes 19 – 5 Which should we use?
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
hile it is possible to use Access for a Web- ased While it is possible to use Access for a Web based database (via the AccessDataSource data source control), this is not recommended. • Access designed as a single (or few)-user stand-alone database. Does not perform well in multi-user nvironments environments.
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/14/2010 for the course ISE 3024 taught by Professor Staff during the Spring '08 term at Virginia Tech.

Page1 / 94

3024-Chap19 - 19. DYNAMIC WEB PAGES: INTERACTING WITH...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online