txtinput.cpp

因本人实际工作的需要

void COneDlg::OnButton2()   //----------------txt数据存入数据库------------
{
	CFile f;
	CString  FilePathName;
	CFileException e;	
	CFileDialog dlg(TRUE,NULL,NULL,0,"txt Files (*.txt)|*.txt||",this);///TRUE为OPEN对话框，FALSE为SAVE AS对话框
	if(dlg.DoModal()==IDOK)
	{
		FilePathName=dlg.GetPathName();			
		if(f.Open(FilePathName, CFile::modeRead | CFile::typeBinary, &e)) //打开了一个txt文件
		{				
			int nSize = f.GetLength();          //先得到txt文件长度
			BYTE * pBuffer = new BYTE [nSize];  //按文件的大小在堆上申请一块内存			
			if (f.Read(pBuffer, nSize) > 0 )    //把txt文件读到pBuffer(堆上申请一块内存)
			{  
				BYTE *pBuf = pBuffer;     ///下面这一大段是把pBuffer里的txt数据放到库中
				VARIANT			varBLOB;
				SAFEARRAY		*psa;
				SAFEARRAYBOUND	rgsabound[1];				
				if(pBuf)
				{    
					rgsabound[0].lLbound = 0;
					rgsabound[0].cElements = nSize;
					psa = SafeArrayCreate(VT_UI1, 1, rgsabound);
					for (long i = 0; i < (long)nSize; i++)
						SafeArrayPutElement (psa, &i, pBuf++);
					varBLOB.vt = VT_ARRAY | VT_UI1;
					varBLOB.parray = psa;
					m_pRecordset->GetFields()->GetItem("mdata")->AppendChunk(varBLOB);
				}
				m_pRecordset->Update();				
				delete [] pBuffer;     //删掉堆上申请的那一块内存
				pBuf=0;                //以防二次乱用
			}
			f.Close();					
		}			
	}
		GetDlgItem(IDC_BUTTON2)->EnableWindow(false);
		GetDlgItem(IDC_BUTTON1)->EnableWindow(true);
}
//----------输出数据用于和原始数据对比----------------------------------