void view2(List <object[]> hash, out List <Dictionary <string, object> > list, string tablename) { sqlconnect.sqlconnect conn; using (TransactionScope ts = new TransactionScope()) { conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed"); list = conn.view2(tablename, hash); conn.close_dbConnection(); ts.Complete(); } }
internal void deletefromdb(Hashtable hash, string tablename) { sqlconnect.sqlconnect conn; using (TransactionScope ts = new TransactionScope()) { conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed"); conn.delete(tablename, hash); conn.close_dbConnection(); ts.Complete(); } }
internal int GetCountdb(Hashtable hash, string tablename) { sqlconnect.sqlconnect conn; int count = 0; using (TransactionScope ts = new TransactionScope()) { conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed"); count = conn.Count(tablename, hash); conn.close_dbConnection(); ts.Complete(); } return count; }
internal int GetCountdb(Hashtable hash, string tablename) { sqlconnect.sqlconnect conn; int count = 0; using (TransactionScope ts = new TransactionScope()) { conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed"); count = conn.Count(tablename, hash); conn.close_dbConnection(); ts.Complete(); } return(count); }
internal void insertbulk(Hashtable[] hash, string tablename) { if (this.InvokeRequired) { deg_insertbulk bulk = new deg_insertbulk(insertbulk); this.Invoke(bulk, new object[] { hash, tablename }); } else { sqlconnect.sqlconnect conn; using (TransactionScope ts = new TransactionScope()) { conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed"); conn.insertBulk(tablename, hash); conn.close_dbConnection(); ts.Complete(); } } }
internal void insertbulk(Hashtable[] hash, string tablename) { if (this.InvokeRequired) { deg_insertbulk bulk = new deg_insertbulk(insertbulk); this.Invoke(bulk,new object[]{hash,tablename}); } else { sqlconnect.sqlconnect conn; using (TransactionScope ts = new TransactionScope()) { conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed"); conn.insertBulk(tablename, hash); conn.close_dbConnection(); ts.Complete(); } } }
void view2(List<object[]> hash, out List<Dictionary<string, object>> list, string tablename) { sqlconnect.sqlconnect conn; using (TransactionScope ts = new TransactionScope()) { conn = new sqlconnect.sqlconnect("data.sqlite", "Ie3Cdks0388Csed"); list = conn.view2(tablename, hash); conn.close_dbConnection(); ts.Complete(); } }