Skip Navigation Links > 03 Reporting > 01 Introduction > DAL
Welcome To Michael Shields Website!

Hello and WELCOME! DOWNLOAD EYA 1.0.1.1 EXE

You can Login , create a user or use Menu below.

NAVIGATION MENU
Home
DSe Hybrid(a solar powered yacht)

Skip Navigation Links
CertificationsExpand Certifications
00 DownloadsExpand 00 Downloads
01 Master PagesExpand 01 Master Pages
02 SecurityExpand 02 Security
03 ReportingExpand 03 Reporting



Coding Example -- Communicating from master page to detail page
  • The latest 5 products...
  • ProductNameUnitPrice
    20090422_11190.0000
    2009_04_220.0000
    Web_10.0000
    SeventyTwo630503947831869.4400
    FortyTwo349479331083950.4896




    Site Map

    One product retrieved using Data Access Layer

    All products for one supplier retreived using Data Access Layer
    ProductIDProductNameSupplierIDCategoryIDQuantityPerUnitUnitPriceUnitsInStockUnitsOnOrderReorderLevelDiscontinuedCategoryNameSupplierName
    78ProductName1211114411518807585.5872234  
    7920090422_1644179 0.0000000  
    8020090422_1121180 0.0000000  
    8120090422_123218120.0000456  
    8220090422_164811 0.0000000  
    8320090422_164911 0.0000000  
    8420090422_165011 0.0000000  
    85ProductName212132425917317067.5712234  
    8620090422_165211 0.0000000  
    91Test3313150440315826549.5552234  
    92Eleven1111190952624200509.0304234  
    93FortyTwo1421349479331083950.4896234  
    94SeventyTwo1721630503947831869.4400234  
    95Web_117310.0000234  
    962009_04_2217410.0000234  
    9720090422_111917610.0000111  

    All products for one category retreived using Data Access Layer
    ProductIDProductNameSupplierIDCategoryIDQuantityPerUnitUnitPriceUnitsInStockUnitsOnOrderReorderLevelDiscontinuedCategoryNameSupplierName
    24Guaraná Fantástica10112 - 355 ml cans0.00002000  
    34Sasquatch Ale16124 - 12 oz bottles0.0000111015  
    35Steeleye Stout16124 - 12 oz bottles0.000020015  
    38Côte de Blaye18112 - 75 cl bottles36028797018963.968017015  
    39Chartreuse verte181750 cc per bottle0.00006905  
    43Ipoh Coffee20116 - 500 g tins3602879701896.3968171025  
    67Laughing Lumberjack Lager16124 - 12 oz bottles0.000052010  
    70Outback Lager7124 - 355 ml bottles0.0000151030  
    75Rhönbräu Klosterbier12124 - 0.5 l bottles0.0000125025  
    76Lakkalikööri231500 ml0.000057020  
    78ProductName1211114411518807585.5872234  
    8220090422_164811 0.0000000  
    8320090422_164911 0.0000000  
    8420090422_165011 0.0000000  
    8620090422_165211 0.0000000  

    All products retreived using Data Access Layer
    ProductIDProductNameSupplierIDCategoryIDQuantityPerUnitUnitPriceUnitsInStockUnitsOnOrderReorderLevelDiscontinuedCategoryNameSupplierName
    11Queso Cabrales541 kg pkg.0.0000223030Dairy ProductsCooperativa de Quesos 'Las Cabras'
    12Queso Manchego La Pastora5410 - 500 g pkgs.3602879701896.39688600Dairy ProductsCooperativa de Quesos 'Las Cabras'
    13Konbu682 kg box0.00002405SeafoodMayumi's
    14Tofu6740 - 100 g pkgs.0.00003500ProduceMayumi's
    15Genen Shouyu6224 - 250 ml bottles0.00003905CondimentsMayumi's
    16Pavlova7332 - 500 g boxes0.000029010ConfectionsPavlova, Ltd.
    17Alice Mutton7620 - 1 kg tins3602879701896.3968000Meat/PoultryPavlova, Ltd.
    18Carnarvon Tigers7816 kg pkg.7205759403792.79364200SeafoodPavlova, Ltd.
    19Teatime Chocolate Biscuits8310 boxes x 12 pieces0.00002505ConfectionsSpecialty Biscuits, Ltd.
    20Sir Rodney's Marmalade8330 gift boxes10808639105689.19044000ConfectionsSpecialty Biscuits, Ltd.
    21Sir Rodney's Scones8324 pkgs. x 4 pieces0.00003405ConfectionsSpecialty Biscuits, Ltd.
    22Gustaf's Knäckebröd9524 - 500 g pkgs.0.0000104025Grains/CerealsPB Knäckebröd AB
    23Tunnbröd9512 - 250 g pkgs.0.000061025Grains/CerealsPB Knäckebröd AB
    24Guaraná Fantástica10112 - 355 ml cans0.00002000BeveragesRefrescos Americanas LTDA
    25NuNuCa Nuß-Nougat-Creme11320 - 450 g glasses0.000076030ConfectionsHeli Süßwaren GmbH & Co. KG
    26Gumbär Gummibärchen113100 - 250 g bags3602879701896.39681500ConfectionsHeli Süßwaren GmbH & Co. KG
    27Schoggi Schokolade113100 - 100 g pieces3602879701896.396849030ConfectionsHeli Süßwaren GmbH & Co. KG
    28Rössle Sauerkraut12725 - 825 g cans3602879701896.39682600ProducePlutzer Lebensmittelgroßmärkte AG
    29Thüringer Rostbratwurst12650 bags x 30 sausgs.14411518807585.5872000Meat/PoultryPlutzer Lebensmittelgroßmärkte AG
    30Nord-Ost Matjeshering13810 - 200 g glasses0.000010015SeafoodNord-Ost-Fisch Handelsgesellschaft mbH
    31Gorgonzola Telino14412 - 100 g pkgs0.000007020Dairy ProductsFormaggi Fortini s.r.l.
    32Mascarpone Fabioli14424 - 200 g pkgs.3602879701896.396894025Dairy ProductsFormaggi Fortini s.r.l.
    33Geitost154500 g0.0000112020Dairy ProductsNorske Meierier
    34Sasquatch Ale16124 - 12 oz bottles0.0000111015BeveragesBigfoot Breweries
    35Steeleye Stout16124 - 12 oz bottles0.000020015BeveragesBigfoot Breweries
    36Inlagd Sill17824 - 250 g jars0.0000112020SeafoodSvensk Sjöföda AB
    37Gravad lax17812 - 500 g pkgs.0.0000115025SeafoodSvensk Sjöföda AB
    38Côte de Blaye18112 - 75 cl bottles36028797018963.968017015BeveragesAux joyeux ecclésiastiques
    39Chartreuse verte181750 cc per bottle0.00006905BeveragesAux joyeux ecclésiastiques
    40Boston Crab Meat19824 - 4 oz tins0.0000123030SeafoodNew England Seafood Cannery
    41Jack's New England Clam Chowder19812 - 12 oz cans0.000085010SeafoodNew England Seafood Cannery
    42Singaporean Hokkien Fried Mee20532 - 1 kg pkgs.0.00002600Grains/CerealsLeka Trading
    43Ipoh Coffee20116 - 500 g tins3602879701896.3968171025BeveragesLeka Trading
    44Gula Malacca20220 - 2 kg bags0.000027015CondimentsLeka Trading
    45Rogede sild2181k pkg.0.000057015SeafoodLyngbysild
    46Spegesild2184 - 450 g glasses0.00009500SeafoodLyngbysild
    47Zaanse koeken22310 - 4 oz boxes0.00003600ConfectionsZaanse Snoepfabriek
    48Chocolade22310 pkgs.0.0000157025ConfectionsZaanse Snoepfabriek
    49Maxilaku23324 - 50 g pkgs.0.0000106015ConfectionsKarkki Oy
    50Valkoinen suklaa23312 - 100 g bars0.000065030ConfectionsKarkki Oy
    51Manjimup Dried Apples24750 - 300 g pkgs.7205759403792.793620010ProduceG'day, Mate
    52Filo Mix24516 - 2 kg boxes0.000038025Grains/CerealsG'day, Mate
    53Perth Pasties24648 pieces3602879701896.3968000Meat/PoultryG'day, Mate
    54Tourtière25616 pies0.000021010Meat/PoultryMa Maison
    55Pâté chinois25624 boxes x 2 pies0.0000115020Meat/PoultryMa Maison
    56Gnocchi di nonna Alice26524 - 250 g pkgs.3602879701896.3968211030Grains/CerealsPasta Buttini s.r.l.
    57Ravioli Angelo26524 - 250 g pkgs.0.000036020Grains/CerealsPasta Buttini s.r.l.
    58Escargots de Bourgogne27824 pieces0.000062020SeafoodEscargots Nouveaux
    59Raclette Courdavault2845 kg pkg.7205759403792.79367900Dairy ProductsGai pâturage
    60Camembert Pierrot28415 - 300 g rounds3602879701896.39681900Dairy ProductsGai pâturage
    61Sirop d'érable29224 - 500 ml bottles3602879701896.3968113025CondimentsForêts d'érables
    62Tarte au sucre29348 pies3602879701896.39681700ConfectionsForêts d'érables
    63Vegie-spread7215 - 625 g jars3602879701896.39682405CondimentsPavlova, Ltd.
    64Wimmers gute Semmelknödel12520 bags x 4 pieces3602879701896.3968228030Grains/CerealsPlutzer Lebensmittelgroßmärkte AG
    65Louisiana Fiery Hot Pepper Sauce2232 - 8 oz bottles0.00007600CondimentsNew Orleans Cajun Delights
    66Louisiana Hot Spiced Okra2224 - 8 oz jars0.0000410020CondimentsNew Orleans Cajun Delights
    67Laughing Lumberjack Lager16124 - 12 oz bottles0.000052010BeveragesBigfoot Breweries
    68Scottish Longbreads8310 boxes x 8 pieces0.000061015ConfectionsSpecialty Biscuits, Ltd.
    69Gudbrandsdalsost15410 kg pkg.3602879701896.396826015Dairy ProductsNorske Meierier
    70Outback Lager7124 - 355 ml bottles0.0000151030BeveragesPavlova, Ltd.
    71Flotemysost15410 - 500 g pkgs.0.00002600Dairy ProductsNorske Meierier
    72Mozzarella di Giovanni14424 - 200 g pkgs.3602879701896.39681400Dairy ProductsFormaggi Fortini s.r.l.
    73Röd Kaviar17824 - 150 g jars0.000010105SeafoodSvensk Sjöföda AB
    74Longlife Tofu475 kg pkg.0.00004205ProduceTokyo Traders
    75Rhönbräu Klosterbier12124 - 0.5 l bottles0.0000125025BeveragesPlutzer Lebensmittelgroßmärkte AG
    76Lakkalikööri231500 ml0.000057020BeveragesKarkki Oy
    77Original Frankfurter grüne Soße12212 boxes0.000032015CondimentsPlutzer Lebensmittelgroßmärkte AG
    78ProductName1211114411518807585.5872234BeveragesExotic Liquids
    7920090422_1644179 0.0000000 Exotic Liquids
    8020090422_1121180 0.0000000 Exotic Liquids
    8120090422_123218120.0000456 Exotic Liquids
    8220090422_164811 0.0000000BeveragesExotic Liquids
    8320090422_164911 0.0000000BeveragesExotic Liquids
    8420090422_165011 0.0000000BeveragesExotic Liquids
    85ProductName212132425917317067.5712234CondimentsExotic Liquids
    8620090422_165211 0.0000000BeveragesExotic Liquids
    8720090506_183400 0.0000000  
    8820090506_183400 0.0000000  
    8920090507_082800 0.0000000  
    9020090507_082800 0.0000000  
    91Test3313150440315826549.5552234ConfectionsExotic Liquids
    92Eleven1111190952624200509.0304234Category3Exotic Liquids
    93FortyTwo1421349479331083950.4896234 Exotic Liquids
    94SeventyTwo1721630503947831869.4400234 Exotic Liquids
    95Web_117310.0000234 Exotic Liquids
    962009_04_2217410.0000234 Exotic Liquids
    9720090422_111917610.0000111 Exotic Liquids