The Database Examples Are

The Database Examples Are

The database examples are:

default.aspx

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "

<html xmlns=" >

<head runat="server">

<title>Donors</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<h2>

Donor Table</h2>

<p>

<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"

DataKeyNames="DIdno" DataSourceID="DonorDataSource" Height="304px" Width="640px">

<Columns>

<asp:BoundField DataField="DIdno" HeaderText="DIdno" ReadOnly="True" SortExpression="DIdno" />

<asp:BoundField DataField="DName" HeaderText="DName" SortExpression="DName" />

<asp:BoundField DataField="DCity" HeaderText="DCity" SortExpression="DCity" />

<asp:BoundField DataField="DState" HeaderText="DState" SortExpression="DState" />

<asp:BoundField DataField="DYrFirst" HeaderText="DYrFirst" SortExpression="DYrFirst" />

<asp:BoundField DataField="DContact" HeaderText="DContact" SortExpression="DContact" />

</Columns>

</asp:GridView>

<asp:AccessDataSource ID="DonorDataSource" runat="server" DataFile="c:\sites\content\c\i\s\cis47\db\donor.mdb"

SelectCommand="SELECT [DIdno], [DName], [DCity], [DState], [DYrFirst], [DContact] FROM [Donor2000] ORDER BY [DIdno]">

</asp:AccessDataSource>

</p>

<p>

&nbsp;</p>

</div>

</form>

</body>

</html>

default.aspx.vb

Partial Class _Default

Inherits System.Web.UI.Page

End Class

default.aspx

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "

<html xmlns=" >

<head runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<h2>

Donor, Donation and Drive Information</h2>

<p>

&nbsp;</p>

<p>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="Donor3DataSource"

Width="680px">

<Columns>

<asp:BoundField DataField="DIdno" HeaderText="DIdno" SortExpression="DIdno" />

<asp:BoundField DataField="DName" HeaderText="DName" SortExpression="DName" />

<asp:BoundField DataField="DDriveNo" HeaderText="DDriveNo" SortExpression="DDriveNo" />

<asp:BoundField DataField="DDriveName" HeaderText="DDriveName" SortExpression="DDriveName" />

<asp:BoundField DataField="DAmtCont" DataFormatString="{0:c}" HeaderText="DAmtCont"

SortExpression="DAmtCont" />

</Columns>

</asp:GridView>

<asp:AccessDataSource ID="Donor3DataSource" runat="server" DataFile="c:\sites\content\c\i\s\cis47\db\donor.mdb"

SelectCommand="SELECT [DIdno], [DName], [DDriveNo], [DDriveName], [DAmtCont] FROM [Gr500Three] ORDER BY [DIdno]">

</asp:AccessDataSource>

</p>

</div>

</form>

</body>

</html>

default.aspx.vb

Partial Class _Default

Inherits System.Web.UI.Page

End Class

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "

<html xmlns=" >

<head runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<h2>

Donor Information<asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True"

AutoGenerateRows="False" DataKeyNames="DIdno" DataSourceID="DonorDataSource"

Height="50px" Width="536px">

<Fields>

<asp:BoundField DataField="DIdno" HeaderText="Idno" ReadOnly="True" SortExpression="DIdno" />

<asp:BoundField DataField="DName" HeaderText="Name" SortExpression="DName" />

<asp:BoundField DataField="DStAdr" HeaderText="StAdr" SortExpression="DStAdr" />

<asp:BoundField DataField="DCity" HeaderText="City" SortExpression="DCity" />

<asp:BoundField DataField="DState" HeaderText="State" SortExpression="DState" />

<asp:BoundField DataField="DZip" HeaderText="Zip" SortExpression="DZip" />

<asp:BoundField DataField="DYrFirst" HeaderText="YrFirst" SortExpression="DYrFirst" />

<asp:BoundField DataField="DContact" HeaderText="Contact" SortExpression="DContact" />

</Fields>

</asp:DetailsView>

<asp:AccessDataSource ID="DonorDataSource" runat="server" DataFile="c:\sites\content\c\i\s\cis47\db\donor.mdb"

SelectCommand="SELECT [DIdno], [DName], [DStAdr], [DCity], [DState], [DZip], [DYrFirst], [DContact] FROM [Donor2000] ORDER BY [DIdno]">

</asp:AccessDataSource>

</h2>

</div>

</form>

</body>

</html>

default.aspx.vb

Partial Class _Default

Inherits System.Web.UI.Page

End Class

default.aspx

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "

<html xmlns=" >

<head runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<h2>

Donations<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

