aspnet03-01.htm

tutorialssss.... for everybody!!!!!!!!!!!!!!!!!!!

staff to update the pages. In effect, those who maintain the data stores 
maintain the Web site.</p>
<p>The benefits of data-driven Web sites not only pertain to corporate or 
commercial sites. Even a personal Web site is advantaged by separating page 
formatting from its information content. Of course, if page content seldom 
changes then it may be satisfactory to hard code the information on the page 
itself. However, if content changes routinely, a better solution is to off-load 
it into external files or databases. The information content is more easily 
edited and updated in these external data stores than by continually editing 
XHTML pages. Regardless of the size or complexity of a Web site, a developer's 
first inclination should be to manage its content externally using server 
controls and scripts to bring it together for page presentation.</p>
<p class="head2">Example Database</p>
<p>Much of the discussion in these tutorials surrounds database processing. For 
illustration purposes, it is necessary to have a database to work with. On this 
and subsequent pages a Microsoft Access database named <span class="code"><b>BooksDB.mdb</b></span> is used. This database contains a <span class="code"><b>Books</b></span> table with information about books for sale. This 
information is typical of that needed for e-commerce Web sites. The structure of 
this database table is shown below.</p>
<table class="standard" cellpadding="3">
  <tbody>
  <tr>
    <th nowrap="nowrap">Field Name</th>
    <th nowrap="nowrap">Data Type</th>
    <th nowrap="nowrap">Field Size</th>
    <th>Example Data</th></tr>
  <tr>
    <td nowrap="nowrap">BookID (Key)</td>
    <td>Text</td>
    <td align="center">5</td>
    <td>DB222</td></tr>
  <tr>
    <td>BookType</td>
    <td>Text</td>
    <td align="center">10</td>
    <td>Database</td></tr>
  <tr>
    <td>BookTitle</td>
    <td>Text</td>
    <td align="center">50</td>
    <td>Databases in Depth</td></tr>
  <tr>
    <td>BookAuthor</td>
    <td>Text</td>
    <td align="center">20</td>
    <td>C. J. Date</td></tr>
  <tr>
    <td nowrap="nowrap">BookDescription</td>
    <td>Memo</td>
    <td>&nbsp;</td>
    <td>In Database in Depth, author and well-known database authority Chris 
      Date lays out the fundamentals of the relational model. Don't let a lack 
      to formal education in database theory hold you back. Instead, let Chris's 
      clear explanation of relational concepts, set theory, the difference 
      between model and implementation, relational algebra, normalization, and 
      much more set you apart and well above the competition when it comes to 
      getting work done with a relational database.</td></tr>
  <tr>
    <td>BookPrice</td>
    <td>Currency</td>
    <td align="center">&nbsp;</td>
    <td>$29.95</td></tr>
  <tr>
    <td>BookQty</td>
    <td>Number</td>
    <td align="center" nowrap="nowrap">Long Integer</td>
    <td>6</td></tr>
  <tr>
    <td>BookSale</td>
    <td>Yes/No</td>
    <td align="center">&nbsp;</td>
    <td>True (checked) or False</td></tr></tbody></table>
<div class="figure"><b>Figure 3-5. </b>Structure of <span class="code">Books</span> 
table of <span class="code">BooksDB.mdb</span> database.</div>
<p>The complete database contents are shown below, produced, incidentally, live 
and direct from the database itself.</p>
<div class="block">
<div>
<table id="BookGrid" style="border: 1px solid ; width: 550px; border-collapse: collapse;" itemstyle-verticalalign="Top" border="1" cellpadding="2" cellspacing="0" rules="all">
  <tbody>
  <tr style="font-size: 9pt; background-color: rgb(240, 240, 240);">
    <th scope="col">ID</th>
    <th scope="col">Type</th>
    <th scope="col">Title</th>
    <th scope="col">Author</th>
    <th scope="col">Description</th>
    <th scope="col">Price</th>
    <th scope="col">Qty</th>
    <th scope="col">&nbsp;Sale&nbsp;</th></tr>
  <tr>
    <td>DB111</td>
    <td>Database</td>
    <td style="width: 135px;">Oracle Database</td>
    <td>K. Loney</td>
    <td>
      <div style="overflow-y: scroll; width: 150px; height: 33px;"><span style="line-height: 8pt;">Get thorough coverage of Oracle Database 10g from 
      the most comprehensive reference available, published by Oracle Press. 
      With in-depth details on all the new features, this powerhouse resource 
      provides an overview of database architecture and Oracle Grid Computing 
      technology, and covers SQL, SQL*Plus, PL/SQL, dynamic PL/SQL, 
      object-oriented features, and Java programming in the Oracle environment. 
      You'll also find valuable database administration and application 
      development techniques, plus an alphabetical reference covering major 
      Oracle commands, keywords, features, and functions, with cross-referencing 
      of topics.</span> </div></td>
    <td align="right">69.99</td>
    <td align="right">10</td>
    <td>False</td></tr>
  <tr>
    <td>DB222</td>
    <td>Database</td>
    <td style="width: 135px;">Databases in Depth</td>
    <td>C. J. Date</td>
    <td>
      <div style="overflow-y: scroll; width: 150px; height: 33px;"><span style="line-he