用C#对DBF数据库的操作

        conn.ConnectionString = connStr;
        conn.Open();
       

        OdbcCommand cmd = new OdbcCommand();
        cmd.Connection = conn;
        string sql = "update " + table + " set other='2',rate=1.014 ";
        cmd.CommandText = sql;
        cmd.CommandType = CommandType.Text;
        cmd.ExecuteNonQuery();

         sql = @"select * from " + table;
        OdbcDataAdapter da = new OdbcDataAdapter(sql,conn);
        DataTable dt = new DataTable();
        da.Fill(dt);
        this.GridView1.DataSource = dt.DefaultView;
        this.GridView1.DataBind();

    }
注意点：1 连接串的格式。2 所对应的表名必须要有路径。