string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
     Application.StartupPath + ";Extended Properties=dBase III;";

ADODB.Connection connection = new ADODB.ConnectionClass();
connection.Open(connectionString,  null, null,  0 );
connection.CursorLocation = ADODB.CursorLocationEnum.adUseServer;
ADODB.Recordset rs = new ADODB.RecordsetClass();
rs.Open("Tbl.dbf", connection, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic,  0 );

connection.BeginTrans();
try
{
    for (int i =  0 ; i <  10 ; i++)
    {
        // Генерируем ошибку
        if (i ==  5 )
            throw new DivideByZeroException(); ;

        rs.AddNew("QQQ", i);
        rs.Update("fff", i);
    }

    connection.CommitTrans();

}
catch
{
    connection.RollbackTrans();
    rs.CancelBatch(ADODB.AffectEnum.adAffectCurrent);
}
connection.Close();

"Provider=MSDASQL/SQLServer ODBC;Driver={Microsoft Visual FoxPro Driver};" +
"SourceType=DBF;SourceDB=C:\Temp;InternetTimeout=300000;Transact Updates=True";