Theme: Oceanica/Start
|
UI (.aspx C#)
|
UI (.aspx VB)
|
Code Behind (C#)
|
Code Behind (VB)
|
Middle-Tier Base (C#)
|
Middle-Tier Base (VB)
|
Middle-Tier (C#)
|
Middle-Tier (VB)
|
Data-Tier Base (C#)
|
Data-Tier Base (VB)
|
Data-Tier (C#)
|
Data-Tier (VB)
SelectSkipAndTake SQL Script
|
GetRecordCount SQL Script
|
Select Totals SQL Script
|
Dynamic SQL Class (C#)
|
Dynamic SQL Class (VB)
Number of Records:
74
Product ID
Product Name
Supplier ID
Category ID
Quantity Per Unit
Unit Price
Units In Stock
Units On Order
Reorder Level
Discontinued
1
Chai
1
Supplier ID:
1
Company Name:
Exotic Liquids
Contact Name:
Charlotte Cooper
Contact Title:
Purchasing Manager
Address:
49 Gilbert St.
City:
London
Region:
Postal Code:
EC1 4SD
Country:
UK
Phone:
(171) 555-2222
Fax:
Home Page:
1
Category ID:
1
Category Name:
Beverages
Description:
Soft drinks, coffees, teas, beers, and ales changed
1020
$18.00
39
0
10
2
Chang
1
Supplier ID:
1
Company Name:
Exotic Liquids
Contact Name:
Charlotte Cooper
Contact Title:
Purchasing Manager
Address:
49 Gilbert St.
City:
London
Region:
Postal Code:
EC1 4SD
Country:
UK
Phone:
(171) 555-2222
Fax:
Home Page:
1
Category ID:
1
Category Name:
Beverages
Description:
Soft drinks, coffees, teas, beers, and ales changed
24 - 12 oz bottles
$19.00
17
40
26
3
Aniseed Syrup
1
Supplier ID:
1
Company Name:
Exotic Liquids
Contact Name:
Charlotte Cooper
Contact Title:
Purchasing Manager
Address:
49 Gilbert St.
City:
London
Region:
Postal Code:
EC1 4SD
Country:
UK
Phone:
(171) 555-2222
Fax:
Home Page:
2
Category ID:
2
Category Name:
Condiments
Description:
Sweet and savory sauces, relishes, spreads, and seasonings
12 - 550 ml bottles
$10.00
13
70
25
4
Chef Anton's Cajun Seasoning
2
Supplier ID:
2
Company Name:
New Orleans Cajun Delights
Contact Name:
Shelley Burke
Contact Title:
Order Administrator
Address:
P.O. Box 78934
City:
New Orleans
Region:
LA
Postal Code:
70117
Country:
USA
Phone:
(100) 555-4822
Fax:
Home Page:
#CAJUN.HTM#
2
Category ID:
2
Category Name:
Condiments
Description:
Sweet and savory sauces, relishes, spreads, and seasonings
48 - 6 oz jars
$22.00
53
0
0
5
Chef Anton's Gumbo Mix
2
Supplier ID:
2
Company Name:
New Orleans Cajun Delights
Contact Name:
Shelley Burke
Contact Title:
Order Administrator
Address:
P.O. Box 78934
City:
New Orleans
Region:
LA
Postal Code:
70117
Country:
USA
Phone:
(100) 555-4822
Fax:
Home Page:
#CAJUN.HTM#
2
Category ID:
2
Category Name:
Condiments
Description:
Sweet and savory sauces, relishes, spreads, and seasonings
36 boxes
$21.35
0
0
0
6
Grandma's Boysenberry Spread
3
Supplier ID:
3
Company Name:
Grandma Kelly's Homestead
Contact Name:
Regina Murphy
Contact Title:
Sales Representative
Address:
707 Oxford Rd.
City:
Ann Arbor
Region:
MI
Postal Code:
48104
Country:
USA
Phone:
(313) 555-5735
Fax:
(313) 555-3349
Home Page:
2
Category ID:
2
Category Name:
Condiments
Description:
Sweet and savory sauces, relishes, spreads, and seasonings
12 - 8 oz jars
$25.00
120
0
25
7
Uncle Bob's Organic Dried Pears
3
Supplier ID:
3
Company Name:
Grandma Kelly's Homestead
Contact Name:
Regina Murphy
Contact Title:
Sales Representative
Address:
707 Oxford Rd.
City:
Ann Arbor
Region:
MI
Postal Code:
48104
Country:
USA
Phone:
(313) 555-5735
Fax:
(313) 555-3349
Home Page:
7
Category ID:
7
Category Name:
Produce
Description:
Dried fruit and bean curd
12 - 1 lb pkgs.
$30.00
15
0
10
8
Northwoods Cranberry Sauce
3
Supplier ID:
3
Company Name:
Grandma Kelly's Homestead
Contact Name:
Regina Murphy
Contact Title:
Sales Representative
Address:
707 Oxford Rd.
City:
Ann Arbor
Region:
MI
Postal Code:
48104
Country:
USA
Phone:
(313) 555-5735
Fax:
(313) 555-3349
Home Page:
2
Category ID:
2
Category Name:
Condiments
Description:
Sweet and savory sauces, relishes, spreads, and seasonings
12 - 12 oz jars
$40.00
6
0
0
9
Mishi Kobe Niku
4
Supplier ID:
4
Company Name:
Tokyo Traders
Contact Name:
Yoshi Nagase
Contact Title:
Marketing Manager
Address:
9-8 Sekimai Musashino-shi
City:
Tokyo
Region:
Postal Code:
100
Country:
Japan
Phone:
(03) 3555-5011
Fax:
Home Page:
6
Category ID:
6
Category Name:
Meat/Poultry
Description:
Prepared meats
18 - 500 g pkgs.
$97.00
29
0
0
10
Ikura
4
Supplier ID:
4
Company Name:
Tokyo Traders
Contact Name:
Yoshi Nagase
Contact Title:
Marketing Manager
Address:
9-8 Sekimai Musashino-shi
City:
Tokyo
Region:
Postal Code:
100
Country:
Japan
Phone:
(03) 3555-5011
Fax:
Home Page:
8
Category ID:
8
Category Name:
Seafood
Description:
Seaweed and fish
12 - 200 ml jars
$31.00
31
0
0
11
Queso Cabrales
5
Supplier ID:
5
Company Name:
Cooperativa de Quesos 'Las Cabras'
Contact Name:
Antonio del Valle Saavedra
Contact Title:
Export Administrator
Address:
Calle del Rosal 4
City:
Oviedo
Region:
Asturias
Postal Code:
33007
Country:
Spain
Phone:
(98) 598 76 54
Fax:
Home Page:
4
Category ID:
4
Category Name:
Dairy Products
Description:
Cheeses
1 kg pkg.
$21.00
22
30
30
12
Queso Manchego La Pastora
5
Supplier ID:
5
Company Name:
Cooperativa de Quesos 'Las Cabras'
Contact Name:
Antonio del Valle Saavedra
Contact Title:
Export Administrator
Address:
Calle del Rosal 4
City:
Oviedo
Region:
Asturias
Postal Code:
33007
Country:
Spain
Phone:
(98) 598 76 54
Fax:
Home Page:
4
Category ID:
4
Category Name:
Dairy Products
Description:
Cheeses
10 - 500 g pkgs.
$38.00
86
0
0
13
Konbu
6
Supplier ID:
6
Company Name:
Mayumi's
Contact Name:
Mayumi Ohno
Contact Title:
Marketing Representative
Address:
92 Setsuko Chuo-ku
City:
Osaka
Region:
Postal Code:
545
Country:
Japan
Phone:
(06) 431-7877
Fax:
Home Page:
Mayumi's (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm#
8
Category ID:
8
Category Name:
Seafood
Description:
Seaweed and fish
2 kg box
$6.00
24
0
5
14
Tofu
6
Supplier ID:
6
Company Name:
Mayumi's
Contact Name:
Mayumi Ohno
Contact Title:
Marketing Representative
Address:
92 Setsuko Chuo-ku
City:
Osaka
Region:
Postal Code:
545
Country:
Japan
Phone:
(06) 431-7877
Fax:
Home Page:
Mayumi's (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm#
7
Category ID:
7
Category Name:
Produce
Description:
Dried fruit and bean curd
40 - 100 g pkgs.
$23.25
35
0
0
15
Genen Shouyu
6
Supplier ID:
6
Company Name:
Mayumi's
Contact Name:
Mayumi Ohno
Contact Title:
Marketing Representative
Address:
92 Setsuko Chuo-ku
City:
Osaka
Region:
Postal Code:
545
Country:
Japan
Phone:
(06) 431-7877
Fax:
Home Page:
Mayumi's (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm#
2
Category ID:
2
Category Name:
Condiments
Description:
Sweet and savory sauces, relishes, spreads, and seasonings
24 - 250 ml bottles
$15.50
39
0
5
16
Pavlova
7
Supplier ID:
7
Company Name:
Pavlova, Ltd.
Contact Name:
Ian Devling
Contact Title:
Marketing Manager
Address:
74 Rose St. Moonie Ponds
City:
Melbourne
Region:
Victoria
Postal Code:
3058
Country:
Australia
Phone:
(03) 444-2343
Fax:
(03) 444-6588
Home Page:
3
Category ID:
3
Category Name:
Confections
Description:
Desserts, candies, and sweet breads
32 - 500 g boxes
$17.45
29
0
10
Subtotal: $434.55
Grand Total: $2,158.46
1
2
3
4
5
Processing your request. Please wait....