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);