LINQ To DataSet Samples - DataSet Loading examplesOn This Page |
Load an existing DataTable with query results
Public Sub DataSetLinq117a()
Dim customers = TestDS.Tables("Customers").AsEnumerable()
Dim orders = TestDS.Tables("Orders").AsEnumerable()
Dim query = From o In orders _
Where o("Total") < 500.0# _
Select o
Dim results = query.CopyToDataTable()
PrettyPrintDataTable(results)
End Sub
Result:
Table:
OrderID = 10702 CustomerID = ALFKI OrderDate = 10/13/1997 12:00:00 AM Total = 330.00
OrderID = 10952 CustomerID = ALFKI OrderDate = 3/16/1998 12:00:00 AM Total = 471.20
OrderID = 10308 CustomerID = ANATR OrderDate = 9/18/1996 12:00:00 AM Total = 88.80
OrderID = 10625 CustomerID = ANATR OrderDate = 8/8/1997 12:00:00 AM Total = 479.75
OrderID = 10759 CustomerID = ANATR OrderDate = 11/28/1997 12:00:00 AM Total = 320.00
OrderID = 10365 CustomerID = ANTON OrderDate = 11/27/1996 12:00:00 AM Total = 403.20
OrderID = 10682 CustomerID = ANTON OrderDate = 9/25/1997 12:00:00 AM Total = 375.50
OrderID = 10355 CustomerID = AROUT OrderDate = 11/15/1996 12:00:00 AM Total = 480.00
OrderID = 10453 CustomerID = AROUT OrderDate = 2/21/1997 12:00:00 AM Total = 407.70
OrderID = 10741 CustomerID = AROUT OrderDate = 11/14/1997 12:00:00 AM Total = 228.00
OrderID = 10743 CustomerID = AROUT OrderDate = 11/17/1997 12:00:00 AM Total = 319.20
OrderID = 10793 CustomerID = AROUT OrderDate = 12/24/1997 12:00:00 AM Total = 191.10
OrderID = 10864 CustomerID = AROUT OrderDate = 2/2/1998 12:00:00 AM Total = 282.00
OrderID = 10920 CustomerID = AROUT OrderDate = 3/3/1998 12:00:00 AM Total = 390.00
OrderID = 11016 CustomerID = AROUT OrderDate = 4/10/1998 12:00:00 AM Total = 491.50
OrderID = 10445 CustomerID = BERGS OrderDate = 2/13/1997 12:00:00 AM Total = 174.90
OrderID = 10689 CustomerID = BERGS OrderDate = 10/1/1997 12:00:00 AM Total = 472.50
OrderID = 10778 CustomerID = BERGS OrderDate = 12/16/1997 12:00:00 AM Total = 96.50
OrderID = 10501 CustomerID = BLAUS OrderDate = 4/9/1997 12:00:00 AM Total = 149.00
OrderID = 10509 CustomerID = BLAUS OrderDate = 4/17/1997 12:00:00 AM Total = 136.80
OrderID = 10582 CustomerID = BLAUS OrderDate = 6/27/1997 12:00:00 AM Total = 330.00
OrderID = 10614 CustomerID = BLAUS OrderDate = 7/29/1997 12:00:00 AM Total = 464.00
OrderID = 10628 CustomerID = BLONP OrderDate = 8/12/1997 12:00:00 AM Total = 450.00
OrderID = 10970 CustomerID = BOLID OrderDate = 3/24/1998 12:00:00 AM Total = 224.00
OrderID = 10331 CustomerID = BONAP OrderDate = 10/16/1996 12:00:00 AM Total = 88.50
OrderID = 10730 CustomerID = BONAP OrderDate = 11/5/1997 12:00:00 AM Total = 484.26
OrderID = 10732 CustomerID = BONAP OrderDate = 11/6/1997 12:00:00 AM Total = 360.00
OrderID = 10940 CustomerID = BONAP OrderDate = 3/11/1998 12:00:00 AM Total = 360.00
OrderID = 10289 CustomerID = BSBEV OrderDate = 8/26/1996 12:00:00 AM Total = 479.40
OrderID = 10484 CustomerID = BSBEV OrderDate = 3/24/1997 12:00:00 AM Total = 386.20
OrderID = 10538 CustomerID = BSBEV OrderDate = 5/15/1997 12:00:00 AM Total = 139.80
OrderID = 10539 CustomerID = BSBEV OrderDate = 5/16/1997 12:00:00 AM Total = 355.50
OrderID = 10578 CustomerID = BSBEV OrderDate = 6/24/1997 12:00:00 AM Total = 477.00
OrderID = 10599 CustomerID = BSBEV OrderDate = 7/15/1997 12:00:00 AM Total = 493.00
OrderID = 10947 CustomerID = BSBEV OrderDate = 3/13/1998 12:00:00 AM Total = 220.00
OrderID = 10521 CustomerID = CACTU OrderDate = 4/29/1997 12:00:00 AM Total = 225.50
OrderID = 10782 CustomerID = CACTU OrderDate = 12/17/1997 12:00:00 AM Total = 12.50
OrderID = 10819 CustomerID = CACTU OrderDate = 1/7/1998 12:00:00 AM Total = 477.00
OrderID = 10881 CustomerID = CACTU OrderDate = 2/11/1998 12:00:00 AM Total = 150.00
OrderID = 11054 CustomerID = CACTU OrderDate = 4/28/1998 12:00:00 AM Total = 305.00
OrderID = 10259 CustomerID = CENTC OrderDate = 7/18/1996 12:00:00 AM Total = 100.80
OrderID = 10466 CustomerID = COMMI OrderDate = 3/6/1997 12:00:00 AM Total = 216.00
OrderID = 10969 CustomerID = COMMI OrderDate = 3/23/1998 12:00:00 AM Total = 108.00
OrderID = 11042 CustomerID = COMMI OrderDate = 4/22/1998 12:00:00 AM Total = 405.75
OrderID = 10462 CustomerID = CONSH OrderDate = 3/3/1997 12:00:00 AM Total = 156.00
OrderID = 10363 CustomerID = DRACD OrderDate = 11/26/1996 12:00:00 AM Total = 447.20
OrderID = 10391 CustomerID = DRACD OrderDate = 12/23/1996 12:00:00 AM Total = 86.40
OrderID = 10797 CustomerID = DRACD OrderDate = 12/25/1997 12:00:00 AM Total = 420.00
OrderID = 11067 CustomerID = DRACD OrderDate = 5/4/1998 12:00:00 AM Total = 86.85
OrderID = 10311 CustomerID = DUMON OrderDate = 9/20/1996 12:00:00 AM Total = 268.80
OrderID = 10609 CustomerID = DUMON OrderDate = 7/24/1997 12:00:00 AM Total = 424.00
OrderID = 10683 CustomerID = DUMON OrderDate = 9/26/1997 12:00:00 AM Total = 63.00
OrderID = 10771 CustomerID = ERNSH OrderDate = 12/10/1997 12:00:00 AM Total = 344.00
OrderID = 10386 CustomerID = FAMIA OrderDate = 12/18/1996 12:00:00 AM Total = 166.00
OrderID = 10414 CustomerID = FAMIA OrderDate = 1/14/1997 12:00:00 AM Total = 224.83
OrderID = 10581 CustomerID = FAMIA OrderDate = 6/26/1997 12:00:00 AM Total = 310.00
OrderID = 10725 CustomerID = FAMIA OrderDate = 10/31/1997 12:00:00 AM Total = 287.80
OrderID = 10378 CustomerID = FOLKO OrderDate = 12/10/1996 12:00:00 AM Total = 103.20
OrderID = 10434 CustomerID = FOLKO OrderDate = 2/3/1997 12:00:00 AM Total = 321.12
OrderID = 10460 CustomerID = FOLKO OrderDate = 2/28/1997 12:00:00 AM Total = 176.10
OrderID = 10824 CustomerID = FOLKO OrderDate = 1/9/1998 12:00:00 AM Total = 250.80
OrderID = 10955 CustomerID = FOLKO OrderDate = 3/17/1998 12:00:00 AM Total = 74.40
OrderID = 10980 CustomerID = FOLKO OrderDate = 3/27/1998 12:00:00 AM Total = 248.00
OrderID = 10422 CustomerID = FRANS OrderDate = 1/22/1997 12:00:00 AM Total = 49.80
OrderID = 10710 CustomerID = FRANS OrderDate = 10/20/1997 12:00:00 AM Total = 93.50
OrderID = 10753 CustomerID = FRANS OrderDate = 11/25/1997 12:00:00 AM Total = 88.00
OrderID = 10807 CustomerID = FRANS OrderDate = 12/31/1997 12:00:00 AM Total = 18.40
OrderID = 11060 CustomerID = FRANS OrderDate = 4/30/1998 12:00:00 AM Total = 266.00
OrderID = 10352 CustomerID = FURIB OrderDate = 11/12/1996 12:00:00 AM Total = 136.30
OrderID = 10491 CustomerID = FURIB OrderDate = 3/31/1997 12:00:00 AM Total = 259.50
OrderID = 10604 CustomerID = FURIB OrderDate = 7/18/1997 12:00:00 AM Total = 230.85
OrderID = 10963 CustomerID = FURIB OrderDate = 3/19/1998 12:00:00 AM Total = 57.80
OrderID = 10366 CustomerID = GALED OrderDate = 11/28/1996 12:00:00 AM Total = 136.00
OrderID = 10426 CustomerID = GALED OrderDate = 1/27/1997 12:00:00 AM Total = 338.20
OrderID = 10568 CustomerID = GALED OrderDate = 6/13/1997 12:00:00 AM Total = 155.00
OrderID = 10887 CustomerID = GALED OrderDate = 2/13/1998 12:00:00 AM Total = 70.00
OrderID = 10928 CustomerID = GALED OrderDate = 3/5/1998 12:00:00 AM Total = 137.50
OrderID = 10874 CustomerID = GODOS OrderDate = 2/6/1998 12:00:00 AM Total = 310.00
OrderID = 11037 CustomerID = GODOS OrderDate = 4/21/1998 12:00:00 AM Total = 60.00
OrderID = 10652 CustomerID = GOURL OrderDate = 9/1/1997 12:00:00 AM Total = 318.84
OrderID = 10777 CustomerID = GOURL OrderDate = 12/15/1997 12:00:00 AM Total = 224.00
OrderID = 10959 CustomerID = GOURL OrderDate = 3/18/1998 12:00:00 AM Total = 131.75
OrderID = 11049 CustomerID = GOURL OrderDate = 4/24/1998 12:00:00 AM Total = 273.60
OrderID = 10528 CustomerID = GREAL OrderDate = 5/6/1997 12:00:00 AM Total = 392.20
OrderID = 10589 CustomerID = GREAL OrderDate = 7/4/1997 12:00:00 AM Total = 72.00
OrderID = 10936 CustomerID = GREAL OrderDate = 3/9/1998 12:00:00 AM Total = 456.00
OrderID = 11006 CustomerID = GREAL OrderDate = 4/7/1998 12:00:00 AM Total = 329.68
OrderID = 11040 CustomerID = GREAL OrderDate = 4/22/1998 12:00:00 AM Total = 200.00
OrderID = 10785 CustomerID = GROSR OrderDate = 12/18/1997 12:00:00 AM Total = 387.50
OrderID = 10770 CustomerID = HANAR OrderDate = 12/9/1997 12:00:00 AM Total = 236.25
OrderID = 10925 CustomerID = HANAR OrderDate = 3/4/1998 12:00:00 AM Total = 475.15
OrderID = 10476 CustomerID = HILAA OrderDate = 3/17/1997 12:00:00 AM Total = 180.48
OrderID = 10613 CustomerID = HILAA OrderDate = 7/29/1997 12:00:00 AM Total = 353.20
OrderID = 10705 CustomerID = HILAA OrderDate = 10/15/1997 12:00:00 AM Total = 378.00
OrderID = 10863 CustomerID = HILAA OrderDate = 2/2/1998 12:00:00 AM Total = 441.15
OrderID = 10960 CustomerID = HILAA OrderDate = 3/19/1998 12:00:00 AM Total = 265.35
OrderID = 10375 CustomerID = HUNGC OrderDate = 12/6/1996 12:00:00 AM Total = 338.00
OrderID = 10394 CustomerID = HUNGC OrderDate = 12/25/1996 12:00:00 AM Total = 442.00
OrderID = 10415 CustomerID = HUNGC OrderDate = 1/15/1997 12:00:00 AM Total = 102.40
OrderID = 10600 CustomerID = HUNGC OrderDate = 7/16/1997 12:00:00 AM Total = 479.80
OrderID = 10318 CustomerID = ISLAT OrderDate = 10/1/1996 12:00:00 AM Total = 240.40
OrderID = 10321 CustomerID = ISLAT OrderDate = 10/3/1996 12:00:00 AM Total = 144.00
OrderID = 10473 CustomerID = ISLAT OrderDate = 3/13/1997 12:00:00 AM Total = 230.40
OrderID = 10674 CustomerID = ISLAT OrderDate = 9/18/1997 12:00:00 AM Total = 45.00
OrderID = 10798 CustomerID = ISLAT OrderDate = 12/26/1997 12:00:00 AM Total = 446.60
OrderID = 10323 CustomerID = KOENE OrderDate = 10/7/1996 12:00:00 AM Total = 164.40
OrderID = 10506 CustomerID = KOENE OrderDate = 4/15/1997 12:00:00 AM Total = 415.80
OrderID = 10542 CustomerID = KOENE OrderDate = 5/20/1997 12:00:00 AM Total = 469.11
OrderID = 10972 CustomerID = LACOR OrderDate = 3/24/1998 12:00:00 AM Total = 251.50
OrderID = 10973 CustomerID = LACOR OrderDate = 3/24/1998 12:00:00 AM Total = 291.55
OrderID = 10358 CustomerID = LAMAI OrderDate = 11/20/1996 12:00:00 AM Total = 429.40
OrderID = 10371 CustomerID = LAMAI OrderDate = 12/3/1996 12:00:00 AM Total = 72.96
OrderID = 10425 CustomerID = LAMAI OrderDate = 1/24/1997 12:00:00 AM Total = 360.00
OrderID = 10454 CustomerID = LAMAI OrderDate = 2/21/1997 12:00:00 AM Total = 331.20
OrderID = 10610 CustomerID = LAMAI OrderDate = 7/25/1997 12:00:00 AM Total = 299.25
OrderID = 10631 CustomerID = LAMAI OrderDate = 8/14/1997 12:00:00 AM Total = 55.80
OrderID = 10832 CustomerID = LAMAI OrderDate = 1/14/1998 12:00:00 AM Total = 475.11
OrderID = 11051 CustomerID = LAMAI OrderDate = 4/27/1998 12:00:00 AM Total = 36.00
OrderID = 10495 CustomerID = LAUGB OrderDate = 4/3/1997 12:00:00 AM Total = 278.00
OrderID = 10620 CustomerID = LAUGB OrderDate = 8/5/1997 12:00:00 AM Total = 57.50
OrderID = 10810 CustomerID = LAUGB OrderDate = 1/1/1998 12:00:00 AM Total = 187.00
OrderID = 10482 CustomerID = LAZYK OrderDate = 3/21/1997 12:00:00 AM Total = 147.00
OrderID = 10545 CustomerID = LAZYK OrderDate = 5/22/1997 12:00:00 AM Total = 210.00
OrderID = 10279 CustomerID = LEHMS OrderDate = 8/13/1996 12:00:00 AM Total = 351.00
OrderID = 10534 CustomerID = LEHMS OrderDate = 5/12/1997 12:00:00 AM Total = 465.70
OrderID = 10891 CustomerID = LEHMS OrderDate = 2/17/1998 12:00:00 AM Total = 368.93
OrderID = 10579 CustomerID = LETSS OrderDate = 6/25/1997 12:00:00 AM Total = 317.75
OrderID = 10381 CustomerID = LILAS OrderDate = 12/12/1996 12:00:00 AM Total = 112.00
OrderID = 10899 CustomerID = LILAS OrderDate = 2/20/1998 12:00:00 AM Total = 122.40
OrderID = 11065 CustomerID = LILAS OrderDate = 5/1/1998 12:00:00 AM Total = 189.42
OrderID = 11071 CustomerID = LILAS OrderDate = 5/5/1998 12:00:00 AM Total = 484.50
OrderID = 10405 CustomerID = LINOD OrderDate = 1/6/1997 12:00:00 AM Total = 400.00
OrderID = 10840 CustomerID = LINOD OrderDate = 1/19/1998 12:00:00 AM Total = 211.20
OrderID = 11014 CustomerID = LINOD OrderDate = 4/10/1998 12:00:00 AM Total = 243.18
OrderID = 10307 CustomerID = LONEP OrderDate = 9/17/1996 12:00:00 AM Total = 424.00
OrderID = 10317 CustomerID = LONEP OrderDate = 9/30/1996 12:00:00 AM Total = 288.00
OrderID = 10544 CustomerID = LONEP OrderDate = 5/21/1997 12:00:00 AM Total = 417.20
OrderID = 10662 CustomerID = LONEP OrderDate = 9/9/1997 12:00:00 AM Total = 125.00
OrderID = 10867 CustomerID = LONEP OrderDate = 2/3/1998 12:00:00 AM Total = 98.40
OrderID = 10883 CustomerID = LONEP OrderDate = 2/12/1998 12:00:00 AM Total = 36.00
OrderID = 10275 CustomerID = MAGAA OrderDate = 8/7/1996 12:00:00 AM Total = 291.84
OrderID = 10467 CustomerID = MAGAA OrderDate = 3/6/1997 12:00:00 AM Total = 235.20
OrderID = 10754 CustomerID = MAGAA OrderDate = 11/25/1997 12:00:00 AM Total = 55.20
OrderID = 10950 CustomerID = MAGAA OrderDate = 3/16/1998 12:00:00 AM Total = 110.00
OrderID = 11004 CustomerID = MAISD OrderDate = 4/7/1998 12:00:00 AM Total = 295.38
OrderID = 10376 CustomerID = MEREP OrderDate = 12/9/1996 12:00:00 AM Total = 399.00
OrderID = 10505 CustomerID = MEREP OrderDate = 4/14/1997 12:00:00 AM Total = 147.90
OrderID = 10699 CustomerID = MORGK OrderDate = 10/9/1997 12:00:00 AM Total = 114.00
OrderID = 10945 CustomerID = MORGK OrderDate = 3/12/1998 12:00:00 AM Total = 245.00
OrderID = 10517 CustomerID = NORTS OrderDate = 4/24/1997 12:00:00 AM Total = 352.00
OrderID = 10752 CustomerID = NORTS OrderDate = 11/24/1997 12:00:00 AM Total = 252.00
OrderID = 11057 CustomerID = NORTS OrderDate = 4/29/1998 12:00:00 AM Total = 45.00
OrderID = 10409 CustomerID = OCEAN OrderDate = 1/9/1997 12:00:00 AM Total = 319.20
OrderID = 10531 CustomerID = OCEAN OrderDate = 5/8/1997 12:00:00 AM Total = 110.00
OrderID = 10898 CustomerID = OCEAN OrderDate = 2/20/1998 12:00:00 AM Total = 30.00
OrderID = 10508 CustomerID = OTTIK OrderDate = 4/16/1997 12:00:00 AM Total = 240.00
OrderID = 10322 CustomerID = PERIC OrderDate = 10/4/1996 12:00:00 AM Total = 112.00
OrderID = 11073 CustomerID = PERIC OrderDate = 5/5/1998 12:00:00 AM Total = 300.00
OrderID = 10489 CustomerID = PICCO OrderDate = 3/28/1997 12:00:00 AM Total = 439.20
OrderID = 10336 CustomerID = PRINI OrderDate = 10/23/1996 12:00:00 AM Total = 285.12
OrderID = 10261 CustomerID = QUEDE OrderDate = 7/19/1996 12:00:00 AM Total = 448.00
OrderID = 10291 CustomerID = QUEDE OrderDate = 8/27/1996 12:00:00 AM Total = 497.52
OrderID = 10794 CustomerID = QUEDE OrderDate = 12/24/1997 12:00:00 AM Total = 314.76
OrderID = 10313 CustomerID = QUICK OrderDate = 9/24/1996 12:00:00 AM Total = 182.40
OrderID = 10448 CustomerID = RANCH OrderDate = 2/17/1997 12:00:00 AM Total = 443.40
OrderID = 11019 CustomerID = RANCH OrderDate = 4/13/1998 12:00:00 AM Total = 76.00
OrderID = 10288 CustomerID = REGGC OrderDate = 8/23/1996 12:00:00 AM Total = 80.10
OrderID = 10428 CustomerID = REGGC OrderDate = 1/28/1997 12:00:00 AM Total = 192.00
OrderID = 10562 CustomerID = REGGC OrderDate = 6/9/1997 12:00:00 AM Total = 488.70
OrderID = 10586 CustomerID = REGGC OrderDate = 7/2/1997 12:00:00 AM Total = 23.80
OrderID = 10655 CustomerID = REGGC OrderDate = 9/3/1997 12:00:00 AM Total = 154.40
OrderID = 11062 CustomerID = REGGC OrderDate = 4/30/1998 12:00:00 AM Total = 406.40
OrderID = 10299 CustomerID = RICAR OrderDate = 9/6/1996 12:00:00 AM Total = 349.50
OrderID = 10648 CustomerID = RICAR OrderDate = 8/28/1997 12:00:00 AM Total = 372.38
OrderID = 10951 CustomerID = RICSU OrderDate = 3/16/1998 12:00:00 AM Total = 458.76
OrderID = 11075 CustomerID = RICSU OrderDate = 5/6/1998 12:00:00 AM Total = 498.10
OrderID = 10281 CustomerID = ROMEY OrderDate = 8/14/1996 12:00:00 AM Total = 86.50
OrderID = 10282 CustomerID = ROMEY OrderDate = 8/15/1996 12:00:00 AM Total = 155.40
OrderID = 10306 CustomerID = ROMEY OrderDate = 9/16/1996 12:00:00 AM Total = 498.50
OrderID = 10917 CustomerID = ROMEY OrderDate = 3/2/1998 12:00:00 AM Total = 365.89
OrderID = 11013 CustomerID = ROMEY OrderDate = 4/9/1998 12:00:00 AM Total = 361.00
OrderID = 10520 CustomerID = SANTG OrderDate = 4/29/1997 12:00:00 AM Total = 200.00
OrderID = 10815 CustomerID = SAVEA OrderDate = 1/5/1998 12:00:00 AM Total = 40.00
OrderID = 10341 CustomerID = SIMOB OrderDate = 10/29/1996 12:00:00 AM Total = 352.60
OrderID = 11074 CustomerID = SIMOB OrderDate = 5/6/1998 12:00:00 AM Total = 232.08
OrderID = 10738 CustomerID = SPECD OrderDate = 11/12/1997 12:00:00 AM Total = 52.35
OrderID = 10907 CustomerID = SPECD OrderDate = 2/25/1998 12:00:00 AM Total = 108.50
OrderID = 11043 CustomerID = SPECD OrderDate = 4/22/1998 12:00:00 AM Total = 210.00
OrderID = 10271 CustomerID = SPLIR OrderDate = 8/1/1996 12:00:00 AM Total = 48.00
OrderID = 10349 CustomerID = SPLIR OrderDate = 11/8/1996 12:00:00 AM Total = 141.60
OrderID = 10432 CustomerID = SPLIR OrderDate = 1/31/1997 12:00:00 AM Total = 485.00
OrderID = 10974 CustomerID = SPLIR OrderDate = 3/25/1998 12:00:00 AM Total = 439.00
OrderID = 10767 CustomerID = SUPRD OrderDate = 12/5/1997 12:00:00 AM Total = 28.00
OrderID = 10310 CustomerID = THEBI OrderDate = 9/20/1996 12:00:00 AM Total = 336.00
OrderID = 10708 CustomerID = THEBI OrderDate = 10/17/1997 12:00:00 AM Total = 180.40
OrderID = 10992 CustomerID = THEBI OrderDate = 4/1/1998 12:00:00 AM Total = 69.60
OrderID = 10775 CustomerID = THECR OrderDate = 12/12/1997 12:00:00 AM Total = 228.00
OrderID = 11003 CustomerID = THECR OrderDate = 4/6/1998 12:00:00 AM Total = 326.00
OrderID = 10438 CustomerID = TOMSP OrderDate = 2/6/1997 12:00:00 AM Total = 454.00
OrderID = 10446 CustomerID = TOMSP OrderDate = 2/14/1997 12:00:00 AM Total = 246.24
OrderID = 10548 CustomerID = TOMSP OrderDate = 5/26/1997 12:00:00 AM Total = 240.10
OrderID = 10276 CustomerID = TORTU OrderDate = 8/8/1996 12:00:00 AM Total = 420.00
OrderID = 11069 CustomerID = TORTU OrderDate = 5/4/1998 12:00:00 AM Total = 360.00
OrderID = 10496 CustomerID = TRADH OrderDate = 4/4/1997 12:00:00 AM Total = 190.00
OrderID = 10822 CustomerID = TRAIH OrderDate = 1/8/1998 12:00:00 AM Total = 237.90
OrderID = 10602 CustomerID = VAFFE OrderDate = 7/17/1997 12:00:00 AM Total = 48.75
OrderID = 10334 CustomerID = VICTE OrderDate = 10/21/1996 12:00:00 AM Total = 144.80
OrderID = 10450 CustomerID = VICTE OrderDate = 2/19/1997 12:00:00 AM Total = 425.12
OrderID = 10478 CustomerID = VICTE OrderDate = 3/18/1997 12:00:00 AM Total = 471.20
OrderID = 10806 CustomerID = VICTE OrderDate = 12/31/1997 12:00:00 AM Total = 439.60
OrderID = 10843 CustomerID = VICTE OrderDate = 1/21/1998 12:00:00 AM Total = 159.00
OrderID = 10295 CustomerID = VINET OrderDate = 9/2/1996 12:00:00 AM Total = 121.60
OrderID = 10737 CustomerID = VINET OrderDate = 11/11/1997 12:00:00 AM Total = 139.80
OrderID = 10739 CustomerID = VINET OrderDate = 11/12/1997 12:00:00 AM Total = 240.00
OrderID = 10348 CustomerID = WANDK OrderDate = 11/7/1996 12:00:00 AM Total = 363.60
OrderID = 10651 CustomerID = WANDK OrderDate = 9/1/1997 12:00:00 AM Total = 397.80
OrderID = 10266 CustomerID = WARTH OrderDate = 7/26/1996 12:00:00 AM Total = 346.56
OrderID = 10412 CustomerID = WARTH OrderDate = 1/13/1997 12:00:00 AM Total = 334.80
OrderID = 10437 CustomerID = WARTH OrderDate = 2/5/1997 12:00:00 AM Total = 393.00
OrderID = 11025 CustomerID = WARTH OrderDate = 4/15/1998 12:00:00 AM Total = 270.00
OrderID = 10585 CustomerID = WELLI OrderDate = 7/1/1997 12:00:00 AM Total = 142.50
OrderID = 10809 CustomerID = WELLI OrderDate = 1/1/1998 12:00:00 AM Total = 140.00
OrderID = 10900 CustomerID = WELLI OrderDate = 2/20/1998 12:00:00 AM Total = 33.75
OrderID = 10905 CustomerID = WELLI OrderDate = 2/24/1998 12:00:00 AM Total = 342.00
OrderID = 10723 CustomerID = WHITC OrderDate = 10/30/1997 12:00:00 AM Total = 468.45
OrderID = 10248 CustomerID = WILMK OrderDate = 7/4/1996 12:00:00 AM Total = 440.00
OrderID = 10615 CustomerID = WILMK OrderDate = 7/30/1997 12:00:00 AM Total = 120.00
OrderID = 10673 CustomerID = WILMK OrderDate = 9/18/1997 12:00:00 AM Total = 412.35
OrderID = 10873 CustomerID = WILMK OrderDate = 2/6/1998 12:00:00 AM Total = 336.80
OrderID = 10910 CustomerID = WILMK OrderDate = 2/26/1998 12:00:00 AM Total = 452.90
OrderID = 10374 CustomerID = WOLZA OrderDate = 12/5/1996 12:00:00 AM Total = 459.00
OrderID = 10792 CustomerID = WOLZA OrderDate = 12/23/1997 12:00:00 AM Total = 399.85
OrderID = 10870 CustomerID = WOLZA OrderDate = 2/4/1998 12:00:00 AM Total = 160.00
OrderID = 10906 CustomerID = WOLZA OrderDate = 2/25/1998 12:00:00 AM Total = 427.50
