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("查询成功!");
}
_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("查询成功!");
}