public StoredProcedure SalesByCategory(string CategoryName,string OrdYear){
StoredProcedure sp=new StoredProcedure("SalesByCategory",this.Provider);
sp.Command.AddParameter("CategoryName",CategoryName,DbType.String);
sp.Command.AddParameter("OrdYear",OrdYear,DbType.String);
return sp;
}
public StoredProcedure TenMostExpensiveProducts(){