<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<title>Binding a DataReader to a DataGrid Control</title>
<link rel="stylesheet" href="/shared/netdemos.css">
<script language="C#" runat="server" src="~/shared/fetchData_sql.cs" />
<script language="C#" runat="server">
protected void Page_Load ( object src, EventArgs e ) {
if ( !IsPostBack ) {
// define the query
string query = "SELECT * FROM Titles";
// fetch results of the query into a datareader
myGrid.DataSource = fetchReader ( query );
// bind the datagrid to the reader
myGrid.DataBind ( );
}
}
</script>
<body>
<div class="header"><h2>Binding a <b>DataReader</b> to a <b>DataGrid</b> Control</h2></div>
<!-- #include virtual="~/shared/viewsrc_top.inc" -->
<hr size=1 width=92%>
<div align="center">
<form runat="server">
<asp:datagrid id="myGrid" runat="server"
width="90%" cellpadding=5 font-size="10pt"
gridlines="horizontal"
itemstyle-verticalalign="top"
autogeneratecolumns=false>
<headerstyle backcolor="slategray"
forecolor="ivory"
height=25pt font-bold />
<columns>
<asp:templatecolumn>
<itemtemplate>
<a href='details_title.aspx?titleid=<%# Eval ( "title_id" ) %>'>
<img width=60 align="top" alt="Click for details" border=0
src='<%# Eval ( "title_id", "/shared/images/title-{0}.gif" ) %>'
style="box-shadow: 3px 3px 3px gray">
</a>
</itemtemplate>
</asp:templatecolumn>
<asp:boundcolumn headertext="Title"
datafield="title" />
<asp:boundcolumn headertext="Notes"
datafield="notes" />
<asp:boundcolumn headertext="Publication"
datafield="pubdate"
dataformatstring="{0:d}" />
<asp:boundcolumn headertext="Price"
datafield="price"
dataformatstring="{0:c}"
itemstyle-horizontalalign="right" />
</columns>
</asp:datagrid>
</form>
</div>
<hr size=1 width=92%>
<!-- #include virtual="~/shared/viewsrc.inc" -->
</body>
</html>