Wiley 978-0-7645-4375-3 Datasheet

Browse online or download Datasheet for Software manuals Wiley 978-0-7645-4375-3. Wiley Beginning ASP.NET Databases Using VB.NET User Manual

  • Download
  • Add to my manuals
  • Print
  • Page
    / 23
  • Table of contents
  • BOOKMARKS
  • Rated. / 5. Based on customer reviews
Page view 0
Displaying Data on the Web
When the Web first appeared, people had to find a metaphor for how information should be presented
on it. If you took a sample of web sites from that period, the content largely was based around what
you'd find in traditional media such as books, magazines, and newspapers. This led to the Web serving
the same purpose as those other formats: it provided a snapshot of information as it stood at the time
the pages were created. Of course, there was nothing wrong with that, but it placed restrictions on what
the Web could reasonably be used for.
Over time, the technologies powering the Web have matured, and it has changed from only being able
to provide static sites, to providing dynamic applications as well. These applications invite their users to
make choices about the information they're interested in, providing a customized user experience that
can be modified in real time.
The key to these applications is the data they contain. Regardless of what it is – it could be a product
catalogue, or a set of customer details, or a document repository – it's the data that makes them
dynamic. In the past, providing data over the Web has been a harder task than providing it through
traditional desktop applications, due both to the development tools and functionality available, and the
nature of the Web itself, where users are far removed from the applications and data. Over time, and in
particular (from our point of view) with the introduction of Microsoft's .NET Framework, this situation
has been improved. Web application developers are now on a more equal footing with their desktop-
developing counterparts.
In this first chapter, we'll provide a broad introduction to the topic of data-driven web sites, and how
they are implemented in ASP.NET. It starts with a discussion of the advantages and disadvantages of
data-driven sites, and then moves on to examine the sources that such data can come from. After that,
we'll look at the .NET Framework's data access strategy of choice – ADO.NET – including its
architecture, its classes, and how it fits into the structure of data-driven applications. We'll finish by
covering the installation of a database server that we'll use throughout this book.
A data-driven web application is a web site that displays dynamic data. The user
experience changes to reflect the information held in a data store.
Page view 0
1 2 3 4 5 6 ... 22 23

Summary of Contents

Page 1 - Displaying Data on the Web

Displaying Data on the WebWhen the Web first appeared, people had to find a metaphor for how information should be presentedon it. If you took a sampl

Page 2 - Advantages

Chapter 118DAOLet's start to put some meat on these bones. DAO (Data Access Objects) was Microsoft's first attempt atproviding programmers w

Page 3 - Data Sources

Displaying Data on the Web19ADO.NET ArchitectureYou now know that ADO.NET draws on a long history of data access. Almost inevitably, this meansthat th

Page 4 - Text Files

Chapter 120❑ The data adapter object represents a set of commands and a database connection, providing analternative method of retrieving data. It pro

Page 5

Displaying Data on the Web21InformixMySQLOLE DB-Compatible stores?Other data storesADO.NETOLEDB ProviderApplicationApplicationData Access LayerDatabas

Page 6 - Other Sources

Chapter 122Data-driven Application ArchitectureAlthough it's an important part of the puzzle, simply getting hold of a database and knowing theco

Page 7

Displaying Data on the Web23•While it could be argued that all applications make use of n-tier architectures, it hasbecome commonplace to use the term

Page 8 - Introduction to ADO.NET

Chapter 124Data TierThe data tier consists mainly of the table definitions, relationships, and data items that constitute thedatabase itself, along wi

Page 9

Displaying Data on the Web25Presenting Data with ControlsSince we just talked about presentation, it makes sense to take a moment here to discuss an i

Page 10 - Chapter 1

Chapter 126Custom ControlsWhile the controls that come built into .NET provide us with a great deal of functionality, and cater formost situations, th

Page 11 - ADO.NET Architecture

Displaying Data on the Web27Throughout this book, the code samples and text will assume that MSDE is being used as the dataprovider, with the Northwin

Page 12 - Data Providers

Chapter 110Pros and Cons of Data-Driven Web SitesSome of the advantages of having a data-driven system are immediately apparent, but there are otherst

Page 13 - Standard Providers

Chapter 128This page is self-explanatory: clicking on the first link will install the MSDE engine; clicking on thesecond will cause the sample databas

Page 14

Displaying Data on the Web29The service called MSSQL$NetSDK is MSDE. Make sure that the Status and Startup Type are set toStarted and Automatic, as th

Page 15

Chapter 130Having made it this far, you can be sure that the MSDE database is ready for action, and with that ourwork in this chapter is done. It&apos

Page 16 - Presentation Tier

Displaying Data on the Web31

Page 17 - Presenting Data with Controls

Displaying Data on the Web11•DisadvantagesAlthough there are many advantages to making a web site data-driven, some of them come at a price,and a data

Page 18 - A Smaller SQL Server

Chapter 112DatabasesWhen you start thinking about data sources, the most obvious one that springs to mind is the database,which will generally provide

Page 19 - Obtaining and Installing MSDE

Displaying Data on the Web13For simple information such as this, a text file provides an easy way of reading and writing data. If thedata to be stored

Page 20 - Using MSDE

Chapter 114XML is a powerful way of representing information, but in some circumstances performance can be aproblem: updating and retrieving data from

Page 21

Displaying Data on the Web15The diagram below lays out the three steps mentioned above, and places them in context with the codethat you'll need

Page 22

Chapter 116•❑ Reading/converting the data. Through the connection, we can tell the database to add, delete,and update records, to return information t

Page 23

Displaying Data on the Web17In the recent past, most applications communicated with data stores through the software objectsprovided by ADO, which mad

Comments to this Manuals

No comments