mdb数据库的操作

void CPopManuDlg::LoadBookInfo(BOOL IsDesc)
{
	m_list.DeleteAllItems();
	CString sql;
	if (!IsDesc)
		sql = "Select * from tb_bookinfo ORDER BY PRICE ASC";
	else
		sql = "Select * from tb_bookinfo ORDER BY PRICE desc";
	CString fieldvalue;
	m_pRecord = m_pCon->Execute((_bstr_t)sql,NULL,adCmdText);
	int i = 0;
	while (! m_pRecord->ADOEOF && !m_pRecord->BOF)
	{	
		m_list.InsertItem(100,"");

		fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("bookname")->Value;
		m_list.SetItemText(i,0,fieldvalue);

		fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("barcode")->Value;
		m_list.SetItemText(i,1,fieldvalue);

		fieldvalue =(TCHAR*) (_bstr_t)m_pRecord->GetFields()->GetItem("author")->Value;
		m_list.SetItemText(i,2,fieldvalue);