public ProductCollection GetAllProducts()
{
string str = @"select ProductID, ProductName, SupplierID, CategoryID,
QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder,
ReorderLevel, Discontinued
from Products" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
ProductCollection cc = new ProductCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(ProductProc), cc);
cc.AcceptChanges();
return(cc);
}
public ProductCollection GetProductByProductId(int ProductId)
{
string str = @"select ProductID, ProductName, SupplierID, CategoryID,
QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder,
ReorderLevel, Discontinued
from Products where ProductId=@ProductId" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
cmd.Parameters.Add("@ProductId", SqlDbType.Int, 0, "ProductId");
cmd.Parameters[0].Value = ProductId;
ProductCollection cc = new ProductCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(ProductProc), cc);
cc.AcceptChanges();
return(cc);
}
