<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<head>
<title>SQL Demos: Using the WHERE Clause (Example 2)</title>
<link rel="stylesheet" href="/shared/netdemos.css">
<script language="C#" runat="server" src="~/shared/fetchData_oledb.cs" />
<script language="C#" runat="server">
protected void Page_Load ( object src, EventArgs e ) {
string query = "SELECT * FROM Plans WHERE Area >= 6000";
lstPlans.DataSource = fetchReader ( query, "plans" );
lstPlans.DataBind ( );
}
</script>
</head>
<body>
<div class="header"><h2>SQL Demos: Using the <b>WHERE Clause</b> (Example 2)</h2></div>
<!-- #include virtual="~/shared/viewsrc_top.inc" -->
<hr size=1 width=92%>
<center>
<form runat="server">
<asp:datalist id="lstPlans" runat="server"
width="90%" cellpadding=5 backcolor="ghostwhite" showfooter=false
repeatcolumns=4 repeatdirection="horizontal">
<itemstyle width=25% verticalalign="top" />
<itemtemplate>
<table width=100% cellpadding=10 style="background:ddd; border:2px outset">
<tr valign="top">
<td align="center" width=290>
<a href='<%# Eval ( "PlanID", "details_plans.aspx?id={0}" ) %>'><img width=200 runat="server"
src='<%# Eval ( "PlanID", "~/shared/images/plans/{0}.jpg" ) %>'
alt='<%# Eval ( "Model" ) %>'
style="border:1px inset; border-radius:10px; box-shadow: 2px 2px 4px gray"></a>
<p><!-- --></p>
<table width=90% class="data" cellspacing=0
style="font-size:8pt; text-align:center; border:1px solid">
<tr><th><%# Eval ( "Design" ) %></th></tr>
<tr><td><%# Eval ( "Area" ) %> ft<sup>2</sup>,
<%# Eval ( "Bedrooms" ) %> Bedrooms,
<%# Eval ( "Baths" ) %> Baths
<p>National Average Cost to Build: <br>
<b style="color:maroon"><%# Eval ( "Cost", "{0:c}" ) %></b>
</td></tr>
</table>
</td>
</table>
</itemtemplate>
</asp:datalist>
</form>
</center>
<hr size=1 width=92%>
<!-- #include virtual="~/shared/viewsrc.inc" -->
</body>
</html>