public static void updateAndAddTransaction() { IDbAccess db = IDbFactory.CreateIDb(connStr, dbType); try { db.IsTran = true; db.BeginTransaction(); //add string tableName = "templjqfortest"; Hashtable ht = new Hashtable(); ht.Add("name", "hello db11"); ht.Add("createtime", new DateTime(2011, 2, 1, 2, 2, 2, 11)); ht.Add("supertiem", null); Console.WriteLine("" + db.AddData(tableName, ht)); //delete string filterStr = "and name >='hello db7'"; Console.WriteLine("delete is " + db.DeleteRow(tableName, filterStr)); db.Commit(); } catch (Exception e) { db.Rollback(); db.Close(); } }
public static void GetDataReader() { IDbAccess db = IDbFactory.CreateIDb(connStr, dbType); db.IsKeepConnect = true; IDataReader datareader = db.GetDataReader("select * from templjqfortest"); while (datareader.Read()) { Console.WriteLine(datareader.GetValue(0).ToString()); Console.WriteLine(datareader.GetValue(1).ToString()); } datareader.Dispose(); db.Close(); }