Theme: Colorful/Sunny
|
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
|
Delete SQL Script
|
Insert SQL Script
|
Update SQL Script
|
Categories SelectDropDownListData Script
|
Suppliers SelectDropDownListData Script
|
Dynamic SQL Class (C#)
|
Dynamic SQL Class (VB)
Add New Products
Add New Products
Product ID:
Product Name:
*
Supplier ID:
Select One
Aux joyeux ecclésiastiques
Bigfoot Breweries
Cooperativa de Quesos 'Las Cabras'
Escargots Nouveaux
Exotic Liquids
Forêts d'érables
Formaggi Fortini s.r.l.
Gai pâturage
G'day, Mate
Grandma Kelly's Homestead
Heli Süßwaren GmbH & Co. KG
Karkki Oy
Leka Trading
Lyngbysild
Ma Maison
Mayumi's
New England Seafood Cannery
New Orleans Cajun Delights
Nord-Ost-Fisch Handelsgesellschaft mbH
Norske Meierier
Pasta Buttini s.r.l.
Pavlova, Ltd.
PB Knäckebröd AB
Plutzer Lebensmittelgroßmärkte AG
Refrescos Americanas LTDA
Specialty Biscuits, Ltd.
Svensk Sjöföda AB
Tokyo Traders
Zaanse Snoepfabriek
Category ID:
Select One
Beverages
Condiments
Confections
Dairy Products
Grains/Cereals
Meat/Poultry
Produce
Seafood
Quantity Per Unit:
Unit Price:
Units In Stock:
Units On Order:
Reorder Level:
Discontinued:
*
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
1
2
3
4
5
Processing your request. Please wait....