读书人

未在本土计算机上注册VFPOLEDB提供程序

发布时间: 2013-09-06 10:17:17 作者: rapoo

未在本地计算机上注册VFPOLEDB提供程序。
如题。。。。

  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);


[解决办法]

引用:
自己回答下 下载了个vfp搞定。


怎么搞定的,能讲一下吗?

谢谢啦

读书人网 >C#

热点推荐