UpdateData(true);
int i;
CString  control,tablename,filename;
CDatabase db;
db.OpenEx(_T("DSN="+m_linkname+";UID="+m_username+";PWD="+m_password+";"));
for(i=m_daystart;i<m_daystart+m_daycount;i++)
{
control="";
control.Format("%d",i);
tablename=m_tablehead+control;
filename=m_filehead+control+".txt";
control="控制文件"+control+".ctl";
db.ExecuteSQL("begin "+m_procedurename+"('"+tablename+"');end;");
ofstream jfrk(control,ios::out);  
jfrk<<"load data"<<endl;
jfrk<<"infile 'd:\\mytest2\\"<<filename<<"'"<<endl;    
jfrk<<"into table "<<tablename<<endl;
jfrk<<"fields terminated by '\\t' optionally enclosed by '"<<'"'<<"'"<<endl;
jfrk<<"("<<m_struct<<")"<<endl;
jfrk.close;
ShellExecute(NULL,"open", "sqlldr.exe","userid="+m_username+"/"+m_password+"@"+m_databasename+" skip=1 control=d:\\mytest2\\"+control,NULL,SW_HIDE);
}
db.Close();
AfxMessageBox("已经完成");