C#
1
2
3
4
5
6
7
8
9
10
11
12
NorthwindTableAdapters.ProductsTableAdapter
productsAdapter =
new NorthwindTableAdapters.ProductsTableAdapter();
// For each product, double its price if it is not discontinued
and
// there are 25 items in stock or less
Northwind.ProductsDataTable products = productsAdapter.GetProducts();
foreach (Northwind.ProductsRow product in products)
if (!product.Discontinued && product.UnitsInStock
<= 25)
product.UnitPrice *= 2;
// Update the products
productsAdapter.Update(products);
C#
1
2
3
4
5
6
7
8
9
10
11
12
NorthwindTableAdapters.ProductsTableAdapter
productsAdapter = new
NorthwindTableAdapters.ProductsTableAdapter();
// Delete the product with ProductID 3
productsAdapter.Delete(3);
// Update Chai (ProductID of 1), setting the UnitsOnOrder to
15
productsAdapter.Update("Chai", 1, 1, "10 boxes x 20 bags",
18.0m, 39, 15, 10, false, 1);
// Add a new product
productsAdapter.Insert("New Product", 1, 1,
"12 tins per carton", 14.95m, 15, 0, 10, false);
C#
1
2
3
4
5
6
7
NorthwindTableAdapters.ProductsTableAdapter
productsAdapter = new
NorthwindTableAdapters.ProductsTableAdapter();
// Add a new product
int new_productID =
Convert.ToInt32(productsAdapter.InsertProduct("New
Product", 1, 1, "12 tins per carton",
14.95m, 10, 0, 10, false));
// On second thought, delete the product
productsAdapter.Delete(new_productID);