protected string GetStorefront() { string sql = "Select * from Products WHERE deleted=0 order by Title"; sql = "Select * from Products where deleted=0 Order by Title"; DataTable dt = gData.GetDataTable2(sql); string html = "<table><tr>"; int iTD = 0; for (int y = 0; y < dt.Rows.Count; y++) { string div = ZincOps.GetAmazonItem(dt.Rows[y], false); html += div + "\r\n"; iTD++; if (iTD == 3) { iTD = 0; html += "</tr><tr>"; } } // Check for quizzes html += "</table>"; return(html); }
public string GetAmzItem(bool fBuying) { string sID = Request.QueryString["buyid"].ToNonNullString(); string sql = "Select * from Products Where id='" + BMS.PurifySQL(sID, 200) + "' and deleted=0"; DataTable dt = gData.GetDataTable2(sql); if (dt.Rows.Count < 1) { return(""); } string div = ZincOps.GetAmazonItem(dt.Rows[0], fBuying); return(div); }