- DeleteConfirmation.zip
- DeleteConfirmation
- DeleteConfirmationCS
- DeleteInGridView
- App_Code
- BusinessObject
- BusinessObjectBase
- BusinessObjectCollection
- DataLayer
- DataLayerBase
- Example
- Helper
- App_Themes
- Theme1
- SkinFile.skin
- Images
- ActivityIndicator.gif
- Delete.png
- Spacer.gif
- JQueryThemes
- redmond
- images
- ui-bg_flat_0_aaaaaa_40x100.png
- ui-bg_flat_55_fbec88_40x100.png
- ui-bg_glass_75_d0e5f5_1x400.png
- ui-bg_glass_85_dfeffc_1x400.png
- ui-bg_glass_95_fef1ec_1x400.png
- ui-bg_gloss-wave_55_5c9ccc_500x100.png
- ui-bg_inset-hard_100_f5f8f9_1x100.png
- ui-bg_inset-hard_100_fcfdfd_1x100.png
- ui-icons_217bc0_256x240.png
- ui-icons_2e83ff_256x240.png
- ui-icons_469bdd_256x240.png
- ui-icons_6da8d5_256x240.png
- ui-icons_cd0a0a_256x240.png
- ui-icons_d8e7f3_256x240.png
- ui-icons_f9bd01_256x240.png
- jquery-ui-1.8.11.custom.css
- MasterPage.master
- MasterPage.master.cs
- Scripts
- Styles
- web.config
- Web_Products.aspx
- Web_Products.aspx.cs
- SQLScripts.sql
- DeleteConfirmationVB
- DeleteInGridViewVB
- App_Code
- BusinessObject
- BusinessObjectBase
- BusinessObjectCollection
- DataLayer
- DataLayerBase
- Example
- Helper
- App_Themes
- Theme1
- SkinFile.skin
- Images
- ActivityIndicator.gif
- Delete.png
- Spacer.gif
- JQueryThemes
- redmond
- images
- ui-bg_flat_0_aaaaaa_40x100.png
- ui-bg_flat_55_fbec88_40x100.png
- ui-bg_glass_75_d0e5f5_1x400.png
- ui-bg_glass_85_dfeffc_1x400.png
- ui-bg_glass_95_fef1ec_1x400.png
- ui-bg_gloss-wave_55_5c9ccc_500x100.png
- ui-bg_inset-hard_100_f5f8f9_1x100.png
- ui-bg_inset-hard_100_fcfdfd_1x100.png
- ui-icons_217bc0_256x240.png
- ui-icons_2e83ff_256x240.png
- ui-icons_469bdd_256x240.png
- ui-icons_6da8d5_256x240.png
- ui-icons_cd0a0a_256x240.png
- ui-icons_d8e7f3_256x240.png
- ui-icons_f9bd01_256x240.png
- jquery-ui-1.8.11.custom.css
- MasterPage.master
- MasterPage.master.vb
- Scripts
- Styles
- web.config
- Web_Products.aspx
- Web_Products.aspx.vb
- SQLScripts.sql
|
using System;
using Northwind.BusinessObject;
using System.Web.UI.WebControls;
// using System.Windows.Forms; // Note: remove comment when using with windows forms
/// <summary>
/// These are data-centric code examples for the Products table.
/// You can cut and paste the respective codes into your application
/// by changing the sample values assigned from these examples.
/// NOTE: This class contains private methods because they're
/// not meant to be called by an outside client. Each method contains
/// code for the respective example being shown
/// </summary>
public sealed class ProductsExample
{
private ProductsExample()
{
}
private void SelectAll()
{
// select all records
ProductsCollection objProductsCol = Products.SelectAll();
// Example 1: you can optionally sort the collection in ascending order by your chosen field
objProductsCol.Sort(Products.ByProductName);
// Example 2: to sort in descending order, add this line to the Sort code in Example 1
objProductsCol.Reverse();
// Example 3: directly bind to a GridView
GridView grid = new GridView();
grid.DataSource = objProductsCol;
grid.DataBind();
// Example 4: loop through all the Products(s)
foreach (Products objProducts in objProductsCol)
{
int productID = objProducts.ProductID;
string productName = objProducts.ProductName;
int? supplierID = objProducts.SupplierID;
int? categoryID = objProducts.CategoryID;
string quantityPerUnit = objProducts.QuantityPerUnit;
decimal? unitPrice = objProducts.UnitPrice;
Int16? unitsInStock = objProducts.UnitsInStock;
Int16? unitsOnOrder = objProducts.UnitsOnOrder;
Int16? reorderLevel = objProducts.ReorderLevel;
bool discontinued = objProducts.Discontinued;
}
}
private void SelectByPrimaryKey()
{
// select a record by primary key(s)
Products objProducts = Products.SelectByPrimaryKey(1);
if (objProducts != null)
{
// if record is found, a record is returned
int productID = objProducts.ProductID;
string productName = objProducts.ProductName;
int? supplierID = objProducts.SupplierID;
int? categoryID = objProducts.CategoryID;
string quantityPerUnit = objProducts.QuantityPerUnit;
decimal? unitPrice = objProducts.UnitPrice;
Int16? unitsInStock = objProducts.UnitsInStock;
Int16? unitsOnOrder = objProducts.UnitsOnOrder;
Int16? reorderLevel = objProducts.ReorderLevel;
bool discontinued = objProducts.Discontinued;
}
}
/// <summary>
/// Select all records by Suppliers, related to column SupplierID
/// </summary>
private void SelectProductsCollectionBySuppliers()
{
ProductsCollection objProductsCol = Products.SelectProductsCollectionBySuppliers(1);
// Example 1: you can optionally sort the collection in ascending order by your chosen field
objProductsCol.Sort(Products.ByProductName);
// Example 2: to sort in descending order, add this line to the Sort code in Example 1
objProductsCol.Reverse();
// Example 3: directly bind to a GridView
GridView grid = new GridView();
grid.DataSource = objProductsCol;
grid.DataBind();
// Example 4: loop through all the Products(s)
foreach (Products objProducts in objProductsCol)
{
int productID = objProducts.ProductID;
string productName = objProducts.ProductName;
int? supplierID = objProducts.SupplierID;
int? categoryID = objProducts.CategoryID;
string quantityPerUnit = objProducts.QuantityPerUnit;
decimal? unitPrice = objProducts.UnitPrice;
Int16? unitsInStock = objProducts.UnitsInStock;
Int16? unitsOnOrder = objProducts.UnitsOnOrder;
Int16? reorderLevel = objProducts.ReorderLevel;
bool discontinued = objProducts.Discontinued;
}
}
/// <summary>
/// Select all records by Categories, related to column CategoryID
/// </summary>
private void SelectProductsCollectionByCategories()
{
ProductsCollection objProductsCol = Products.SelectProductsCollectionByCategories(1);
// Example 1: you can optionally sort the collection in ascending order by your chosen field
objProductsCol.Sort(Products.ByProductName);
// Example 2: to sort in descending order, add this line to the Sort code in Example 1
objProductsCol.Reverse();
// Example 3: directly bind to a GridView
GridView grid = new GridView();
grid.DataSource = objProductsCol;
grid.DataBind();
// Example 4: loop through all the Products(s)
foreach (Products objProducts in objProductsCol)
{
int productID = objProducts.ProductID;
string productName = objProducts.ProductName;
int? supplierID = objProducts.SupplierID;
int? categoryID = objProducts.CategoryID;
string quantityPerUnit = objProducts.QuantityPerUnit;
decimal? unitPrice = objProducts.UnitPrice;
Int16? unitsInStock = objProducts.UnitsInStock;
Int16? unitsOnOrder = objProducts.UnitsOnOrder;
Int16? reorderLevel = objProducts.ReorderLevel;
bool discontinued = objProducts.Discontinued;
}
}
/// <summary>
/// Selects ProductID and ProductName columns for use with a with a Drop Down List, Combo Box, Checked Box List, List View, List Box, etc
/// </summary>
private void SelectProductsDropDownListData()
{
ProductsCollection objProductsCol = Products.SelectProductsDropDownListData();
// Example 1: directly bind to a drop down list
DropDownList ddl1 = new DropDownList();
ddl1.DataValueField = "ProductID";
ddl1.DataTextField = "ProductName";
ddl1.DataSource = objProductsCol;
ddl1.DataBind();
// Example 2: add each item through a loop
DropDownList ddl2 = new DropDownList();
foreach (Products objProducts in objProductsCol)
{
ddl2.Items.Add(new ListItem(objProducts.ProductName, objProducts.ProductID.ToString()));
}
// Example 3: bind to a combo box. Note: remove comment when using with windows forms
// ComboBox cbx1 = new ComboBox();
// foreach (Products objProducts in objProductsCol)
// {
// cbx1.Items.Add(new ListItem(objProducts.ProductName, objProducts.ProductID.ToString()));
// }
}
private void Insert()
{
// first instantiate a new Products
Products objProducts = new Products();
// assign values you want inserted
objProducts.ProductName = "Chai";
objProducts.SupplierID = 1;
objProducts.CategoryID = 1;
objProducts.QuantityPerUnit = "10 boxes x 20 bags";
objProducts.UnitPrice = Convert.ToDecimal(18.0000);
objProducts.UnitsInStock = 39;
objProducts.UnitsOnOrder = 0;
objProducts.ReorderLevel = 10;
objProducts.Discontinued = false;
// finally, insert a new record
// the insert method returns the newly created primary key
int newlyCreatedPrimaryKey = objProducts.Insert();
}
private void Update()
{
// first instantiate a new Products
Products objProducts = new Products();
// assign the existing primary key(s)
// of the record you want updated
objProducts.ProductID = 1;
// assign values you want updated
objProducts.ProductName = "Chai";
objProducts.SupplierID = 1;
objProducts.CategoryID = 1;
objProducts.QuantityPerUnit = "10 boxes x 20 bags";
objProducts.UnitPrice = Convert.ToDecimal(18.0000);
objProducts.UnitsInStock = 39;
objProducts.UnitsOnOrder = 0;
objProducts.ReorderLevel = 10;
objProducts.Discontinued = false;
// finally, update an existing record
objProducts.Update();
}
private void Delete()
{
// delete a record by primary key
Products.Delete(78);
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.