- reporting_kit_conversion_demo.zip
- reports
- bin
- ASPNETReports.dll
- ASPNETReports.dll.bak
- MySql.Data.dll
- MySql.Data.Tests.dll
- MySql.Data.xml
- ChartGenerator.aspx
- components
- crosstab.aspx
- default.aspx
- docs
- drilldown.aspx
- Global.asax
- hierarchical.aspx
- images
- 1x1.gif
- asp.net-reports.gif
- background.gif
- crosstab.gif
- crosstabnestedcontrols.png
- crosstabtotals.png
- customers.gif
- drilldown.gif
- drilldownnestedcontrols.png
- employees.gif
- getorderdetails.gif
- GetOrders.gif
- grid_background.gif
- hierarchal.gif
- hierarchical.gif
- hierarchicalpaging.gif
- hierarchicalreport.gif
- hierarchicalschema.gif
- hierarchicalsorting.gif
- logo.gif
- logo-neg.gif
- masterdetail.gif
- masterdetaildetails.png
- masterdetails.gif
- masterdetailsummary.png
- masterdetailtables.png
- matrix.gif
- querysample.gif
- querysample2.gif
- reporting.gif
- report-table-bg.gif
- simple.gif
- simpleoverview.png
- simplesp.png
- spacer.gif
- tabcolorcode.png
- tabdetail.png
- tabheader.gif
- tabheader.png
- tabnestedcontrols.png
- tabsortshot.png
- tabular.gif
- tabularcolorcode.png
- tabularextendedprice.png
- tabularsorting.png
- text.gif
- textalternate.gif
- textreport.gif
- textshot.gif
- viscategorysales.gif
- viscategorysales.png
- vischartstructure.png
- visual.gif
- xtabsql.png
- masterdetail.aspx
- scripts.js
- simplereport.aspx
- sourceviewer
- 1x1.gif
- crosstab.src
- drilldown.src
- grid_background.gif
- hierarchical.src
- masterdetail.src
- simple.src
- srcview.aspx
- style.css
- tabular.src
- tabview.aspx
- textreport.src
- visual.src
- sql
- styles.css
- stylesPrint.css
- tabular.aspx
- textreport.aspx
- visual.aspx
- web.config
|
<html><head><link rel=stylesheet href=style.css></head><body><div class=SourcePanel style='font-size:12'><pre style='background-color:white'>
<%@ Page language="c#" %<font color= "blue">></font>
<%@ Import Namespace="System" %<font color= "blue">></font>
<%@ Import Namespace="System.Web.UI.WebControls" %<font color= "blue">></font>
<%@ Import Namespace="ASPNET.StarterKit.Reports.Components" %<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">script</font> runat="server"<font color= "blue">></font>
<font color= "blue"> </font>
<font color= "green"> //*********************************************************************</font>
<font color= "green"> //</font>
<font color= "green"> // Hierarchical.aspx</font>
<font color= "green"> //</font>
<font color= "green"> // The Hierarchical.aspx page shows a basic way to filter related data </font>
<font color= "green"> // in a grid based on information selected from another grid, which</font>
<font color= "green"> // in turn was filtered and grouped based on information selected from </font>
<font color= "green"> // yet another grid. This is a very common representation of a hierarchical</font>
<font color= "green"> // data structure.</font>
<font color= "green"> //</font>
<font color= "green"> // This is accomplished by displaying three different datagrids, each bound </font>
<font color= "green"> // by separate stored procedures. The second and third stored procedures</font>
<font color= "green"> // take in input parameters to filter the data, which are determined by </font>
<font color= "green"> // which data item is selected in the prior, or parent, datagrid.</font>
<font color= "green"> //</font>
<font color= "green"> //*********************************************************************</font>
<font color= "blue"> </font>
<font color= "blue"> protected </font>string _styleSheet;
<font color= "blue"> protected </font>Int32 _currentPageNumber_Terr = 1;
<font color= "blue"> protected </font>Int32 _currentPageNumber_EmpTerr = 1;
<font color= "blue"></font>
<font color= "green"> //****************</font>
<font color= "green"> // PROPERTIES</font>
<font color= "green"> //****************</font>
<font color= "blue"> </font>string SortField_Terr
<font color= "blue"> </font>{
<font color= "green"> // SortField property is tracked in ViewState for both the</font>
<font color= "green"> // TerritoryGrid and the EmployeeTerritoryGrid </font>
<font color= "blue"> get</font>
<font color= "blue"> </font>{
<font color= "blue"> </font>object o = ViewState["SortField_Terr"];
<font color= "blue"></font><font color= "blue"> if </font>(o == null) <font color= "blue"></font>
<font color= "blue"> </font>{
<font color= "blue"> return</font> String.Empty;
<font color= "blue"> </font>}
<font color= "blue"> return</font> (string)o;
<font color= "blue"> </font>}
<font color= "blue"> set</font>
<font color= "blue"> </font>{
<font color= "blue"></font><font color= "blue"> if </font>(value == SortField_Terr) <font color= "blue"></font>
<font color= "blue"> </font>{
<font color= "green"> // same as current sort file, toggle sort direction</font>
<font color= "blue"> </font>SortAscending_Terr = !SortAscending_Terr;
<font color= "blue"> </font>}
<font color= "blue"> </font>ViewState["SortField_Terr"] = value;
<font color= "blue"> </font>}
<font color= "blue"> </font>}
<font color= "blue"> </font>string SortField_EmpTerr
<font color= "blue"> </font>{
<font color= "blue"> get</font>
<font color= "blue"> </font>{
<font color= "blue"> </font>object o = ViewState["SortField_EmpTerr"];
<font color= "blue"></font><font color= "blue"> if </font>(o == null) <font color= "blue"></font>
<font color= "blue"> </font>{
<font color= "blue"> return</font> String.Empty;
<font color= "blue"> </font>}
<font color= "blue"> return</font> (string)o;
<font color= "blue"> </font>}
<font color= "blue"> set</font>
<font color= "blue"> </font>{
<font color= "blue"></font><font color= "blue"> if </font>(value == SortField_EmpTerr) <font color= "blue"></font>
<font color= "blue"> </font>{
<font color= "green"> // same as current sort file, toggle sort direction</font>
<font color= "blue"> </font>SortAscending_EmpTerr = !SortAscending_EmpTerr;
<font color= "blue"> </font>}
<font color= "blue"> </font>ViewState["SortField_EmpTerr"] = value;
<font color= "blue"> </font>}
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "green"> // SortAscending property is tracked in ViewState for both the</font>
<font color= "green"> // TerritoryGrid and the EmployeeTerritoryGrid </font>
<font color= "blue"> </font>bool SortAscending_Terr
<font color= "blue"> </font>{
<font color= "blue"> get</font>
<font color= "blue"> </font>{
<font color= "blue"> </font>object o = ViewState["SortAscending_Terr"];
<font color= "blue"></font>
<font color= "blue"></font><font color= "blue"> if </font>(o == null) <font color= "blue"></font>
<font color= "blue"> </font>{
<font color= "blue"> return</font> true;
<font color= "blue"> </font>}
<font color= "blue"> return</font> (bool)o;
<font color= "blue"> </font>}
<font color= "blue"> set</font>
<font color= "blue"> </font>{
<font color= "blue"> </font>ViewState["SortAscending_Terr"] = value;
<font color= "blue"> </font>}
<font color= "blue"> </font>}
<font color= "blue"> </font>bool SortAscending_EmpTerr
<font color= "blue"> </font>{
<font color= "blue"> get</font>
<font color= "blue"> </font>{
<font color= "blue"> </font>object o = ViewState["SortAscending_EmpTerr"];
<font color= "blue"></font>
<font color= "blue"></font><font color= "blue"> if </font>(o == null) <font color= "blue"></font>
<font color= "blue"> </font>{
<font color= "blue"> return</font> true;
<font color= "blue"> </font>}
<font color= "blue"> return</font> (bool)o;
<font color= "blue"> </font>}
<font color= "blue"> set</font>
<font color= "blue"> </font>{
<font color= "blue"> </font>ViewState["SortAscending_EmpTerr"] = value;
<font color= "blue"> </font>}
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "green"> //****************</font>
<font color= "green"> // PAGE_LOAD</font>
<font color= "green"> //****************</font>
<font color= "blue"> private void</font> Page_Load(object sender, System.EventArgs e)
<font color= "blue"> </font>{
<font color= "blue"></font><font color= "blue"> if </font>(!IsPostBack)<font color= "blue"></font>
<font color= "blue"> </font>{
<font color= "green"> // default sort will be by Territory Name for Territory Grid, and </font>
<font color= "green"> // EmployeeName for Employee Grid</font>
<font color= "blue"></font><font color= "blue"> if </font>(SortField_Terr == "") <font color= "blue"></font>
<font color= "blue"> </font>SortField_Terr = "Territory";
<font color= "blue"></font>
<font color= "blue"></font><font color= "blue"> if </font>(SortField_EmpTerr == "") <font color= "blue"></font>
<font color= "blue"> </font>SortField_EmpTerr = "EmployeeName";
<font color= "blue"></font>
<font color= "blue"> </font>BindList_Terr();
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "green"> // switches the style sheet based on printer friendly view or not</font>
<font color= "blue"></font><font color= "blue"> if </font>(Request.QueryString["Print"]=="true")<font color= "blue"></font>
<font color= "blue"> </font>{
<font color= "blue"> </font>_styleSheet = "stylesPrint.css";
<font color= "blue"> </font>PrintButton.Visible = true;
<font color= "blue"> </font>}
<font color= "blue"></font><font color= "blue"> else </font><font color= "blue"></font>
<font color= "blue"> </font>{
<font color= "blue"> </font>_styleSheet = "styles.css";
<font color= "blue"> </font>}
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "green"> //****************</font>
<font color= "green"> // DATA BINDING</font>
<font color= "green"> //****************</font>
<font color= "blue"></font>
<font color= "green"> //*********************************************************************</font>
<font color= "green"> //</font>
<font color= "green"> // The BindList_Terr method retrieves the list of Sales per Territory</font>
<font color= "green"> // and then databinds them to the Territory Grid control (1st control)</font>
<font color= "green"> //</font>
<font color= "green"> //*********************************************************************</font>
<font color= "blue"> private void</font> BindList_Terr()
<font color= "blue"> </font>{
<font color= "blue"> </font>HierarchicalReportCollection territoryList = HierarchicalReport.GetSalesByTerritory(Convert.ToInt32(ddlYear.SelectedItem.Value));
<font color= "blue"> </font>
<font color= "green"> // do the sorting if there are data returned</font>
<font color= "blue"></font><font color= "blue"> if </font>(territoryList.Count > 0) <font color= "blue"></font>
<font color= "blue"> </font>SortGridData(territoryList, SortField_Terr, SortAscending_Terr);
<font color= "blue"></font>
<font color= "blue"> </font>TerritoryGrid.DataSource = territoryList;
<font color= "blue"> </font>TerritoryGrid.DataBind();
<font color= "blue"></font>
<font color= "green"> // Update paging labels</font>
<font color= "blue"> </font>CurrPage_Terr.Text = Convert.ToString(TerritoryGrid.CurrentPageIndex + 1);
<font color= "blue"> </font>TotPages_Terr.Text = TerritoryGrid.PageCount.ToString();
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "green"> //*********************************************************************</font>
<font color= "green"> //</font>
<font color= "green"> // The BindList_EmpTerr method retrieves the list of Sales per </font>
<font color= "green"> // Employee within a certain Territory, and then databinds them to the </font>
<font color= "green"> // EmployeeTerritory Grid control (2nd control)</font>
<font color= "green"> //</font>
<font color= "green"> //*********************************************************************</font>
<font color= "blue"> private void</font> BindList_EmpTerr(string territoryName)
<font color= "blue"> </font>{
<font color= "blue"> </font>HierarchicalReportCollection empTerritoryList = HierarchicalReport.GetEmployeeSalesByTerritory(territoryName, Convert.ToInt32(ddlYear.SelectedItem.Value));
<font color= "blue"> </font>
<font color= "green"> // do the sorting if there are data returned</font>
<font color= "blue"></font><font color= "blue"> if </font>(empTerritoryList.Count > 0) <font color= "blue"></font>
<font color= "blue"> </font>{
<font color= "blue"> </font>SortGridData(empTerritoryList, SortField_EmpTerr, SortAscending_EmpTerr);
<font color= "blue"></font>
<font color= "blue"> </font>EmployeeTerritoryGrid.DataSource = empTerritoryList;
<font color= "blue"> </font>EmployeeTerritoryGrid.DataBind();
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "green"> // Update paging labels</font>
<font color= "blue"> </font>CurrPage_EmpTerr.Text = Convert.ToString(EmployeeTerritoryGrid.CurrentPageIndex + 1);
<font color= "blue"> </font>TotPages_EmpTerr.Text = EmployeeTerritoryGrid.PageCount.ToString();
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "green"> //**************************************************************************</font>
<font color= "green"> //</font>
<font color= "green"> // The BindList_Emp method retrieves the information for a single Employee, </font>
<font color= "green"> // and then databinds them to the Employee grid control (3rd control).</font>
<font color= "green"> //</font>
<font color= "green"> // There is no paging or sorting in this control.</font>
<font color= "green"> //</font>
<font color= "green"> //**************************************************************************</font>
<font color= "blue"> private void</font> BindList_Emp(int employeeID)
<font color= "blue"> </font>{
<font color= "blue"> </font>HierarchicalReportCollection employeeInfo = HierarchicalReport.GetEmployeeInfo(employeeID);
<font color= "blue"> </font>
<font color= "blue"> </font>EmployeeGrid.DataSource = employeeInfo;
<font color= "blue"> </font>EmployeeGrid.DataBind();
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "green"> //****************</font>
<font color= "green"> // PAGING</font>
<font color= "green"> //****************</font>
<font color= "blue"></font>
<font color= "green"> //**************************************************************************</font>
<font color= "green"> //</font>
<font color= "green"> // The Page_* methods move the CurrentPageIndex to the appropriate</font>
<font color= "green"> // previous or next page for the 2 grid controls. </font>
<font color= "green"> //</font>
<font color= "green"> //**************************************************************************</font>
<font color= "blue"></font>
<font color= "blue"> protected void</font> Page_Terr(Object sender, DataGridPageChangedEventArgs e)
<font color= "blue"> </font>{
<font color= "green"> // Hide the 2nd and 3rd table if they were visible</font>
<font color= "blue"> </font>ETTableColumn.Visible = false;
<font color= "blue"> </font>EmpTableColumn.Visible = false;
<font color= "blue"></font>
<font color= "blue"> </font>TerritoryGrid.CurrentPageIndex = e.NewPageIndex;
<font color= "blue"> </font>BindList_Terr();
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "blue"> protected void</font> Page_EmpTerr(Object sender, DataGridPageChangedEventArgs e)
<font color= "blue"> </font>{
<font color= "green"> // Hide the 3rd table if it was visible</font>
<font color= "blue"> </font>EmpTableColumn.Visible = false;
<font color= "blue"></font>
<font color= "blue"> </font>EmployeeTerritoryGrid.CurrentPageIndex = e.NewPageIndex;
<font color= "blue"> </font>BindList_EmpTerr(ETHeader.Text);
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "blue"></font>
<font color= "green"> //****************</font>
<font color= "green"> // SORTING</font>
<font color= "green"> //****************</font>
<font color= "blue"></font>
<font color= "green"> //***********************************************************************</font>
<font color= "green"> //</font>
<font color= "green"> // The SortGridData methods sorts the array list bound to the datagrid </font>
<font color= "green"> // based on which sort field is being selected. This also handles reverse </font>
<font color= "green"> // sorting based on the boolean.</font>
<font color= "green"> //</font>
<font color= "green"> // This method is used for both the Territory Grid control and the </font>
<font color= "green"> // EmployeeTerritory Grid control.</font>
<font color= "green"> //</font>
<font color= "green"> //***********************************************************************</font>
<font color= "blue"> private void</font> SortGridData(HierarchicalReportCollection list, string sortField, bool asc)
<font color= "blue"> </font>{
<font color= "blue"> </font>HierarchicalReportCollection.HierarchicalReportFields sortCol = HierarchicalReportCollection.HierarchicalReportFields.InitValue;
<font color= "blue"></font>
<font color= "blue"> </font>switch(sortField)
<font color= "blue"> </font>{
<font color= "blue"> case</font> "Territory":
<font color= "blue"> </font>sortCol = HierarchicalReportCollection.HierarchicalReportFields.Territory;
<font color= "blue"> </font>break;
<font color= "blue"> case</font> "SalesTotals":
<font color= "blue"> </font>sortCol = HierarchicalReportCollection.HierarchicalReportFields.SalesTotals;
<font color= "blue"> </font>break;
<font color= "blue"> case</font> "EmployeeName":
<font color= "blue"> </font>sortCol = HierarchicalReportCollection.HierarchicalReportFields.EmployeeName;
<font color= "blue"> </font>break;
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "blue"> </font>list.Sort(sortCol, asc);
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "green"> //*********************************************************************</font>
<font color= "green"> //</font>
<font color= "green"> // The SortGrid event handlers change the sortfield for the Territory </font>
<font color= "green"> // grid and the EmployeeTerritory grid, respectively, and re-binds them.</font>
<font color= "green"> //</font>
<font color= "green"> //*********************************************************************</font>
<font color= "blue"> protected void</font> SortGrid_Terr(Object sender, DataGridSortCommandEventArgs e)
<font color= "blue"> </font>{
<font color= "green"> // Hide the 2nd and 3rd table if they were visible</font>
<font color= "blue"> </font>ETTableColumn.Visible = false;
<font color= "blue"> </font>EmpTableColumn.Visible = false;
<font color= "blue"></font>
<font color= "green"> // change sort field</font>
<font color= "blue"> </font>SortField_Terr = (string)e.SortExpression;
<font color= "blue"></font>
<font color= "green"> // move back to the first page</font>
<font color= "blue"> </font>TerritoryGrid.CurrentPageIndex = 0;
<font color= "blue"></font>
<font color= "green"> // re-bind to display new sorting</font>
<font color= "blue"> </font>BindList_Terr();
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "blue"> protected void</font> SortGrid_EmpTerr(Object sender, DataGridSortCommandEventArgs e)
<font color= "blue"> </font>{
<font color= "green"> // Hide the 3rd table if it was visible</font>
<font color= "blue"> </font>EmpTableColumn.Visible = false;
<font color= "blue"> </font>
<font color= "green"> // change sort field</font>
<font color= "blue"> </font>SortField_EmpTerr = (string)e.SortExpression;
<font color= "blue"></font>
<font color= "green"> // move back to the first page</font>
<font color= "blue"> </font>EmployeeTerritoryGrid.CurrentPageIndex = 0;
<font color= "blue"></font>
<font color= "green"> // re-bind to display new sorting</font>
<font color= "blue"> </font>BindList_EmpTerr(ETHeader.Text);
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "blue"></font>
<font color= "green"> //****************</font>
<font color= "green"> // DRILLING DOWN</font>
<font color= "green"> //****************</font>
<font color= "blue"> protected void</font> TerritoryGrid_Click(Object sender, CommandEventArgs e)
<font color= "blue"> </font>{
<font color= "blue"> </font>string territoryName = e.CommandArgument.ToString().Trim();
<font color= "blue"></font>
<font color= "green"> // Put the second grid back to the first page</font>
<font color= "blue"> </font>EmployeeTerritoryGrid.CurrentPageIndex = 0;
<font color= "blue"></font>
<font color= "green"> // Show the table with the second grid, and update the headers</font>
<font color= "blue"> </font>ETTableColumn.Visible = true;
<font color= "blue"> </font>ETHeader.Text = territoryName;
<font color= "blue"> </font>BindList_EmpTerr(territoryName);
<font color= "blue"></font>
<font color= "green"> // Hide the 3rd table if it was visible</font>
<font color= "blue"> </font>EmpTableColumn.Visible = false;
<font color= "blue"> </font>}
<font color= "blue"> </font>
<font color= "blue"> protected void</font> ETGrid_Click(Object sender, CommandEventArgs e)
<font color= "blue"> </font>{
<font color= "blue"> </font>string[] cmdArgs = e.CommandArgument.ToString().Split(',');
<font color= "blue"></font>
<font color= "blue"> </font>string employeeName = cmdArgs[0];
<font color= "blue"> </font>int employeeID = Convert.ToInt32(cmdArgs[1]);
<font color= "blue"></font>
<font color= "green"> // Show the table with the 3rd grid, and update the headers</font>
<font color= "blue"> </font>EmpTableColumn.Visible = true;
<font color= "blue"> </font>EmployeeName.Text = employeeName;
<font color= "blue"> </font>BindList_Emp(employeeID);
<font color= "blue"> </font>}
<font color= "blue"></font>
<font color= "blue"> private void</font> ddlYear_SelectedIndexChanged(object sender, System.EventArgs e)
<font color= "blue"> </font>{
<font color= "green"> // Put the first grid back to the first page</font>
<font color= "blue"> </font>TerritoryGrid.CurrentPageIndex = 0;
<font color= "blue"></font>
<font color= "green"> // Hide the 2nd and 3rd table if they were visible</font>
<font color= "blue"> </font>ETTableColumn.Visible = false;
<font color= "blue"> </font>EmpTableColumn.Visible = false;
<font color= "blue"> </font>
<font color= "blue"> </font>BindList_Terr();
<font color= "blue"> </font>}
<font color= "blue"></</font><font color="maroon">script</font><font color= "blue">></font>
<font color= "blue"><!</font><font color="maroon">doctype</font> html public "-//w3c//dtd html 4.0 transitional//en" <font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">html</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">head</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">title</font><font color= "blue">></font>Hierarchical<font color= "blue"></</font><font color="maroon">title</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">meta</font> content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">link</font> href="<%= _styleSheet %<font color= "blue">></font>" type=text/css rel=stylesheet<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">script</font> src="scripts.js"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">script</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">head</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">body</font> class="Report" leftmargin="0" topmargin="0" marginheight="0" marginwidth="0"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">form</font> id="Tabular" method="post" runat="server"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">table</font> cellspacing="0" cellpadding="0" width="950" border="0"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">tr</font> height="20"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> colspan="3"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">tr</font> height="20"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> width="20"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> colspan="1"<font color= "blue">></font><font color= "blue"><</font><font color=blue>asp:dropdownlist runat="server" id="ddlYear" OnSelectedIndexChanged="ddlYear_SelectedIndexChanged" width="105px" autopostback="True"</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:listitem value="1996" selected="True"<font color= "blue">></font>1996<font color= "blue"></</font>asp:listitem</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:listitem value="1997"<font color= "blue">></font>1997<font color= "blue"></</font>asp:listitem</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:listitem value="1998"<font color= "blue">></font>1998<font color= "blue"></</font>asp:listitem</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:dropdownlist</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> align="right" width="50"<font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:hyperlink id="PrintButton" navigateurl="javascript:Print()" cssclass="printbutton" runat="server" visible="False"<font color= "blue">></font>Print<font color= "blue"></</font>asp:hyperlink</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">tr</font> height="20"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> colspan="4"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> width="20"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> colspan="2" width="225" valign="top"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">table</font> cellspacing="0" cellpadding="0" width="225" border="0"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryHeaderHier" width="5"<font color= "blue">></font> <font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryHeaderHier" valign="top"<font color= "blue">></font>Sales by Territory
<font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryHeaderHier" width="5"<font color= "blue">></font> <font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="Content"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="Content"<font color= "blue">></font><font color= "blue"><</font><font color=blue>asp:datagrid id="TerritoryGrid" runat="server" autogeneratecolumns="False" allowpaging="True" allowsorting="True" onsortcommand="SortGrid_Terr" onpageindexchanged="Page_Terr" gridlines="None" borderwidth="0px" pagesize="5"</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemstyle</font> height="15px"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">itemstyle</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">headerstyle</font> cssclass="ReportTitle"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">headerstyle</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">columns</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:templatecolumn sortexpression="Territory" headertext="Territory Name"</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemtemplate</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:linkbutton oncommand="TerritoryGrid_Click" commandname="TerritoryDrill" commandargument='<%# (String)DataBinder.Eval(Container, "DataItem.TerritoryDescription")%<font color= "blue">></font>' cssclass="hier" runat="server" id="Territorylnk" Text='<%# DataBinder.Eval(Container, "DataItem.TerritoryDescription") %<font color= "blue">></font>'</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:linkbutton</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">itemtemplate</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemstyle</font> width="150px"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">itemstyle</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:templatecolumn</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:boundcolumn datafield="SalesTotals" sortexpression="SalesTotals" headertext="Sales" dataformatstring="{0:c}"</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">headerstyle</font> cssclass="ProductHeaderRight"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">headerstyle</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemstyle</font> width="100px" cssclass="ItemStyleRight"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">itemstyle</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:boundcolumn</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">columns</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">pagerstyle</font> cssclass="PagerHier" prevpagetext="<font color= "blue"><</font><font color="maroon">;</font> Prev" nextpagetext="Next <font color= "blue">></font>;" height="30px" verticalalign="middle"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">pagerstyle</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:datagrid<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font></font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="Content"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">tr</font> height="10"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryFooterHier"<font color= "blue">></font> <font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryFooterHier" style="LINE-HEIGHT: 20px" valign="center" colspan="2"<font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:label id="CurrPage_Terr" runat="server"<font color= "blue">></font><font color= "blue"></</font>asp:label<font color= "blue">></font> of <font color= "blue"><</font>asp:label id="TotPages_Terr" runat="server"<font color= "blue">></font><font color= "blue"></</font>asp:label<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font></font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">table</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> width="20"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> width="225" valign="top"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">br</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">table</font> id="ETTableColumn" runat="server" visible="false" cellspacing="0" cellpadding="0" width="225" border="0"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryHeaderHierGold" width="5"<font color= "blue">></font> <font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryHeaderHierGold" valign="top"<font color= "blue">></font>Sales for '<font color= "blue"><</font><font color=blue>asp:label id="ETHeader" runat="server"<font color= "blue">></font><font color= "blue"></</font>asp:label</font><font color= "blue">></font>'
<font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryHeaderHierGold" width="5"<font color= "blue">></font> <font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font><font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font><font color= "blue">></font><font color= "blue"><</font><font color=blue>asp:datagrid id="EmployeeTerritoryGrid" runat="server" autogeneratecolumns="False" allowpaging="True" allowsorting="True" onsortcommand="SortGrid_EmpTerr" onpageindexchanged="Page_EmpTerr" gridlines="None" borderwidth="0px" pagesize="3"</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemstyle</font> height="15px"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">itemstyle</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">headerstyle</font> cssclass="ReportTitle"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">headerstyle</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">columns</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:templatecolumn sortexpression="EmployeeName" headertext="Employee Name"</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemtemplate</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:linkbutton oncommand="ETGrid_Click" commandargument='<%# (String) DataBinder.Eval(Container, "DataItem.EmployeeName") + "," + DataBinder.Eval(Container, "DataItem.EmployeeID").ToString() %<font color= "blue">></font>' cssclass="hier" runat="server" id="lnkEmployeeTerritory" text='<%# DataBinder.Eval(Container, "DataItem.EmployeeName") %<font color= "blue">></font>'</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:linkbutton</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">itemtemplate</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemstyle</font> width="150px"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">itemstyle</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:templatecolumn</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:boundcolumn datafield="SalesTotals" sortexpression="SalesTotals" headertext="Sales" dataformatstring="{0:c}"</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">headerstyle</font> cssclass="ProductHeaderRight"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">headerstyle</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemstyle</font> width="100px" cssclass="ItemStyleRight"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">itemstyle</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:boundcolumn</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">columns</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">pagerstyle</font> cssclass="PagerHier" prevpagetext="<font color= "blue"><</font><font color="maroon">;</font> Prev" nextpagetext="Next <font color= "blue">></font>;" height="30px" verticalalign="middle"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">pagerstyle</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:datagrid<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font></font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font><font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">tr</font> height="10"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryFooterHier"<font color= "blue">></font> <font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryFooterHier" style="LINE-HEIGHT: 20px" valign="center" colspan="2"<font color= "blue">></font><font color= "blue"><</font><font color=blue>asp:label id="CurrPage_EmpTerr" runat="server"<font color= "blue">></font><font color= "blue"></</font>asp:label</font><font color= "blue">></font>of
<font color= "blue"><</font><font color=blue>asp:label id="TotPages_EmpTerr" runat="server"<font color= "blue">></font><font color= "blue"></</font>asp:label<font color= "blue">></font> <font color= "blue"></</font><font color="maroon">td</font></font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">table</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> width="20"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> width="425" valign="top"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">p</font><font color= "blue">></font> <font color= "blue"></</font><font color="maroon">p</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">table</font> runat="server" id="EmpTableColumn" visible="false" cellspacing="0" cellpadding="0" width="425" border="0"<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryHeaderHierGold" width="5"<font color= "blue">></font> <font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryHeaderHierGold" valign="top"<font color= "blue">></font>Employee Info for '<font color= "blue"><</font><font color=blue>asp:label id="EmployeeName" runat="server"<font color= "blue">></font><font color= "blue"></</font>asp:label</font><font color= "blue">></font>'
<font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> class="CategoryHeaderHierGold" width="5"<font color= "blue">></font> <font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font><font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font><font color= "blue">></font><font color= "blue"><</font><font color=blue>asp:datagrid id="EmployeeGrid" runat="server" autogeneratecolumns="False" gridlines="None" borderwidth="0px"</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemstyle</font> height="15px"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">itemstyle</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">headerstyle</font> cssclass="ReportTitle"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">headerstyle</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">columns</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:boundcolumn datafield="EmployeeID" headertext="ID"</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemstyle</font> width="25px"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">itemstyle</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:boundcolumn</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:boundcolumn datafield="EmployeeTitle" headertext="Title"</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemstyle</font> width="140px"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">itemstyle</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:boundcolumn</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:templatecolumn headertext="Address"</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemtemplate</font><font color= "blue">></font>
<%# DataBinder.Eval(Container, "DataItem.EmployeeAddress") %<font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">br</font><font color= "blue">></font>
<%# DataBinder.Eval(Container, "DataItem.EmployeeCity") %<font color= "blue">></font>
,
<%# DataBinder.Eval(Container, "DataItem.EmployeeRegion") %<font color= "blue">></font>
<%# DataBinder.Eval(Container, "DataItem.EmployeePostalCode") %<font color= "blue">></font><font color= "blue"><</font><font color="maroon">br</font><font color= "blue">></font>
<%# DataBinder.Eval(Container, "DataItem.EmployeeCountry") %<font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">itemtemplate</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemstyle</font> width="160px"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">itemstyle</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:templatecolumn</font><font color= "blue">></font>
<font color= "blue"><</font><font color=blue>asp:boundcolumn datafield="EmployeePhone" headertext="Home Phone"</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">itemstyle</font> width="100px"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">itemstyle</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:boundcolumn</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">columns</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">pagerstyle</font> visible="False"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">pagerstyle</font><font color= "blue">></font>
<font color= "blue"></</font><font color=blue>asp:datagrid<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font></font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font><font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">table</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">td</font> width="*"<font color= "blue">></font><font color= "blue"></</font><font color="maroon">td</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">tr</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">table</font><font color= "blue">></font>
<font color= "blue"><</font><font color="maroon">p</font><font color= "blue">></font> <font color= "blue"></</font><font color="maroon">p</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">form</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">body</font><font color= "blue">></font>
<font color= "blue"></</font><font color="maroon">html</font><font color= "blue">></font>
</pre>
|
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 member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.