MFC 数据库查找

CString  name;
_bstr_t strSQL;
_variant_t RecordsAffected;
GetDlgItemText(IDC_NAME,name);
 strSQL="select * from 热食 where 菜名='"+name+"'";
 m_pRecordset=m_pConnection->Execute(strSQL,&RecordsAffected,adCmdText);
m_list_hot.DeleteAllItems();
      _variant_t NAME,PRICE,PATH, PIC;
 CString price,path,pic;
   _bstr_t sno;
 int num=m_list_hot.GetItemCount();
 while(!m_pRecordset->adoEOF)
 {
  NAME=m_pRecordset->GetCollect("菜名");
PRICE=m_pRecordset->GetCollect("价格");
PATH=m_pRecordset->GetCollect("路径");  
name=(LPCTSTR)(_bstr_t)(NAME);
price=(LPCTSTR)(_bstr_t)(PRICE);
path=(LPCTSTR)(_bstr_t)(PATH);
m_list_hot.InsertItem(0,_T(""));
  m_list_hot.InsertItem(num,name);
m_list_hot.SetItemText(num,1,price);
m_list_hot.SetItemText(num,2,path);
m_pRecordset->MoveNext();
AfxMessageBox("查询成功！");
 }