直接上代码

string table=@"D:/TURBOMA/madata/arnature.DBF";
string connStr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=D:/TURBOMA/madata/arnature.DBF;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO";
using (System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection(connStr))
    {
      conn.ConnectionString = connStr;
      conn.Open();
      OdbcCommand cmd = new OdbcCommand();
      cmd.Connection = conn;
      //查询
      string sql = @"select * from " + table;
      OdbcDataAdapter da = new OdbcDataAdapter(sql, conn);
      DataTable dt = new DataTable();
      da.Fill(dt);
      //修改
       sql = "update " + table + " set id='2',name='mo' ";
       cmd.CommandText = sql;
       cmd.CommandType = CommandType.Text;
       cmd.ExecuteNonQuery();
    }