62,046
社区成员
发帖
与我相关
我的任务
分享
private void CreateData()
{
string tempfile=GetRandomFileName();
_fileName=_serverpath+@"Temp\"+tempfile+".dbf";
File.Copy(_serverpath+_templetFile,_fileName,true);
string strConn=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+_serverpath+@"Temp\"+";Extended Properties=dBASE 5.0";
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);
MoveBatch(_dataSource,mySet.Tables[0]);//批量导出数据
adpt.Update(mySet,tempfile);
}