<%@ Page Language="C#" AutoEventWireup="true" CodeFile="RetrieveReaderColumns.aspx.cs" Inherits="RetrieveReaderColumns" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
   <title>Retrieve DbDataReader Columns</title>
   <link href="chapterStyles.css" type="text/css" rel="stylesheet" />
</head>
<body>
   <form id="form1" runat="server">
      <div id="container">
         <h1>Retrieve DbDataReader Columns</h1>
         <p>
         This example illustrates how to retrieve individual columns 
         from a <code>DbDataReader</code>.
         </p>
         <p>Select artist from list.</p>
			<p>
				<asp:ListBox id="lboxArtists" runat="server" 
				   DataTextField="Name" DataValueField="ArtistID" 
				   AutoPostBack="true" OnSelectedIndexChanged="drpArtists_SelectedIndexChanged" />
			</p>
			<asp:Panel id="panArtist" runat="server">
				<h2>Artist Information</h2>
				<p>Artist Id:
					<asp:TextBox id="txtId" runat="server" Width="48px" /></p>
				<p>First Name:
					<asp:TextBox id="txtFirst" runat="server" /></p>
				<p>Last Name:
					<asp:TextBox id="txtLast" runat="server" /></p>
				<p>Nationality:
					<asp:TextBox id="txtNationality" runat="server" /></p>
				<p>Year of Birth:
					<asp:TextBox id="txtBirth" runat="server" Width="56px" /></p>
				<p>Year of Death:
					<asp:TextBox id="txtDeath" runat="server" Width="64px" /></p>
			</asp:Panel>
			<p>
         <asp:Label ID="labMsg" runat="server" />
         </p>
      </div>
   </form>
</body>
</html>
