asp.net.ph Source Code Viewer

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<html>
<head>
<title>SQL Demos: SELECT with <b>Calculated Expression</b></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 sender, EventArgs e ) {
   if ( ! IsPostBack ) {
      string query = "SELECT OrderID, ProductID, Quantity, UnitPrice, Quantity * UnitPrice AS TotalAmount FROM [Order Details]";
      myGrid.DataSource = fetchData ( query );
      myGrid.DataBind ( );
   }
}

void PageChanged ( object sender, DataGridPageChangedEventArgs e ) {
   myGrid.CurrentPageIndex = e.NewPageIndex;
   string query = "SELECT OrderID, ProductID, Quantity, UnitPrice, Quantity * UnitPrice AS TotalAmount FROM [Order Details]";
   myGrid.DataSource = fetchData ( query );
   myGrid.DataBind ( );
}
</script>
</head>

<body>
<div class="header"><h2>SQL Demos: <b>SELECT with Calculated Expression</b></h2></div>
<!-- #include virtual="~/shared/viewsrc_top.inc" -->
<hr size=1 width=92%>

<center>
<form runat="server">
   <asp:datagrid id="myGrid" runat="server"
      width="70%" cellpadding=5 font-size="10pt"
      gridlines="horizontal"
      itemstyle-verticalalign="top"
      autogeneratecolumns=false
      allowpaging=true pagesize=18
      onpageindexchanged="PageChanged">

      <headerstyle font-bold backcolor="slategray" forecolor="ivory" />
      <pagerstyle position="top"
         mode="NextPrev"
         nextpagetext="Next"
         prevpagetext="Prev"
         backcolor="steelblue" forecolor="beige"
         horizontalalign="right" />

      <columns>
         <asp:boundcolumn headertext="OrderID"
            datafield="OrderID" />
         <asp:boundcolumn headertext="ProductID"
            datafield="ProductID" />
         <asp:boundcolumn headertext="Quantity"
            datafield="Quantity" />
         <asp:boundcolumn headertext="UnitPrice"
            datafield="UnitPrice"
            dataformatstring="{0:n2}"
            itemstyle-horizontalalign="right" />
         <asp:boundcolumn headertext="TotalAmount"
            datafield="TotalAmount"
            dataformatstring="{0:n2}"
            itemstyle-horizontalalign="right" />
      </columns>
   </asp:datagrid>

</form>
</center>

<hr size=1 width=92%>
<!-- #include virtual="~/shared/viewsrc.inc" -->

</body>
</html>