asp.net.ph Source Code Viewer

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

<html>
<title>Binding a DataReader to a GridView Using DataSourceID</title>
<link rel="stylesheet" href="/shared/netdemos.css">

<body>
<!-- #include virtual="~/shared/top.inc -->
<div class="header"><h2>Binding a <b>DataReader</b> to a <b>GridView</b> Using <b>DataSourceID</b></h2></div>

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

<div align="center">
<form runat="server">

<asp:sqldatasource id="books" runat="server"
   selectcommand = "SELECT * FROM Books WHERE Subject = 'C#' AND Price IS NOT NULL"
   connectionstring = "<%$ ConnectionStrings:aspnet %>"
   datasourcemode = "DataReader" />

<asp:gridview id="myGrid" runat="server"
   datasourceid="books"
   autogeneratecolumns=false
   width="90%" cellpadding=5 cellspacing=0
   backcolor="ghostwhite"
   font-size="10pt"
   enableviewstate=false>

   <headerstyle height=30 font-bold
      backcolor="steelblue"
      forecolor="beige" />

   <columns>
      <asp:imagefield headertext=""
         dataimageurlfield="titleid"
         dataimageurlformatstring="/shared/books/sm/{0}.jpg" />
      <asp:hyperlinkfield headertext="Title"
         datatextfield="title" target="amzn"
         datanavigateurlfields="url" />
      <asp:boundfield headertext="Author"
         datafield="Author" />
      <asp:boundfield headertext="Publisher"
         datafield="Publisher" />
      <asp:boundfield headertext="Price (from)"
         datafield="Price"
         dataformatstring="{0:c}" 
         itemstyle-horizontalalign="right" />
   </columns>
</asp:gridview>
</form>
</div>

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

</body>
</html>