Deepak M

Deepak M

  • 1.1k
  • 522
  • 32.8k

How to delete data permanently in DBF file ?

Jan 6 2020 12:28 AM
  1. OleDbConnection oleDbConnection = new OleDbConnection("Provider=VFPOLEDB.1;Data Source=" + filePath + ";");  
  2. oleDbConnection.Open();  
  3. string sql = "Delete From CLIENTS";  
  4. OleDbCommand oleDbCommand = new OleDbCommand(sql, oleDbConnection);  
  5. oleDbCommand.ExecuteNonQuery();  
  6. 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 ?

Answers (2)