<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<head>
<title>SQL Demos: Using the WHERE Clause (Example 3)</title>
<link rel="stylesheet" href="/shared/netdemos.css">
<script language="C#" runat="server" src="~/shared/fetchData_sql.cs" />
<script language="C#" runat="server">
void Page_Load ( object src, EventArgs e ) {
if ( !IsPostBack ) {
string query = "SELECT * FROM [Orders Qry] WHERE OrderDate <= '12/31/24' ORDER BY OrderDate DESC";
gvOrders.DataSource = fetchData ( query );
gvOrders.DataBind ( );
}
}
void PageChanged ( object sender, GridViewPageEventArgs e ) {
gvOrders.PageIndex = e.NewPageIndex;
string query = "SELECT * FROM [Orders Qry] WHERE OrderDate <= '12/31/24' ORDER BY OrderDate DESC";
gvOrders.DataSource = fetchData ( query );
gvOrders.DataBind ( );
}
</script>
</head>
<body>
<div class="header"><h2>SQL Demos: Using the <b>WHERE Clause</b> (Example 3)</h2></div>
<!-- #include virtual="~/shared/viewsrc_top.inc" -->
<hr size=1 width=92%>
<center>
<form runat="server">
<asp:gridview id="gvOrders" runat="server"
width=80% cellpadding=5 gridlines="vertical"
font-size="10pt"
alternatingitemstyle-backcolor="whitesmoke"
autogeneratecolumns=false
allowpaging=true pagesize=18
onpageindexchanging="PageChanged">
<headerstyle backcolor="lightsteelblue"
font-bold height=30
horizontalalign="center" />
<pagersettings mode="nextprevious"
nextpagetext="Next"
previouspagetext="Back"
position="top" />
<pagerstyle backcolor="steelblue"
forecolor="beige"
horizontalalign="right" />
<columns>
<asp:boundfield headertext="OrderID"
datafield="OrderId" />
<asp:boundfield headertext="OrderDate"
datafield="OrderDate"
dataformatstring="{0:d}" />
<asp:boundfield headertext="CompanyName"
datafield="CompanyName" />
<asp:boundfield headertext="Address"
datafield="Address" />
<asp:boundfield headertext="City"
datafield="ShipCity" />
<asp:boundfield headertext="Country"
datafield="Country" />
</columns>
</asp:gridview>
</form>
</center>
<hr size=1 width=92%>
<!-- #include virtual="~/shared/viewsrc.inc" -->
</body>
</html>