void COneDlg::OnButton2()   //----------------txt數(shù)據(jù)存入數(shù)據(jù)庫------------
{
	CFile f;
	CString  FilePathName;
	CFileException e;	
	CFileDialog dlg(TRUE,NULL,NULL,0,"txt Files (*.txt)|*.txt||",this);///TRUE為OPEN對話框，F(xiàn)ALSE為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];  //按文件的大小在堆上申請一塊內(nèi)存			
			if (f.Read(pBuffer, nSize) > 0 )    //把txt文件讀到pBuffer(堆上申請一塊內(nèi)存)
			{  
				BYTE *pBuf = pBuffer;     ///下面這一大段是把pBuffer里的txt數(shù)據(jù)放到庫中
				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;     //刪掉堆上申請的那一塊內(nèi)存
				pBuf=0;                //以防二次亂用
			}
			f.Close();					
		}			
	}
		GetDlgItem(IDC_BUTTON2)->EnableWindow(false);
		GetDlgItem(IDC_BUTTON1)->EnableWindow(true);
}
//----------輸出數(shù)據(jù)用于和原始數(shù)據(jù)對比----------------------------------