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();
}
