日期:2014-05-17 浏览次数:20985 次
string tempfile = _dbfmc;
_fileName = _serverpath + @"Temp\" + tempfile + ".dbf";
File.Copy(_serverpath + _templetFile, _fileName, true);
string strConn = @"Provider=VFPOLEDB;Data Source=" + _serverpath + @"Temp\" + ";Collating Sequence=MACHINE";
string sql = "";
if (_fields != null && _fields != string.Empty)
sql = "Select " + _fields + " From [" + tempfile + "]";
else
sql = "Select * From [" + tempfile + "]";
OleDbDataAdapter adpt = new OleDbDataAdapter(sql, strConn);
OleDbCommandBuilder bd = new OleDbCommandBuilder(adpt);
bd.QuotePrefix = "[";
bd.QuoteSuffix = "]";
DataSet mySet = new DataSet();
adpt.Fill(mySet, tempfile);//执行到这里就出错了
mySet.Tables[0].Rows.Clear();
MoveBatch(_dataSource, mySet.Tables[0]);
adpt.Update(mySet, tempfile);