<%@ Page Title="Products" Language="VB" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="GridViewTotals_Products.aspx.vb" 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"><%#: If(Item.SupplierID.HasValue, Item.SupplierID, Nothing) %></a> <div id="tooltip" style="display: none;"> <table style="text-align: left;"> <tr> <td style="white-space: nowrap;"><b>Supplier ID:</b> </td> <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.SupplierID, 0) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Company Name:</b> </td> <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.CompanyName, Nothing) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Contact Name:</b> </td> <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.ContactName, Nothing) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Contact Title:</b> </td> <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.ContactTitle, Nothing) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Address:</b> </td> <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.Address, Nothing) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>City:</b> </td> <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.City, Nothing) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Region:</b> </td> <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.Region, Nothing) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Postal Code:</b> </td> <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.PostalCode, Nothing) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Country:</b> </td> <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.Country, Nothing) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Phone:</b> </td> <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.Phone, Nothing) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Fax:</b> </td> <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.Fax, Nothing) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Home Page:</b> </td> <td><%#: If(Item.SupplierID.HasValue, Item.Suppliers.Value.HomePage, Nothing) %></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"><%#: If(Item.CategoryID.HasValue, Item.CategoryID, Nothing) %></a> <div id="tooltip" style="display: none;"> <table style="text-align: left;"> <tr> <td style="white-space: nowrap;"><b>Category ID:</b> </td> <td><%#: If(Item.CategoryID.HasValue, Item.Categories.Value.CategoryID, 0) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Category Name:</b> </td> <td><%#: If(Item.CategoryID.HasValue, Item.Categories.Value.CategoryName, Nothing) %></td> </tr> <tr> <td style="white-space: nowrap;"><b>Description:</b> </td> <td><%#: If(Item.CategoryID.HasValue, Item.Categories.Value.Description, Nothing) %></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>