which is the sum of all the ItemPrice (Web hosting control panel)

which is the sum of all the ItemPrice fields in DetailedItemsUsersView, expressed in a more meaningful format than Expr1: 469.4000. Showing subtotals Showing just the grand total of sales on a Web page is useful, but chances are you might also want to see things subtotaled by customer, product, or month. You could add a GridView control on the same page as the Grand Total, and have that GridView control show multiple records with the appropriate grouping. For example, with the previous FormView1 control still on the page, press Ctrl+Home a couple of times, and press Enter a couple of times, to make some space above the FormView control. Then drag a GridView control into that space at the top of the page. From the GridView s Common Tasks menu, select Choose Data Source. , as usual. Then choose Database and click OK. Choose your usual Connection String and click Next. You ll come to the Configure the Select Statement page where you ll once again need to choose Specify a custom SQL statement or stored procedure, then click Next. Figure 12-63: Item- Template for sample FormView control. Figure 12-62: Databindings for the Expr1 Label control. 314 Part III: Personalization and Databases
Go visit our java server pages services for a reliable, lowcost webhost to satisfy all your needs.

Leave a Reply