//根据SQL语句生成记录集
m_pRecordset.CreateInstance(__uuidof(Recordset));
_variant_t RecordsAffected;
CString vSQL;
vSQL.Format("SELECT * FROM 固定钻套 WHERE 孔径大于<'%f' and 孔径到>='%f'",m_DHole,m_DHole);
m_pRecordset=m_pConnection->Execute(_bstr_t(vSQL),&RecordsAffected,adCmdText);
if((m_pRecordset->adoBOF)&&(m_pRecordset->adoEOF))
{
AfxMessageBox("没有满足条件的记录!");
m_pRecordset->Close();
return;
}