c#操作DBF数据库
conn = new OdbcConnection();
filepath = System.IO.Directory.GetCurrentDirectory();
string connStr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + filepath + ";Exclusive=yes;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=no";
conn.ConnectionString = connStr;
conn.Open();
string sql = @"select * from " + filepath + "\\WATER.dbf";
OdbcDataAdapter da = new OdbcDataAdapter(sql, conn);
System.Data.DataTable dtt = new System.Data.DataTable();
da.Fill(dtt);
DataRow row = dtt.NewRow();
row[0] = dt.Rows[i][0].ToString();
dtt.Rows.Add(row);
OdbcCommandBuilder en = new OdbcCommandBuilder(da);
da.Update(dtt); //这里更新出错,提示:file .dbf does not
但文件命名存在,不知道是什么原因啊