DataKeyNames="DIdno,DDriveNo,DDateCont" DataSourceID="DonationDataSource">

<Columns>

<asp:BoundField DataField="DIdno" HeaderText="Idno" ReadOnly="True" SortExpression="DIdno" />

<asp:BoundField DataField="DDriveNo" HeaderText="Drive No" ReadOnly="True" SortExpression="DDriveNo" />

<asp:BoundField DataField="DDateCont" DataFormatString="{0:d}" HeaderText="Date Cont"

ReadOnly="True" SortExpression="DDateCont" />

<asp:BoundField DataField="DAmtCont" DataFormatString="{0:c}" HeaderText="Amount"

SortExpression="DAmtCont" />

</Columns>

</asp:GridView>

<asp:AccessDataSource ID="DonationDataSource" runat="server" DataFile="c:\sites\content\c\i\s\cis47\db\donor.mdb"

SelectCommand="SELECT [DIdno], [DDriveNo], [DDateCont], [DAmtCont] FROM [Donation2000] ORDER BY [DIdno]">

</asp:AccessDataSource>

</h2>

</div>

</form>

</body>

</html>

default.aspx.vb

Partial Class _Default

Inherits System.Web.UI.Page

End Class

default.aspx

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "

<html xmlns=" >

<head runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<h2>

Update Donor List</h2>

<p>

<asp:DetailsView ID="dvwDonor" runat="server" AllowPaging="True" AutoGenerateRows="False"

DataKeyNames="DIdno" DataSourceID="DonorUpdateDataSource" Height="50px" Width="320px">

<Fields>

<asp:BoundField DataField="DIdno" HeaderText="DIdno" ReadOnly="True" SortExpression="DIdno" />

<asp:BoundField DataField="DName" HeaderText="DName" SortExpression="DName" />

<asp:BoundField DataField="DStAdr" HeaderText="DStAdr" SortExpression="DStAdr" />

<asp:BoundField DataField="DCity" HeaderText="DCity" SortExpression="DCity" />

<asp:BoundField DataField="DState" HeaderText="DState" SortExpression="DState" />

<asp:BoundField DataField="DZip" HeaderText="DZip" SortExpression="DZip" />

<asp:BoundField DataField="DYrFirst" HeaderText="DYrFirst" SortExpression="DYrFirst" />

<asp:BoundField DataField="DContact" HeaderText="DContact" SortExpression="DContact" />

<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />

</Fields>

</asp:DetailsView>

<asp:AccessDataSource ID="DonorUpdateDataSource" runat="server" DataFile="c:\sites\content\c\i\s\cis47\db\donor.mdb"

DeleteCommand="DELETE FROM [Donor2000] WHERE [DIdno] = ?" InsertCommand="INSERT INTO [Donor2000] ([DIdno], [DName], [DStAdr], [DCity], [DState], [DZip], [DYrFirst], [DContact]) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"

SelectCommand="SELECT [DIdno], [DName], [DStAdr], [DCity], [DState], [DZip], [DYrFirst], [DContact] FROM [Donor2000] ORDER BY [DIdno]"

UpdateCommand="UPDATE [Donor2000] SET [DName] = ?, [DStAdr] = ?, [DCity] = ?, [DState] = ?, [DZip] = ?, [DYrFirst] = ?, [DContact] = ? WHERE [DIdno] = ?">

<DeleteParameters>

<asp:Parameter Name="DIdno" Type="String" />

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name="DName" Type="String" />

<asp:Parameter Name="DStAdr" Type="String" />

<asp:Parameter Name="DCity" Type="String" />

<asp:Parameter Name="DState" Type="String" />

<asp:Parameter Name="DZip" Type="String" />

<asp:Parameter Name="DYrFirst" Type="String" />

<asp:Parameter Name="DContact" Type="String" />

<asp:Parameter Name="DIdno" Type="String" />

</UpdateParameters>

<InsertParameters>

<asp:Parameter Name="DIdno" Type="String" />

<asp:Parameter Name="DName" Type="String" />

<asp:Parameter Name="DStAdr" Type="String" />

<asp:Parameter Name="DCity" Type="String" />

<asp:Parameter Name="DState" Type="String" />

<asp:Parameter Name="DZip" Type="String" />

<asp:Parameter Name="DYrFirst" Type="String" />

<asp:Parameter Name="DContact" Type="String" />

</InsertParameters>

</asp:AccessDataSource>

</p>

</div>

</form>

</body>

</html>

default.aspx.vb

Partial Class _Default

Inherits System.Web.UI.Page

End Class

Top View