|
|
<html>
<head>
<title>ASP.NET Reports Starter Kit Documentation</title><LINK href="style.css" type="text/css" rel="stylesheet"></head>
<body class="NormalIndent">
<h1>Simple Report
</h1>
<p><b>Description:</b> The simple report displays a list of all
customer contacts information for the company. This is useful for sales people
who constantly are on the road since it is accessible from anywhere
through the web.
</p>
<p><strong>Overview:</strong> The simple report
demonstrates using the Datagrid control for listing a result set
from the database.
</p>
<p><IMG src="./images/1x1.gif" width="25"> <IMG src="./images/simpleoverview.png">
<br>
</p>
<p><strong>Implementation Notes: </strong>
</p>
<p>The Datagrid can also be used to support deleting and editing.
However, the purpose of this report is to show how simple and quick it is to
display data from a database in an ASP.NET Web Form with paging and sorting
features.</p>
<P>To allow paging, set the DataGrid AllowPaging property to true and create an
event handler, PageIndexChanged, to change the CurrentPageIndex property.</P>
<pre>
private void CustomerGrid_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
CustomerGrid.CurrentPageIndex = e.NewPageIndex;
BindGrid();
}
</pre>
<P>Implementing sorting is also as simple as paging: set the AllowSorting to
true, implement OnSort event handler, and set the SortExpression for each bound
column.</P>
<pre>
private void CustomerGrid_Sort(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
{
// change sort field
SortField = (string)e.SortExpression;
// re-bind to display new sorting
BindGrid();
}
</pre>
<P>The Datagrid can also be custom formatted to the desired look and feel. In
this report page, customer contact information is displayed using alternating
row color. To enable this feature, simply assign a style
to AlternatingItemStyle-CssClass attribute.</P>
<pre>
<asp:datagrid id="CustomerGrid" AlternatingItemStyle-CssClass="Content" runat="server" AllowSorting="True" AllowPaging="True" PageSize="20">
<AlternatingItemStyle CssClass="Content"></AlternatingItemStyle>
<Columns>
<asp:BoundColumn DataField="CompanyName" SortExpression="CompanyName" HeaderText="Company">
<HeaderStyle CssClass="CategoryHeader"></HeaderStyle>
<ItemStyle CssClass="ItemStyle"></ItemStyle>
</asp:BoundColumn>
</pre>
</body>
</html>
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.
A list of licenses authors might use can be found here
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Submit an article or tip