Loading

How to delete data permanently in DBF file ?

Deepak M

OleDbConnection oleDbConnection = new OleDbConnection("Provider=VFPOLEDB.1;Data Source=" + filePath + ";");
oleDbConnection.Open();
string sql = "Delete From CLIENTS";
OleDbCommand oleDbCommand = new OleDbCommand(sql, oleDbConnection);
oleDbCommand.ExecuteNonQuery();
oleDbConnection.Close();

When I use the above code it will delete all the records but not permanently. All the records are present physically in the DBF file. So how to delete all data parmanemtly ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty6y ago
Accepted answer
Hey try the below code.
OleDbConnection oleDbConnection = new OleDbConnection("Provider=VFPOLEDB.1;Data Source=" + filePath + ";");
oleDbConnection.Open();
string sql = @"SET EXCLUSIVE ON
                DELETE FROM CLIENTS
                PACK";
OleDbCommand cmd = new OleDbCommand(sql, oleDbConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "ExecScript";
cmd.Parameters.Add("myScript", OleDbType.Char).Value = sql;
cmd.ExecuteNonQuery();
oleDbConnection.Close();
Deepak M6y ago
Thank you Amit Sir.