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

<!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>Filling a DataSet</title>
   <link href="chapterStyles.css" type="text/css" rel="stylesheet" />
</head>
<body>
   <form id="form1" runat="server">
      <div id="container">
         <h1>Filling a DataSet</h1>
         <p>
         This example illustrates how to fill a DataSet
         using a <code>DbDataAdapter</code>.
         </p>
         <p>Select art work from list.</p>
			<p>
				<asp:ListBox id="lboxWork" runat="server" 
				   DataTextField="Title" DataValueField="ArtWorkID" 
				   AutoPostBack="true" OnSelectedIndexChanged="lboxWork_SelectedIndexChanged" />
			</p>
         <asp:Panel id="panWork" runat="server" CssClass="works">
				<h2>Art Work Information</h2>
				   				<p>Id:
					<asp:TextBox id="txtId" runat="server" Width="48px" /></p>
				<p>Title:
					<asp:TextBox id="txtTitle" runat="server" /></p>
            <p>Artist:
					<asp:DropDownList id="drpArtist" runat="server" 
					   DataTextField="Name" DataValueField="ArtistID" /></p>					
				<p>Year of Work:
					<asp:TextBox id="txtYear" runat="server" /></p>				
				<p>Price:
					<asp:TextBox id="txtPrice" runat="server" /></p>
									   <p>Image File Name:
					   <asp:TextBox id="txtFileName" runat="server"  /></p>
			</asp:Panel>		
			<p>
         <asp:Label ID="labMsg" runat="server" />
         </p>
      </div>
   </form>
</body>
</html>
