<%@ Page Title="Products" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="GridViewTotals_Products.aspx.cs" Inherits="Northwind45.GridViewTotals_Products" %> <asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server"> <%: Styles.Render("~/Styles/jquery.tooltip.css") %> <%: Scripts.Render("~/Scripts/jquery.tooltip.min.js") %> <%: Scripts.Render("~/Scripts/gridview-totals-script.js") %> <script type="text/javascript"> $(function () { InitializeToolTip(); }); </script> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
<b>Number of Records: <asp:Label ID="LblNumberOfRecords" runat="server" /></b><br /><br /> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <asp:GridView ID="GridView1" runat="server" DataKeyNames="ProductID" ItemType="Northwind45.BusinessObject.Products" SelectMethod="GetGridData" DeleteMethod="DeleteGridItem" onrowdatabound="GridView1_RowDataBound" onrowcreated="GridView1_RowCreated" SkinID="GridViewProfessional"> <Columns> <asp:BoundField DataField="ProductID" HeaderText="Product ID" ReadOnly="true" SortExpression="ProductID" ItemStyle-HorizontalAlign="Right" /> <asp:BoundField DataField="ProductName" HeaderText="Product Name" ReadOnly="true" SortExpression="ProductName" /> <asp:TemplateField HeaderText="Supplier ID" SortExpression="SupplierID" HeaderStyle-Wrap="false"> <ItemStyle Width="30px" HorizontalAlign="Center" /> <ItemTemplate> <div class="tag"> <a href="#" class="gridViewToolTip"><%#: Item.SupplierID.HasValue ? Item.SupplierID : null %></a> <div id="tooltip" style="display: none;"> <table style="text-align: left;"> <tr> <td style="white-space: nowrap;"><b>Supplier ID:</b> </td> <td><%#: Item.SupplierID.HasValue ? Item.Suppliers.Value.SupplierID : 0 %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Company Name:</b> </td> <td><%#: Item.SupplierID.HasValue ? Item.Suppliers.Value.CompanyName : null %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Contact Name:</b> </td> <td><%#: Item.SupplierID.HasValue ? Item.Suppliers.Value.ContactName : null %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Contact Title:</b> </td> <td><%#: Item.SupplierID.HasValue ? Item.Suppliers.Value.ContactTitle : null %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Address:</b> </td> <td><%#: Item.SupplierID.HasValue ? Item.Suppliers.Value.Address : null %></td> </tr> <tr> <td style="white-space: nowrap;"><b>City:</b> </td> <td><%#: Item.SupplierID.HasValue ? Item.Suppliers.Value.City : null %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Region:</b> </td> <td><%#: Item.SupplierID.HasValue ? Item.Suppliers.Value.Region : null %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Postal Code:</b> </td> <td><%#: Item.SupplierID.HasValue ? Item.Suppliers.Value.PostalCode : null %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Country:</b> </td> <td><%#: Item.SupplierID.HasValue ? Item.Suppliers.Value.Country : null %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Phone:</b> </td> <td><%#: Item.SupplierID.HasValue ? Item.Suppliers.Value.Phone : null %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Fax:</b> </td> <td><%#: Item.SupplierID.HasValue ? Item.Suppliers.Value.Fax : null %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Home Page:</b> </td> <td><%#: Item.SupplierID.HasValue ? Item.Suppliers.Value.HomePage : null %></td> </tr> </table> </div> </div> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Category ID" SortExpression="CategoryID" HeaderStyle-Wrap="false"> <ItemStyle Width="30px" HorizontalAlign="Center" /> <ItemTemplate> <div class="tag"> <a href="#" class="gridViewToolTip"><%#: Item.CategoryID.HasValue ? Item.CategoryID : null %></a> <div id="tooltip" style="display: none;"> <table style="text-align: left;"> <tr> <td style="white-space: nowrap;"><b>Category ID:</b> </td> <td><%#: Item.CategoryID.HasValue ? Item.Categories.Value.CategoryID : 0 %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Category Name:</b> </td> <td><%#: Item.CategoryID.HasValue ? Item.Categories.Value.CategoryName : null %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Description:</b> </td> <td><%#: Item.CategoryID.HasValue ? Item.Categories.Value.Description : null %></td> </tr> </table> </div> </div> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="QuantityPerUnit" HeaderText="Quantity Per Unit" ReadOnly="true" SortExpression="QuantityPerUnit" /> <asp:BoundField DataField="UnitPrice" HeaderText="Unit Price" ReadOnly="true" SortExpression="UnitPrice" DataFormatString="{0:c}" HtmlEncode="false" ItemStyle-HorizontalAlign="Right" /> <asp:BoundField DataField="UnitsInStock" HeaderText="Units In Stock" ReadOnly="true" SortExpression="UnitsInStock" DataFormatString="{0:N0}" HtmlEncode="false" ItemStyle-HorizontalAlign="Right" /> <asp:BoundField DataField="UnitsOnOrder" HeaderText="Units On Order" ReadOnly="true" SortExpression="UnitsOnOrder" DataFormatString="{0:N0}" HtmlEncode="false" ItemStyle-HorizontalAlign="Right" /> <asp:BoundField DataField="ReorderLevel" HeaderText="Reorder Level" ReadOnly="true" SortExpression="ReorderLevel" DataFormatString="{0:N0}" HtmlEncode="false" ItemStyle-HorizontalAlign="Right" /> <asp:CheckBoxField DataField="Discontinued" HeaderText="Discontinued" ReadOnly="true" SortExpression="Discontinued" ItemStyle-HorizontalAlign="Center" /> </Columns> <EmptyDataTemplate>No records found!</EmptyDataTemplate> </asp:GridView> </ContentTemplate> </asp:UpdatePanel> <asp:UpdateProgress ID="UpdateProgress1" AssociatedUpdatePanelID="UpdatePanel1" runat="server" DisplayAfter="0"> <ProgressTemplate> <br /> <img src="Images/ActivityIndicator.gif" alt="" /> Processing your request. Please wait.... </ProgressTemplate> </asp:UpdateProgress> </asp:Content>