AbleCommerce Shopping Cart Software

Code: Select all

public class data
{   

    public string sConnect;
    public data()
    {
        string sPhysicalPath = HttpContext.Current.Server.MapPath("~/thedb");
        sConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + sPhysicalPath + "\\mydb.mdb; User Id=; Password=";
    }
    public DataSet getDataSet(string sSQL)
    {
        DataSet dsTemp = new DataSet();
        try
        {
            using (OleDbDataAdapter daTemp = new OleDbDataAdapter(sSQL, sConnect))
            {
                daTemp.Fill(dsTemp);
            }
        }
        catch (OleDbException e)
        {
            ClassError(e, sSQL);
        }
        return dsTemp;
    }
    public DataTable getDataTable(string sSQL)
    {
        DataTable dtTemp = new DataTable();
        try
        {
            using (OleDbDataAdapter daTemp = new OleDbDataAdapter(sSQL, sConnect))
            {
                daTemp.Fill(dtTemp);
            }
        }
        catch (OleDbException e)
        {
            ClassError(e, sSQL);

        }
        return dtTemp;
    }
    public string cleanSQL(string sText, string sType)
    {
        Int32 iOut;
        switch (sType.ToLower())
        {
            case "n":
                Int32.TryParse(sText, out iOut);
                return iOut.ToString();
            case "a":
                sText.Replace(")", " ");
                sText.Replace("(", " ");
                sText.Replace("--", " ");
                sText.Replace("==", " ");
                sText.Replace(";", " ");
                sText.Replace("%", " ");
                sText.Replace("'", "''");
                return sText;
            default:
                return "";
        }
    }
    public bool executeNonQuery(string sSQL)
    {
        bool bRan = true;
        try
        {
            using (OleDbConnection oCon = new OleDbConnection(sConnect))
            {
                oCon.Open();
                try
                {
                    using (OleDbCommand oCmd = new OleDbCommand())
                    {
                        oCmd.Connection = oCon;
                        oCmd.CommandText = sSQL;
                        oCmd.ExecuteNonQuery();
                    }
                }
                catch (OleDbException e)
                {
                    bRan = false;
                    ClassError(e, sSQL);
                }
                finally
                {
                    oCon.Close();
                }
            }
        }
        catch (OleDbException e)
        {
            bRan = false;
            ClassError(e, sSQL);

        }
        finally
        {

        }
        return bRan;
    }
    protected void ClassError(Exception ex, string sSQL)
    {
        string sBody = "MESSAGE: " + ex.Message +
          "\nSOURCE: " + ex.Source +
          "\nTARGETSITE: " + ex.TargetSite +
          "\nSTACKTRACE: " + ex.StackTrace +
          "\nSQL String: " + sSQL +
          "\nConnection: " + sConnect;

        error.logError(sBody);
    }
}

Code: Select all

ProductDataSource.LoadforCriteria("SKU LIKE Joe* AND (Instock > 0 OR VendorId=4)")