1 / 23

Unit 8.2

Unit 8.2. Learning Objectives Data Warehouses The Role of Data Warehouses Group Exercise Accessing Data in Views Accessing data in Graphical Web Controls Working with Templated Data Working with Hidden Cells Group Exercise. Databases. Database creation and use.

skyla
Download Presentation

Unit 8.2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Unit 8.2 Learning Objectives • Data Warehouses • The Role of Data Warehouses • Group Exercise • Accessing Data in Views • Accessing data in Graphical Web Controls • Working with Templated Data • Working with Hidden Cells • Group Exercise

  2. Databases • Database creation and use MS Visual Web Developer • Database and Query Development • MS SQL Server • Business Intelligence Microsoft BI, IBM Cognos • Real world Application Money Ball

  3. Data warehouses Please answer the following questions based on Intricity’sVideo on Benefits of a Data Warehouse • What is a Data Warehouse? • What is the impact of the fact that databases can take in one row of data at a time? • When the video says “You are doing it anyway, what is it talking about?” • List any two benefits of data warehousing.

  4. Collections of Rows • GridViews and DetailsViews contain a “collection” of Rows • Each Row contains a collection of Cells Cells Rows gvFees dvFee

  5. Locations of Cells 0 1 • DetailsViewdvFee • The Fee amount (i.e. 7.5000) • dvFee.Rows[2].Cells[1] • GridView: gvFees ( “Select” is Column 0) • The FID of (i.e. 1) is in • gvFees.Rows[0].Cells[1] • The Weight Fee (i.e. 12.5) is in • gvFees.Rows[2].Cells[3] 0 1 2 0 1 2 3 0 1 2

  6. Types of Cells: Standard and Templated

  7. Accessing Data in Standard Cells If • The cell does NOT contain a CheckBox, AND • It has NOT been converted to a Template Then • Your data is in the Text property of the Cell • Example: Otherwise • Use the FindControl utility • Example: LabellblFees = new Label(); lblFee.Text= gvFees.Rows[3].Cells[2].Text; LabellblFees= gvFee.Rows[3].Cells[2].FindControl(“lblFee”)) as Label;

  8. Basic Templates Guidelines To create/use templates, remember three things • Web control type (e.g. Label) • Its name (e.g. “lblFeeDescription”), • Its location (e.g. in ItemTemplates ). Why use to Templates • To add validators • To insert new values into the database

  9. Template Example: DetailsView To use templated data, convert them directly into labels.

  10. Hiding data in DetailViews

  11. The Data is NOT where you think it is 0 1 0 1 2 • dvFee.Rows[2].Cells[1] 0 1 Invisible field is still here 0 1 2 What is the location of the fee?

  12. How to tell • Examine at the “SelectedFields” window • Fee Description is still the second field (it is row 1) • And the Fee is still the third field (row 2) 0 1 2

  13. Finding Data in GridViews The SelectedIndex is used to index the row and is -1 if no row is selected • All Data is located in the row selected by the user

  14. All rows of a GridView • Use a special loop called “foreach” • Loops through a collection of rows • One row at a time The type of object being extracted from the collection The collection being looped through

  15. Unit 8 L2 • For this exercise we are going to modify your Unit 5 L2 assignment, replacing the fees ListBox with a fees GridView • Start by Opening your ASPPub and copying your yournameU5L2.aspx files into the Unit8 folder. • Rename the files to yournameU8L2 • Change the page heading from UNIT 5 L2… to UNIT 8 L2 WORKING GRIDVIEW

  16. Unit 8 L2 - 2 • Delete the fees ListBox and put a GridView in its place. Give the GridView the (ID) of gvFees • Click on the GridView’sSmartMenu, click the dropdown next to Choose Data Source and select <New data source> • Select SQL Database and change its ID to sdsFees • Click OK and select the connection you created in U8L1

  17. Unit 8 L2 - 3 • Click Next, select the Fees table and select all the fields individually • Click Next and click Text Query to see the records in the table, then click Finish • Apply an Auto Format to the Gridview and change its width to 300px. • Select Edit Columns from the GridViewsSmartMenu • Select TemplateField from Available Fields and press Add

  18. Unit 8 L2 – 4 • Click the Up Arrow key to move the TemplateField to the top of the Selected fields list • Select FID from Selected fields and change its Visible property to false • Select the FeeDescription field • change its HeaderText property to Description • Change its Styles, HeaderStyle, HorizontalAlign to Left • Select the Fee field and change its DataFormatString to {0:f2}

  19. Unit 8 L2 - 5 • Click OK and then EditTemplates, you should be looking at your new ItemTemplate • Add a CheckBox to the ItemTemplate • Change its (ID) to ckbSelect • Change its Text to Select • End Template Editing • You should have something that looks something like this

  20. Unit 8 L2 - 6 • Delete the WHILE loop button and all its associate code (the easiest way to do this may be do double-click the button to get to the code, select all the click method code and delete it, switch back to design view and delete the button) • Delete the FOR loop button and all its associate code • Double-click the sales tax button and locate and delete the code used in Unit 5 to process the ListBox(leave the lines that calculate the tax and those that write to the Label)

  21. Unit 8 L2 - 7 • In place of the ListBox code write a foreach loop to process the GridView rows: • Find the CheckBox. Remember the data type & cast it • Is it Checked? • Locate the Fee and add it to decFees(remember, the invisible FID field still takes up a Cell!) • Run the page and try • A sales with no fees • A sales with one or more fees • Check your answers! foreach(GridViewRowgvRowingvFees.Rows) {

  22. Unit 8 L2 - 8 • Once you are sure that your calculations work • Add code to reset the checkboxes • This should be a foreach loop that • Locates the CheckBox in the GrideViewRow and • Sets its Checked property to false • Test the page with the same data as before to be sure you get the same answers and that the checkboxes are reset • Once you are sure the page works, link it to your MIS3200 profile page and save your complete ASPPub to ASPNET as you have done before • Post a link to your MIS3200 portfolio page in the dropbox

  23. Think About It! • A DetailsView and a GridView always look like tables. Think of some applications where you might want to display data in a different way. • A FormView shows one record at a time, like the DetailsView, but it isn’t divided into Rows and Cells. How do you think you would access data in a FormView.

More Related