dataset - 使用 VFPOLEDB 驱动程序读取 DBF

Question

我正在使用 VFPOLEDB 驱动程序读取 DBF 文件，但我不断收到此错误，我不确定为什么以及如何解决此问题:

The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value.

这是代码。我调用此例程以返回 DBF 文件的 DataSet 并在 DataGridView 中显示数据。

public DataSet GetDBFData(FileInfo fi, string tbl)
{
    using (OleDbConnection conn = new OleDbConnection(
    @"Provider=VFPOLEDB.1;Data Source=" + fi.DirectoryName + ";"))
    {
        conn.Open();
        string command = "SELECT * FROM " + tbl;
        OleDbDataAdapter da = new OleDbDataAdapter(command, conn);
        DataSet ds = new DataSet();
        da.Fill(ds);
        return ds;
    }
}

Answer 1

我在这里找到了解决方案:
Error reading certain numeric values with VFPOLEDB driver

SELECT CAST(FieldName As NUMERIC(11, 3)) From TableName