//public SqlDataReader getItemInfo() {
// string sql =
// "select "
// + "Products.PID,Products.CategoryID,Products.Name,"
// + "Category.CID,Category.CName,"
// + "Items.IID,Items.ProductID,Items.BrandID,Items.Name,"
// + "Brand.BID,Brand.BrandName "
// + "from Category,Items,Products,Brand "
// + "where "
// + "Products.CategoryID=Category.CID and "
// + "Products.PID=Items.ProductID and "
// + "Items.BrandID=Brand.BID"
// +"" ;
// return helper.GetDataReader(sql);
//}
#endregion
//Items:IID,ProductID,BrandID,Name
//Products:PID,CategoryID,Name
//Category:CID,CName
//Brand:BID,BrandName
public SqlDataReader getItemSimpleInfo()
{
string sql =
"select distinct "
+ "Items.IID,Items.ProductID,Items.Name,"
+ "Products.PID,Products.CategoryID,Products.Name,"
+ "Category.CID,Category.CName "
+ "from Category,Items,Products,Brand "
+ "where "
+ "Products.CategoryID=Category.CID and "
+ "Products.PID=Items.ProductID";
return(helper.GetDataReader(sql));
}
