Example #1
0
 private void InsertOrders()
 {
     for (int i = 0; i < 100; i++)
     {
         insertIDAt++;
         using (QuickData Query = new QuickData())
         {
             QDInserter ins = new QDInserter("WFInstances");
             ins.insert("InstanceKey", "P" + insertIDAt.ToString(), Types.String);
             ins.insert("Status", "pending", Types.String);
             ins.insert("WFType", "P", Types.String);
             Query.insert(ins);
         }
     }
     Console.WriteLine("Orders Inserted");
 }
Example #2
0
        public void insert(QDInserter ins)
        {
            string sql    = "INSERT INTO " + ins.tableName + " ";
            string fields = "(";
            string values = "(";

            foreach (DictionaryEntry d in ins.ht)
            {
                fields += d.Key + ",";
                values += d.Value + ",";
            }
            fields           = fields.TrimEnd(',') + ")";
            values           = values.TrimEnd(',') + ")";
            sql             += fields + " VALUES " + values;
            ins.lastInsertID = insert(sql);
        }
Example #3
0
 private void InsertOrders()
 {
     for (int i = 0; i < 100; i++)
     {
         insertIDAt++;
         using (QuickData Query = new QuickData())
         {
             QDInserter ins = new QDInserter("WFInstances");
             ins.insert("InstanceKey", "P" + insertIDAt.ToString(), Types.String);
             ins.insert("Status", "pending", Types.String);
             ins.insert("WFType", "P", Types.String);
             Query.insert(ins);
         }
     }
     Console.WriteLine("Orders Inserted");
 }