string []fieldNames = {"CustomerType", "Name", "Password", "Address", "ZipCode", "City",
 "Phone", "EMail", "PaymentRecord", "CreditAmount", "Balance"};
object [] values = {0 , "Hans", "goggle", "Baldersgade 123", "2200", "Copenhagen",
 "298120843", "007-is-his-iq@ofir.dk", 0, 5000.00m, 0.00m};
    //string []fieldNames = {"BookID", "Comment"};
    //object [] values = {3, "Fantastisk hvis det virker!"};
//IsInDB = myTool.Insert("Comments", fieldNames, values);
IsInDB = myTool.Insert("Customers", fieldNames, values);

public bool Insert(string table, string[] schema, params object[] fields)
{
    if (schema.Length != fields.Length)
    throw new ArgumentException("The number of fields does not match the size of the schema.");

    string query = "INSERT INTO " + table + " (";
    for (int i = 0; i < schema.Length; i++)
        {
            query += schema[i];
            if (i != schema.Length - 1)
                query += ", ";
        }
        query += ") VALUES (";
        for (int i = 0; i < fields.Length; i++)
        {
            query += Formatted(fields[i]);
            if (i != fields.Length -1)
                query += ", ";
        }
        query += ")";
            return this.ExplicitNonQuery(query);
    }

protected override string Formatted(object obj)
    {
        switch(Convert.ToString(obj.GetType()))
        {
            case "System.Int32":
                return ((int)obj).ToString();
            case "System.String":
                return "'" + (string)obj + "'";
            case "System.Byte":
                return ((byte)obj).ToString();
            case "System.Boolean":
                return (bool)obj ? "1" : "0";
            case "System.Decimal":
                return Convert.ToString(obj);
            case "System.Double":
                return Convert.ToString(obj);
            case "System.DBNull":
                return "NULL";            
            default:
                // There is an unhandled conversion
                throw new MyException("Total crab: " + obj.ToString() + "
 er af typen " + obj.GetType());
                return obj.ToString();
        }

public bool ExplicitNonQuery(string query)
    {
        if (query.Length > 0)
        {
            int RowsAffected;
            this.command.CommandText = query;
    /*        INSERT INTO Customers (CustomerType, Name, Password, Address, 
ZipCode, City, Phone, EMail, PaymentRecord, CreditAmount, Balance)
VALUES (0, 'Hans','fasd', 'engade 2', '2123', 'Hornbæk', '29800843',
 'jon_ronnenberg@hotmail.dk',0, 100, 0);
       */
    OleDbTransaction trans = onnection.BeginTransaction(IsolationLevel.ReadCommitted);
    this.command.Transaction = trans;
    try
        {                
        RowsAffected = this.command.ExecuteNonQuery();
        trans.Commit();
        return RowsAffected>0;
        }
        catch (Exception ex)
            {    
                try
                {
                    trans.Rollback();
                    throw new MyException(ex.Message, ex.Source);
                //    return false;
                }
                catch(OleDbException OleDbex)
                {
                throw new MyException(OleDbex.Message, OleDbex.InnerException);
                }
            }
        } 
        else 
        {
            throw new MyException("query is empty");
        }
    }