Viewing Excel Data in VS .NET

Print UCC - 12 in VS .NET Viewing Excel Data

and Options dialog box) The Office Chart control doesn t appear to contain any information, but it does have blanks into which you can drag and drop selected fields To add fields to the Office Chart control, right-click the control and choose Field List from the context menu You see a Chart Field List dialog box, as shown in Figure 1-11 This figure also shows the areas where you drag and drop the fields Each of these areas appears as a grayed-out square Creating the chart isn t difficult, but you have to plan it out Here s the drill:

Office Chart control, and drop it there When you add the field, FrontPage assumes you want to use all possible entries

You see a list of regions Choose only the regions you want to see onscreen They will form your X-axis

Drag the field from the Chart Field List dialog box to the Office Chart control Again, choose only the entries you want to use

the display you want Figure 1-12 shows typical results, including a list of regions for the current table

The Office PivotTable control requires that you create a connection to the database before you do anything else (Use the process described in the Creating a connection section to perform this task) After you have a connection in place, you ll notice that nothing happens the Office PivotTable control is still blank

To display data within the control, you must adds fields to it Adding fields to a pivot table is a straightforward process:

the Office PivotTable control, as shown in Figure 1-13

fields The totals that appear aren t calculated for the table To add totals to the Office PivotTable control, you must define the type of calculation to perform The next steps do so

The example uses the Sum option FrontPage calculates the totals, which adds a second line to each of the cells

the field entries FrontPage hides the additional information Figure 1-14 shows typical output for the Office PivotTable control

You see a list of entries for each field You can choose to display all or just some of the fields on the Web page making it easier for the user to see the data elements

Creating links to Access data Developing simple data views Working with search forms Developing views with more than one table

any Web designers today store page content in databases to ease the process of updating their Web sites With databases, it s easy to create an application that keeps the database content up to date automatically Microsoft Access provides most of the relational capabilities that database developers require to create complex applications It lacks some of the robust features of high-end databases, though, so many developers rely on Access to create local databases that only a few people use Most developers agree that Access handles 10 users just fine, but you might not get good results when you go beyond that number Even so, Access is often a perfect solution for a small business or a workgroup within a company One of the best parts about using Access is that it s a full-fledged relational solution; you don t have to use flat-file techniques (as you would with a spreadsheet) Access can create multiple indexes, multiple table setups, handle queries, and perform data manipulations with scripts It s also relatively easy to create reports with Access, which allows you to look at the data in its final form, and makes it unnecessary to modify the final data on the Web page or behind the scenes as part of a server-side script The same data can act as input for multiple reports and you can use multiple formats, from simple to complex and from friendly to formal The idea is to present a view of the data that your user can understand and appreciate